I have a connection string that references all of the exact same parameters except server, database name, UID and PWD for 2 databases.
The connection to one works perfectly, the other fails in the exact same function. I get a 3151 error
Err.Description is "ODBC--connection to '{PostgreSQL Unicode}IP_address' failed where IP_address is the actual server.
tdf.Connect = "ODBC;Driver={PostgreSQL Unicode};Server=IP_address;Port=5432;Database=myDataBase;
Uid=myUsername;Pwd=myPassword;"
I'm trying to use dsn-less connections to make it easier for users in multiple locations to connect.
I connected to the tables via a system data source for testing purposes and I can gleefully open them from both databases and read and write to them.
The oddity is that when I try to use a string variable for the connection string, when I debug.print tdf.Connect on either of them, the one that fails doesn't have the driver parameter in it any longer so I'm using the entire string for tdf.Connect.
Thoughts? Ideas? TIA!