Page 1 of 1

MySQL access from LAN

Posted: Fri Feb 19, 2010 5:24 pm
by rdonnay
I'm having trouble accessing my phpBB database from an Xbase++ application on a networked computer.

I can get access to the database only with an app that runs on the server.

This connection string works:

Code: Select all

DBE=ODBCDBE;Driver={MySQL ODBC 5.1 Driver};Uid=<myid>;Pwd=<mypwd>;Database=BulletinBoard;Server=LocalHost
This connection string doesn't work

Code: Select all

DBE=ODBCDBE;Driver={MySQL ODBC 5.1 Driver};Uid=<myid>;Pwd=<mypwd>;Database=BulletinBoard;Server=192.168.0.50
The LAN address of the server is 192.168.0.50 but I can't connect to that address even if running on that server.

I tried adding the following to MY.INI:

Code: Select all

bind-address=0.0.0.0
Still no go.

Does anyone have experience with MySQL and ODBCDBE?

Re: MySQL access from LAN

Posted: Thu Feb 25, 2010 12:42 am
by Rudolf Reinthaler
Hello Roger,
have some applications with MySQL connection to a LINUX Server. This is my connect string:
DRIVER=MySQL ODBC 3.51 Driver;SERVER=10.10.10.67;DATABASE=ctpen;UID=test;PWD=admin;
regards
Rudolf

Re: MySQL access from LAN

Posted: Thu Feb 25, 2010 7:51 am
by rdonnay
Do you have any special entry in your MY.INI file?