Re: Foxpro Remote MySQL Connectivity
Posted by: Tuomo Lahti
Date: June 06, 2012 03:23PM

Hi!

Have you allready try:

lcStringConn="Driver={MySQL ODBC 3.51 Driver};Port=3306;Server=192.168.0.13;Database=test;Uid=root;"
SQLSETPROP(0,"DispLogin",3)
lnHandle=SQLSTRINGCONNECT(lcStringConn)
MyQry="select * from table1"
SQLEXEC(lnHandle, MyQry ,"MyView",rows)

if rows(1,2)<1
=aerror(errmess)
messagebox(errmess(1,2))
else
messagebox("Founded:"+alltrim(str(rows(1,2)))+" rows")
SELECT MyView
BROWSE
endif


hopefully this helps.

Options: ReplyQuote


Subject
Views
Written By
Posted
8723
May 11, 2012 01:23AM
Re: Foxpro Remote MySQL Connectivity
2765
June 06, 2012 03:23PM


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.