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?