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