Topic: mysql question

[steveb12]

Hi,

The company I work for develops a database application using Microsoft Access.  One of our clients has several Windows machines running the front end database and the tables are linked to a backend mdb file residing on an sme server.  Now, this client wants to expand drastically, so we would like to change the data storage to MySQL and link the tables through ODBC on all of the Windows machines.  

I know that the SME server we have is running MySQL 3.23.56 and I've installed the mySQL ODBC driver, ver 3.51, on my machine.  However when I try to connect to the mysql server on the sme server I get the following error:

[MySQL][ODBC 3.51 Driver] Can't connect to MySQL server on 'outserver'(10061)

I used the GRANT command to setup a user on the test database so I think my login info is ok.  Could it be the driver, ver 3.51, can't talk to the server, ver 3.23.56?  

Now, I used a nifty little program that scans a LAN and returns info about all the computers on the network which includes what ports on each machine are open and closed.  When I looked at the SME server port #3306, which is the default for the ODBC driver, is closed.  What port number does the SME server start the mySQL daemon on?  If it is 3306 would the fix be just opening the port on the server?  If so, how would I go about doing that?

Help and suggestions would be greatly appreciated.

-Steve

[jbillings]

Here is a link that might help that someone posted in another thread.

http://www.by-users.co.uk/forums/?board=faqs&action=display&num=1050430682

[Boris]

Steve,
you didn't mentioned the version of SME used. Starting from SME6, MySQL network connection is disabled by default and version 5.6 had a bug that required "glibs" update in order for it to work.