General information
Title:
255 Character Restriction on SQL Statements Passed from ADO
Hi All.
I'm trying to use Visual Basic and Visual C++ (both 6) with ADO to Query a VFP database, usually this works fine and I'm happy with the results, except when the SQL statement is long (256 characters or over) I recieve the error
[Run-time error '-2147217900 (80040e14)' Command contains unrecognized phrase/keyword]
After speaking to people at DevCon (I can't remember who) I was told that this had been fixed already, but even after updating my OLEDB provider to the one shipped with the VFP 8 beta the error still occurs.
My Connection string is "Provider=vfpoledb.1;Data Source=Path\To\My.DBC", I can post the VB code to repeat my problem if anyone would like me to.
I would be most greatfull if someone could point me in the right direction in fixing this please.
Thanks in Advance.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only