MySQL access from LAN

[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?

[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

[rdonnay]

Do you have any special entry in your MY.INI file?