Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need Help with ODBC error
Message
From
08/10/1998 13:59:10
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Need Help with ODBC error
Miscellaneous
Thread ID:
00145135
Message ID:
00145135
Views:
75
Hi everybody: I am working with VFP 5.0 and SQL 6.5. I have a simply query store that I execute many times in the same day. I Always use 2 parameters to handle the errors in case I had one. This name are SqlNumberError and SqlError. The first one is integer and the second is Char. Sometimes the ODBC returns me the following error:

"[Microsoft][ODBC SQL Server Driver][SQL Server]Implicit conversion from datatype 'text' to 'char' is not allowed.  Use the CONVERT function to run this query."

I don't know why I receive this message, because I don't use Text or Char. Which is the difference? Does anyone know where is the error? Is in the Front End or in the Back End?
Thanks in Advance!

Roberto Comolli        e-Mail : RComolli@disco.com.ar
Disco SA
Larrea 847
1117-Buenos Aires
Argentina
Next
Reply
Map
View

Click here to load this message in the networking platform