I havent done any FoxPro pgmming but if u
could you get the error message returned from Mysql..
It sounds like user privilege problem...
Cheers!
Thiru
On Thu, 22 Feb 2001 11:15:23 +0800
"edith" <[EMAIL PROTECTED]> wrote:
-> Dear Sir/Madam,
-> I'm a Visual FoxPro programmer. I want to use MySQL database for my programs.
However, I cannot update MySQL database with my Visual FoxPro programs through ODBC
(but I can view the record of table). My commands are as follow:
-> CREATE CONNECTION conn1 DATASOURCE "MySQL" USERID "users" DATABASE "tempdata"
-> STORE SQLSTRINGCONNECT('dsn=MySQL; uid=root; pwd=') TO xConnHandle //return
of 'xConnHandle' is positive that means connection is successful//
-> =SQLSETPROP(xConnHandle,'Transactions',2) //this return is negative that
means there is an error on connection level//
-> I don't know why I can view the table but I cannot update the table through ODBC.
Would you help me to solve this problem? Thank you!
-> Regards,
-> Edith
->
-----------------------------o0o----------------------------------------
"There is no finish line, you can always learn"
"You have to keep pressure on yourself, you have to work on your weaknesses".
Thiru
S/W Engineer, Service Dvlpment Group
Infoseek,Japan Voice - (81)-3-5453-2056
http://www.infoseek.co.jp <- Click Here
http://www.rakuten.co.jp <- Click Here
http://house.infoseek.co.jp <- Click Here
http://profile.infoseek.co.jp <- Click Here
http://chat.infoseek.co.jp <- Click Here
--------------------------------------------------------------------
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php