ML!
06-02-2018, 07:58 PM
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!
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!