Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Can I use OLE DB Providers with ODBC Socket Server?

April 26, 2017DB ODBC OLE server socket

0

Posted

Can I use OLE DB Providers with ODBC Socket Server?

2 Answers

0

Posted

Absolutely! You do not always need to create an ODBC Data Source to use ODBC Socket Server. By using an OLE DB Provier you can increase the speed of your application greatly. Just use the OLE DB Connection String instead of the usual ODBC Socket Server connection string. A sample OLE DB connection string is: Provider=SQLOLEDB.

0

Posted

Absolutely! You do not always need to create an ODBC Data Source to use ODBC Socket Server. By using an OLE DB Provier you can increase the speed of your application greatly. Just use the OLE DB Connection String instead of the usual ODBC Socket Server connection string.