Main Content

Microsoft SQL Server ODBC for Linux DSN-Less Connection

This tutorial shows how to verify your driver installation and connect to a Microsoft® SQL Server® database using a DSN-less connection string at the command line. (DSN is a data source name.) The tutorial uses the Microsoft ODBC Driver 13.1 for SQL Server to connect to a Microsoft SQL Server 2016 Express database on the Linux® platform.

Step 1. Verify the driver installation.

The ODBC driver is typically preinstalled on your computer. For details about the driver installation or troubleshooting the installation, contact your database administrator or refer to your database documentation on ODBC drivers.

If you need to install an ODBC driver, contact your database administrator or see Install the Microsoft ODBC Driver for SQL Server (Linux).

Step 2. Connect using the DSN-less connection string and command line.

  1. Connect to the database using the DSN-less connection string with the odbc function. For example, this code assumes that you are connecting to the local database server, port number 1433, database name toystore_doc, user name username, and password pwd.

    dsnless = strcat("Driver={ODBC Driver 13.1 for SQL Server}; Server=localhost,1433;", ...
       "Database=toystore_doc; UID=username; PWD=pwd"); 
    conn = odbc(dsnless);
  2. Close the database connection.

    close(conn)

See Also

|

Related Topics