On 8/9/07, Steve Ellenoff <[EMAIL PROTECTED]> wrote: > Can some of you who have access to MySQL run the following code > (below) and post back your results, along with your version of the > ODBC driver (including sub revision #) & MySQL Engine. >
Hi, Steve: Little buglet in your code, you hard-coded the database name: lcDatabase = "test" ****************************************** lcCStr = "DRIVER="+lcDriver+";SERVER="+lcServer+";DATABASE=test;UID="+lcUserID+";PWD="+lcPassword ?lcCStr should be: lcCStr = "DRIVER="+lcDriver+";SERVER="+lcServer+";DATABASE="+lcDatabase+";UID="+lcUserID+";PWD="+lcPassword ?lcCStr I'd also suggest you set at least some options by including the OPTION= string in the above. Examples at http://fox.wikis.com/wc.dll?Wiki~VFPCommandSQLStringConnect~VFP -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
