Page 1 of 1

mySQL & ODBC

Posted: Wed Feb 15, 2006 4:13 pm
by JasonTC
Is it possible to have both mySQL and ODBC on the same machine simoltaneously? Not necessarily running at the same time, but having them both installed, so I can switch back and forth. The company I work for uses Access but I want to get some mySQL experience.

Posted: Wed Feb 15, 2006 4:16 pm
by feyd
Yes. In fact, there's an ODBC hook for MySQL. :)

Posted: Wed Feb 15, 2006 4:27 pm
by JasonTC
What is an ODBC hook?

Posted: Wed Feb 15, 2006 4:30 pm
by feyd
It'll make MySQL respond to ODBC requests.

Posted: Wed Feb 15, 2006 4:32 pm
by JasonTC
So if I install mySQL on my computer with ODBC already in place, will everything still function with no problems? Is there anything special I have to do?

Posted: Wed Feb 15, 2006 4:37 pm
by feyd
They shouldn't interfere with each other unless you install the MySQL ODBC hook, which is a separate download.

Posted: Wed Feb 15, 2006 6:53 pm
by RobertGonzalez
Are you trying to connect to two different DB's from the same script? If you are, make sure you use an identifier for your $link parameter in your database connection functions. I have done this on my local development server, connecting to MySQL, Access and SQL Server all in the same script.

Posted: Thu Feb 16, 2006 12:33 pm
by JasonTC
That's cool to know that that's possible, but that's not what I need to do. I just want to teach myself how to use mySQL without messing up the existing Access stuff. I downloaded and installed mySQL, but I don't really know what to do now.

Posted: Thu Feb 16, 2006 1:27 pm
by RobertGonzalez
Oh, so you're asking if the databases can be on the same server without causing any conflicts. I get it! Amazing how fast I can complicate something.

To answer your question appropriately, yes, you can have MySQL, Access, SQL Server, PostgreSQL, yada yada, all on the same machine withour porking your system. I have MySQL, Access and SQL Server Express on my development machine right now and there are no conflicts.