Connect to mySQL from DSN using ODBC drivers??

[franki]

A client asked me that. If he can connect to mySQL from DSN with ODBC drivers. I didn't know the answer. Could someone help me? Is it possible or not??

cPanel.net Support Ticket Number:

 

[Jemshi]

as far as I know, this is for windows.



cPanel.net Support Ticket Number:

 

[franki]

mySQL provides RPM's for Linux, as well.

http://www.mysql.com/downloads/api-myodbc-3.51.html

Has anyone tried it? I have already succesfully installed the x86 RPM (myODBC-3.51) but I don't know if it works.

cPanel.net Support Ticket Number:

 

[furtherahead]

myODBC

Yes -- it works great...

In one project we completed we successfully connected an MS Access desktop database to mySQL on the web via myODBC in order to import records from the online database and mark the online records as downloaded so that they didn't get downloaded again...

Its pretty straightforward -- install myODBC, then setup a new DSN using the mySQL Driver

cPanel.net Support Ticket Number:

cPanel.net Support Ticket Number:

 

[franki]

Re: myODBC

Originally posted by furtherahead
Yes -- it works great...

In one project we completed we successfully connected an MS Access desktop database to mySQL on the web via myODBC in order to import records from the online database and mark the online records as downloaded so that they didn't get downloaded again...

Its pretty straightforward -- install myODBC, then setup a new DSN using the mySQL Driver

cPanel.net Support Ticket Number:

cPanel.net Support Ticket Number:

You installed myODBC on a Linux server, right?

cPanel.net Support Ticket Number:

 

[franki]

I'm completely lost now..
What do I have to install? x86 RPM myODBC-3.51 on the Linux server OR Windows myODBC-3.51 on my local PC???

I want to connect FROM my local pc TO the Linux server.

 

[jsteel]

Just have them go to the mysql site and download the mysql odbc driver and install it on their local windows machine that has Access.

Then have them set up the access hosts entry under the Manage MySQL section of their cPanel so that their remote machine's hostname or IP address (wildcards permitted) is listed.

Now they can use Access to connect to their MySQL databases. They would use the dataabse and database user they created for the login info, their domain name for the server and the standard 3306 as the port.

cPanel.net Support Ticket Number: