Collections:
Adding a New DSN with the ODBC Driver for SQL Server
How To Add a New DSN with the ODBC Driver for SQL Server?
✍: Guest
Assuming that the ODBC driver for SQL Server has been installed as part
of the Windows system, the next step of setting up ODBC connection to SQL Server
is to create a new DSN (Data Source Name) with the ODBC Data Source Administrator:
You should a list of all ODBC drivers installed on your system. SQL Server ODBC driver should be on the list. If you look at the picture below, you will see the SQL Server ODBC driver with version 2000.85.1117.00, file SQLSRV32.DLL, date 8/4/2004:
Select "SQL Server" from the ODBC driver list, and click "Finish" button. The "Create a New Data Source to SQL Server" wizard window shows up. Continue with the next tutorial to finish up creating a new DSN.
⇒ Defining the Name and Server for a new DSN
⇐ What Is ODBC (Open Database Communication)?
2024-08-06, 3453🔥, 0💬
Popular Posts:
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
How To Select All Columns of All Rows from a Table in Oracle? The simplest query statement is the on...