Changing from Odbc to OleDb (Sql Server)

General discussion forum about all databases other than SqlBase.
Kiki7

Changing from Odbc to OleDb (Sql Server)

Post by Kiki7 » 27 Jun 2008, 07:18

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

Re: Changing from Odbc to OleDb (Sql Server)

Post by Jean-Marc Gemperle » 09 Jul 2008, 11:39

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

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 2 guests