No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
2 Posted Topics
** database table in visual foxpro ver.7 db2, fields: pid,fl1,fl2,fl3 ** database table in MS SQL database1 database1 fields: field1,field2,field3 Code in fox: SET DATE GERMAN uz1=ALLTRIM(db2.fl1) uz2=ALLTRIM(db2.fl2) uz3=ALLTRIM(db2.fl3) pMySQLstr="DRIVER=SQL Server;SERVER="path+"\SQLEXPRESS;"+"UID="+name+";PWD="+pwd+";Database="+database1" pMySQLhandle=sqlstringconnect(pMySQLstr) SQLSETPROP(pMySQLhandle, 'Transactions', 1) && Automatic transactions SQLEXEC(pMySQLhandle, "update database1 set field1=?uz1, field2=?uz2,field3=?uz3 where id=?pid") SQLDisconnect(pMySQLhandle) ** end sql …
Very similar problem with mine. Everything workk, but no with memo or blob field transfer. If memo length is less then 255 everything is working. I need similar transfer from Visual Foxpro via ODBC connector and my code is: -MySQLstr="DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;"+"PORT=3306 ;DATABASE=xxx;USER=yyy;"+"PASSWORD="+"zzzz"+";OPTION=3;" -MySQLhandle=sqlstringconnect(MySQLstr) -SQLEXEC(MySQLhandle, 'INSERT INTO xx (name,date,[COLOR="Green"][B]memo[/B][/COLOR]) …
The End.