Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Connection Problems
69 views
Skip to first unread message
dagoro
Mar 31, 2010, 11:51:02 AM3/31/10
to
Hi,
I've connected (ODBC) to a Visualfoxpro database with Visual Studio but when
i try to update the table records from VS, I get an error and the changes are
not commited. VISUAL STUDIO ERROR MESSAGE is below:
No row was updated
The data in row 2 was not commited
Error Source: VFPODBC.DLL
Error Message: ERROR [22018][Microsoft][ODBC Visual FoxPro
Driver]Operator/operand type mismatch
I've connected (ODBC) to a Visualfoxpro database with Visual Studio but when
i try to update the table records from VS, I get an error and the changes are
not commited. VISUAL STUDIO ERROR MESSAGE is below:
No row was updated
The data in row 2 was not commited
Error Source: VFPODBC.DLL
Error Message: ERROR [22018][Microsoft][ODBC Visual FoxPro
Driver]Operator/operand type mismatch
How can i make the data editable from VS?
Thanks in advance.
Dan Freeman
Mar 31, 2010, 1:19:47 PM3/31/10
to
dagoro explained :
Operator/operand mismatch is most likely caused by a field containing a
string delimiter: 'O'Hara'
Use [ and ] as string delimiters.
Or perhaps you're sending the wrong datatype. This *should* be resolved
in the ODBC layer but the road to hell is paved with good intentions.
:-)
Dan
Craig Berntson
Apr 1, 2010, 12:09:28 PM4/1/10
to
A word of warning. The VFP ODBC driver has not been updated for a VERY long
time and does not support database features that were added after VFP 6.0.
You should use the OLEDB Provider.
time and does not support database features that were added after VFP 6.0.
You should use the OLEDB Provider.
--
----
Craig Berntson
Microsoft MVP
"dagoro" <dag...@discussions.microsoft.com> wrote in message
news:747A3EEB-C1DA-4599...@microsoft.com...
0 new messages