Connection string odbc

What is an ODBC connection string?

ODBC connection strings consist of user credentials and the database address. Their scope is determined by the user's permissions on the target database.

Microsoft SQL Server ODBC Driver connection strings

Driver={driver_name};Server=server_name;Database=database_name;Uid=username;Pwd=password;

• Driver: The ODBC driver to use (e.g., {SQL Server}, {MySQL ODBC 8.0 Driver}, etc.).
• Server: The address of the server (IP address or hostname).
• Database: The name of the database you want to connect to.
• Uid: The username for database access.
• Pwd: The password for the specified username.

Trusted connection

Driver={driver_name};Server=server_name;Database=database_name;Trusted_Connection=Yes;

Non-standard port

Driver={driver_name};Server=server_name,port_number;Database=database_name;Uid=username;Pwd=password;

If your SQL Server is configured to listen on a non-default port, you can indicate this in the connection string by using the syntax servername,port.

For example, if your server name is myServer and it listens on port 1234, the connection string would look like this: myServer,1234. This allows you to connect to the server on the specified port instead of the default port.