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
_______________________________________________
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.
