troubleshooting Question

Wine ODBC Connection to MySQL database

Avatar of bjones8888
bjones8888Flag for United States of America asked on
LinuxMySQL Server
7 Comments2 Solutions4435 ViewsLast Modified:
I have a Windows based client/server application and am trying to extricate myself from reliance on Micro$oft.  

My ultimate goal is to provide a remote server based version of my client/server application.

I am VERY new to Linux (Ubuntu 11.10).  I have Wine installed, and MySQL.  In Windows, my application makes an ADO Connection to a SQL Server database.  I would be happy to use an ODBC connection, but haven't figured out how to get that option

I have successfully installed the Jet 4.0 connection using Winetricks.  So I can double-click a UDL file, for example, and see a familiar configuration window.  I select 'Microsoft OLE DB Provider for ODBC databases, and then when I try to build a connection string, my only option is SQL Server.  

I've looked at MyODBC from Oracle, and UnixODBC.  But I am too new to make any sense of how to get it to work.  I have downloaded what appears to be source code for both of these, but don't know what to do with them.  (I told you, I'm VERY new to this.)  How do I get to the MySQL database?

Is there a "knot-head proof" set of instructions?
Join our community to see this answer!
Unlock 2 Answers and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros