Confused About Difference Between OBDC Driver and OLE DB Provider
We're trying to reconcile what we see under the "ODBC Administrator" application for Windows 7/8 versus what has been referenced on this site under the following drivers/providers:
- SQL Server Native Client 11.0 OLE DB Provider
- Microsoft OLE DB Provider for SQL Server
- SQL Server Native Client 11.0 ODBC Driver
When we look at the "ODBC Administrator" application we see listed both the "SQL Server" driver file "sqlsrv32.dll" and the "SQL Server Native Client 11.0" driver file "sqlncli11.dll".
Here's our confusion:
Why would the "SQL Server Native Client 11.0" driver file "sqlncli11.dll" be listed in the "OBDC Administrator"?
According to the reference on this website the "sqlncli11.dll" is used by the "SQL Server Native Client 11.0 OLE DB Provider" which is an OLEDB provider. So why is it listed as an ODBC driver in the "ODBC Administrator"? See link here and link here
Is the "ODBC Administrator" really referring to "SQL Server Native Client 11.0 ODBC Driver"?
If that is the case that doesn't quite make sense either because the reference on this website says that driver uses the file "sqlncli10.dll" versus the file "sqlncli11.dll" shown in the "ODBC Administrator". See link here.
You can try visiting the following pages to understand the SQL Server ODBC and JDBC Drivers:
ODBC Driver for SQL Server
JDBC Driver for SQL Server
Azure SQL DB connection string is not working unless logged in to azure account
I'm building an Visual C++ project which is connected to Azure SQL database via ODBC, I placed the following connection string that Azure:0 votes0 answersAhmed Ayman4 weeks ago
Making Constant Data Bases to recall in program.
I'm a student learning programming. I need to find out what web address gets my database and server. I need to find out what the database name is.0 votes0 answersBrad Harris4 weeks ago
Connection error IIS10/SQL 2016
I try to transfer a classic-asp-application from Windows Server 2008R2/II7 to 2016/II10 and SQL 2008 to SQL 2016. The application works fine with IIS10 and SQL 2008. Also with IIS7 and SQL 2016.0 votes0 answersPaul H. Niederbracht1 month ago
SSIS package with ODBC source Teradata Deployment issue
SSIS package works fine in Visual Studio, But when deployed it says gives error, SQL Jobs fails execution0 votes0 answersSandesh J1 month ago
Connect to SQl with gMSA
I'm trying to make use of gMSA's to connect from ASP/X code to an MS SQL 2016 server. I've configured the gMSA with permissions on the target database and set up the gMSA on the source server, but can't get a connection string configured to use the account.0 votes0 answersSteve Sirag2 months ago
Non-Standard Port with SQL Server ODBC
Why does the SQL Server ODBC Connection page not mention any example of using a non-standard port? I was incorrectly trying to use the "Port" attribute as "Port=x" but that does not work.0 votes0 answersDavid Garcia5 months ago
NUODB to SQL database migration
Hi Guys I am using SQL Server 2012 , using import and export wizard i want to migrate nuodb databse to sql , but could not find any JDBC data source inside the wizard.0 votes0 answersGautam Raj5 months ago
Connection string issue in connecting to SQL Server
I am trying to connect my C# code to SQL Server. My connection string is not working. It gives the following error: "Format of the initialization string does not conform to specification starting at index 0."0 votes0 answersFaizan Rahman7 months ago
[Microsoft][ODBC Driver Manager] Data source file not found and no default driver specified.
I have a VBA code (in excel 2016) that i use to grab information from a MS SQL server (2008R). The connection works fine on the computer i wrote it on. When i run it on another computer i get the error "[Microsoft][ODBC Driver Manager] Data source file not found and no default driver specified".0 votes1 answerlee avery7 months ago
Remote MySQL Linked Server in SQL Server, only show names of the tables.
Remote MySQL Linked Server deployed in SQL Express Management Studio do not show any content and structure, it only LIST NAME of the tables belongs to the remote connected MySQL database0 votes0 answersAdrian Feldman7 months ago
- Load more posts