SQL Server ODBC Connection String Example using Driver 17
This is a connection string for connecting to a SQL Server database using the ODBC Driver 17.
The parameters in the connection string are as follows:
- DRIVER: Specifies the ODBC driver to use for the connection.
- SERVER: Specifies the server name and instance name, separated by a backslash.
- DATABASE: Specifies the name of the database to connect to.
- UID: Specifies the user ID to use for authentication. The format is 'domain\username'.
- PWD: Specifies the password to use for authentication.
In this example, the ODBC driver is set to 'ODBC Driver 17 for SQL Server', the server name is 'LAPTOP-B0JN4S9A\SQL1', the database name is 'sql0', and the user ID is 'LAPTOP-B0JN4S9A\songx'. The password parameter is left empty, so it will need to be provided when establishing the connection.
原文地址: https://www.cveoy.top/t/topic/lM32 著作权归作者所有。请勿转载和采集!