ODBC Vs OLEDB connection performance in win32

General discussion forum about all databases other than SqlBase.
a_sivababu
India
Posts: 503
Joined: 10 Mar 2017, 08:46
Location: Chennai,India

ODBC Vs OLEDB connection performance in win32

Post by a_sivababu » 15 May 2015, 11:58

Hi All,
The win32 application with SQL Server ODBC is much faster than SQL Server OLEDB/SqlUDL connection .

I have to go with this way since OLEDB is natively supports to store multilingual characters without N' in front of the Unicode characters.

Is there anyone who had experienced the above issue?

Your assistance in this matter is very much appreciated!


Thanks!
Siva A

User avatar
markus.essmayr
Austria
Posts: 892
Joined: 06 Mar 2017, 06:07
Location: Austria

Re: ODBC Vs OLEDB connection performance in win32

Post by markus.essmayr » 17 Jun 2015, 06:59

Hi,

we also hat performance issues when using OLEDB with SQLNCLI.
After some research we found, that our OLEDB driver was configured to use Named Pipes before TCP/IP as the network protocol which caused the performance drop.

To solve that, we added "Network Library=DBMSSOCN" to our connection string.
Prefixing your server name with "tcp:" should also work.

Max
Markus Eßmayr
teamdeveloper@t-mx.com

a_sivababu
India
Posts: 503
Joined: 10 Mar 2017, 08:46
Location: Chennai,India

Re: ODBC Vs OLEDB connection performance in win32

Post by a_sivababu » 17 Jun 2015, 08:41

Thanks Max. Good. Let me also try that. However, I have disabled named pipe in Server level and use only TCP/IP

But changing the application to SqlUDL is not going to be cakewalk as most of the queries where failing with some syntax issue which it was working fine in traditional way of connection over sqldatabase.

Thank you once again

Regards
Siva A

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 1 guest