erro about using odbc vist mysql
"libing" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <001601c744f5$d854c960$1501a8c0@hilltop> |
hi good everyone,
i use odbc visit remote mysql(mysql Ver 14.3 Distrib 5.0.0-alpha) but display this error log!
error log:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '{ call testme(1002, 104) }' at line1
but i execute "call testme(1002,104)" in mysql that is successful! i also find a lot of datum but no result .
mysql procedure code is:
create procedure testme(mycode varchar(10),seatcode varchar(10))
select mobilephone from e_user where uri=mycode and aligncode=seatcode
i expect your reply!thank you!
regards
LiBing
------------------------------------------------