PostgreSQL ODBC for Windows DSN-Less Connection

This tutorial shows how to verify your driver installation and connect to a PostgreSQL database using a DSN-less connection string at the command line. (DSN is a data source name.) The tutorial uses the JDBC4 PostgreSQL Driver, Version 8.4 to connect to a PostgreSQL 9.2 database on the Windows^® 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.

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, database name toystore_doc, user name username, and password pwd.

   dsnless = strcat("Driver={PostgreSQL ANSI(x64)}; Server=localhost; ", ...
      "Database=toystore_doc; UID=username; PWD=pwd");
   conn = odbc(dsnless);

2. Close the database connection.

   close(conn)