|
Home > Archive > Sybase ODBC > April 2005 > Implicit Conversion Error
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Implicit Conversion Error
|
|
|
| Hi,
We are getting the following error on our middle tier box
using ODBC connectivity.
[DataDirect][ODBC Sybase Wire Protocol driver][SQL
Server]Implicit conversion from datatype 'INT' to 'VARCHAR'
is not allowed. Use the CONVERT function to run this query.
Server : Win2003
Sybase Open Client : 12.5.1.
Is this a known bug that is addressed in any EBF. If so what
is the EBF #. Anything else that needs to be upgraded to set
this right ?
Thanks and regards,
Ravi
| |
|
| > Hi, I would also be intrested to know if this problem is
common in OLEDB Provider also?
Hi,
>
> We are getting the following error on our middle tier box
> using ODBC connectivity.
>
> [DataDirect][ODBC Sybase Wire Protocol driver][SQL
> Server]Implicit conversion from datatype 'INT' to
> 'VARCHAR' is not allowed. Use the CONVERT function to run
> this query.
>
> Server : Win2003
> Sybase Open Client : 12.5.1.
>
> Is this a known bug that is addressed in any EBF. If so
> what is the EBF #. Anything else that needs to be upgraded
> to set this right ?
>
> Thanks and regards,
>
> Ravi
| |
| Muralidharan 2005-04-05, 8:01 pm |
| This is no bug with either ODBC driver or the DBMS system.
It is an issue with the SQL query thats being sent to the
DBMS.
Query needs to be looked at.
HTH
[color=darkred]
> common in OLEDB Provider also?
>
> Hi,
| |
|
| HI!
ANSI standards changed what was allowed as implicit vs explicit conversion
between 12.4.3 and 12.5.
This behaviour is perfectly legitimate for 12.5, and it is expected that
code
doing this in 12.4.3 will not work in 12.5
However, the standards changed back, so 12.6 is now compatible with the
12.4.3
code again.
Conversion tables are avalible on Sybase web site in documentation
LUK
Użytkownik <Ravi> napisał w wiadomości
news:4252ed6e.5769.1681692777@sybase.com...
> Hi,
>
> We are getting the following error on our middle tier box
> using ODBC connectivity.
>
> [DataDirect][ODBC Sybase Wire Protocol driver][SQL
> Server]Implicit conversion from datatype 'INT' to 'VARCHAR'
> is not allowed. Use the CONVERT function to run this query.
>
> Server : Win2003
> Sybase Open Client : 12.5.1.
>
> Is this a known bug that is addressed in any EBF. If so what
> is the EBF #. Anything else that needs to be upgraded to set
> this right ?
>
> Thanks and regards,
>
> Ravi
|
|
|
|
|