Would MyODBC do what you want? I'm using it to connect MS Access to MySQL, and also to connect a Borland Delphi application to a MySQL database. It works pretty well. Consult the FAQ for known glitches with specific applications.
> -----Original Message----- > From: LaBranche, Kevin [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 26, 2003 5:02 PM > To: '[EMAIL PROTECTED]' > Subject: ODBC connection from Windows app to Linux backend? > > > How would I connect my Windows app to a linux MySQL DB. > > Would I just modify the DSN I am using to point to the correct server? > > Thanks, > Kevin > > -----Original Message----- > From: LaBranche, Kevin [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 26, 2003 12:18 PM > To: '[EMAIL PROTECTED]' > Subject: Query not returning what I expect.... > > > The following query returns 0 for sCode instead of a string like > "XXX:XXXXXX". > > I am modifying an existing app from SQL Server 7 so that it > can also run > with a MySQL backend.... > > The existing query in SQL Server 7 works fine > SELECT sDAMIONCode, (sORI + ':' + sDamionCode) as sCode FROM tblORI > > Any hints would be appreciated. > > Kevin > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]