Changing from Odbc to OleDb (Sql Server)

[Kiki7]

Hi all,
when I change my db-connection from odbc to oledb, in many select, insert and update statements there is no automatic conversion from datatype String in Varchar any more. I have to change all statements from

Code: Select all

:slString

in

Code: Select all

\''||slString||'\'

. Is there a more comfortable possibility then changing all statements? I read something about UDL in SqlCreateSession, but do not know, if it this eliminates my problem.

thanks in advance
Kiki

[Jean-Marc Gemperle]

Hi Kiki,

This somehow rings me a bell...In any case at this level you should not change anything basically it should work as it did with ODBC.
There are couple stuff that are not supported with OLEDB ie
SqlImmediate()/SqlVarSetup() call to store procedure are different now with SqlPrepareSP and some other stuff, but this should not change IMO...and there might be a bug...
What is the error you have, it would help me to find is there is a bug reference..

SqlUDL/Sqconnect is just another way to connect so it would not help, I'm quite sure, I know you use SqlCreateSession/Statment and that is what you should use, SqlUDL is for quick migration and we recommand SqlCreateSession/Statment.

Give some more details and I'll check if it is a known issue.

JM