mySQL & ODBC

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
JasonTC
Forum Commoner
Posts: 92
Joined: Wed Nov 02, 2005 11:05 am
Location: Grand Rapids, MI

mySQL & ODBC

Post 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.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Yes. In fact, there's an ODBC hook for MySQL. :)
JasonTC
Forum Commoner
Posts: 92
Joined: Wed Nov 02, 2005 11:05 am
Location: Grand Rapids, MI

Post by JasonTC »

What is an ODBC hook?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

It'll make MySQL respond to ODBC requests.
JasonTC
Forum Commoner
Posts: 92
Joined: Wed Nov 02, 2005 11:05 am
Location: Grand Rapids, MI

Post 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?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

They shouldn't interfere with each other unless you install the MySQL ODBC hook, which is a separate download.
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post 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.
JasonTC
Forum Commoner
Posts: 92
Joined: Wed Nov 02, 2005 11:05 am
Location: Grand Rapids, MI

Post 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.
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post 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.
Post Reply