Hi folks! Thanks for the speedy responses last night. I tried SQLYog and the SQLSTRINGCONNECT method and got no results. Finally I decided to call YAHOO! Support and was informed they block all remote connections and would not 'unblock' any. Too bad, I liked it at YAHOO!. Now, since I'm not going to pay for two hosts, I've got to move my website and everything else that's hosted there to some other provider. Bummer!!
Anyway, thanks again. I really appreciate the help! Bill -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of MB Software Solutions General Account Sent: Wednesday, April 01, 2009 11:13 PM To: [email protected] Subject: Re: Connecting To MySql W.N. Pew wrote: > Well, at long last I'm going to try using a remote back end - MySql. Problem > is I can't seem to get the odbc driver (5.1) configured. When I enter the > required information I get an error stating a connection could not be made > to the database. Obviously I'm not entering the info correctly so I'm > wondering if anyone out there knows how to get it done. > > > > The database name is 'pos'. It is on Yahoo! The server name is 'mysql' > instead of the usual 'localhost' and it is connected to my website > 'www.calpictures.com'. I believe my problem is getting all this data into > the "Server:" field correctly on the Data Source Configuration page in the > ODBC Data Source Administrator. Bill, Can you get a connection from any query tool? I use SQLYog -- google it for a free trial version. Once you verify your connection is good, plugging it into a SQLSTRINGCONNECT will be easy. I use this string for my MySQL connections: DRIVER={MySQL ODBC 3.51 Driver};SERVER=db.server.net;UID=userid;PWD=password;DATABASE=testdb;option= 131609 [excessive quoting removed by server] _______________________________________________ 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.
