I would like to learn how to set a connection string.
I am running pgsql 9.0 on an XP. I found a list of connection string
examples:
» dotConnect for PostgreSQL (former Core Labs PostgreSQLDirect)
(PgSqlConnection)
» Npgsql (NpgsqlConnection)
» PostgreSQL OLE DB Provider
» .NET Framework Data Provider for OLE DB (OleDbConnection)
» PostgreSQL ODBC Driver (psqlODBC)
» .NET Framework Data Provider for ODBC (OdbcConnection)
I am trying to connect with SQL Maestro. Since pgsql provides an ODBC
driver, it seemed appropriate to work with the PostgreSQL ODBC Driver.
The suggested connection string is:
Driver={PostgreSQL};Server=IP
address;Port=5432;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
I do not know if I should leave the {PostgreSQL} as is or should it be
replaced with something.
For Server, the connection is on the same machine so I would think the
value should be ‘localhost’ (without quotes).
For Database, I don’t know if this should be the name of a database
inside of my pgsql server or something else.
When I run:
Driver={PostgreSQL};Server=localhost;Port=5432;Database=myDataBase;Uid=user101;Pwd=pw101;
I get a message window that says “[Microsoft][ODBC Driver Manager]
Data source name not found and no default driver specified”.
The driver is supposed to be inside of a pgsql DLL but I don’t know
how Windows is supposed to find it. How should I set up the
connection string?
ray