Use client driver yes

I have found that using the fully-qualified server name seems, in my testing, to be more reliable, especially when connecting to AGs, but you can always try just the server name. One way I test Kerberos is using a simple query run from the source server:.

The Native Client is now over five years old, has been officially deprecated by Microsoft, and, if you want to align to Microsoft's roadmap, you will want to use ODBC. Consider that in , the Native Client was only two years old. In the interest of full disclosure, there is an issue with Graph Tables using linked servers; I reported the issue to Microsoft based on a linked server using ODBC It's not possible to use just ODBC. This is not an optional or interchangeable API.

Why do you need to use only ODBC? I don't know if the scenario is even supported where you run AE through DQ. If it's for some other reason, share details here so folks help come up with alternate solutions.

Sign up to join this community. The best answers are voted up and rise to the top. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Learn more.

Ask Question. Asked 5 years, 9 months ago. Active 4 years, 5 months ago. When writing programs that involve interacting with a database, we need to use connection modules or client drivers to establish a database connection in order to send commands and receive responses in the form of a result set.

It stores the connection details such as the database name, directory, database driver, User ID, password etc. System DSN is used throughout the system such that anyone with proper rights may log in to access the DSN, and must be created on the machine where the SQL Server database program is located. File DSN is stored in a text file with a. DSN extension instead of the Windows Registry. Windows Driver Kit , ensure that your product is reliable and compatible with Windows through the Windows Hardware Lab Kit , learn Windows driver samples.

Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Please rate your experience Yes No. Any additional feedback? Submit and view feedback for This product This page. View all page feedback.