Thanks for the tip about the option string Ted, I hadn't realized you could specify it, cool!
How could I have avoided hard coding the database name? So did you try the example and get the proper results? At 08:17 AM 8/10/2007, you wrote: >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 > > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com 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.