"Connected successfully."
// Create a connection ret = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &sqlEnv); ret = SQLSetEnvAttr(sqlEnv, SQL_ATTR_ODBC_VERSION, (SQLPOINTER)SQL_OV_ODBC3, 0); ret = SQLAllocHandle(SQL_HANDLE_DBC, sqlEnv, &sqlConn); ret = SQLDriverConnect(sqlConn, NULL, connStr, SQL_NTS, NULL, 0, NULL, SQL_DRIVER_NOPROMPT); postgresql odbc driver windows
The PostgreSQL ODBC driver offers several features that make it a popular choice among developers: "Connected successfully
Frustrated, she opened the ODBC Data Source Administrator (that dusty, 32-bit dialog box that looked like it hadn’t changed since Windows 95). There, in the Drivers tab, she saw it: ret = SQLSetEnvAttr(sqlEnv
To configure the PostgreSQL ODBC driver, follow these steps:
You can find the official psqlODBC driver on the PostgreSQL ODBC site :
Windows has two different tools to manage this, depending on your driver architecture: