Re: how to read and write record in the mysql database of internet using Visual Foxpro?
Posted by: Don Weaver
Date: May 07, 2009 07:11AM

Hi Darren,


You need to have a bunch of things in place before the connection string,


(1) Mysql database installed on a server with users,database and firewall configured to allow port 3306.

(2) You'll then need the mysql connector installed on a station and know the public ip of the server. (5.1 appears to be the better version)


(3) The format of the connection string is a follows: (read sqlpassthrough for others)

MySQLstr="DRIVER={MySQL ODBC 3.51 Driver};SERVER=XXX.XXX.XXX.XXX;"+;
"PORT=3306;DATABASE=somedatabase;USER=someuser;"+;
"PASSWORD=somepassword;OPTION=19;"

Note step 1 requires a bunch of other configurations as well so be prepared to read up....


Don

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: how to read and write record in the mysql database of internet using Visual Foxpro?
5357
May 07, 2009 07:11AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.