MSSQL 2005 v:9.0.4035, PGNP.dll v:126.96.36.1997
We just purchased the drivers and while attempting to create a connection object within SSIS (MSSQL 2005), and running the PGNProfiler, I am unable to create a connection. The PGNProfiler returns, “FATAL: database ‘robertv’ does not exist”. robertv is my login not the db. Also, I am not able to see items under the initial catalog dropdown either.
I have filled out all the required params (Postrges server ip, login, password). Test Connection return, “Test connection failed because of an error initializing provider. Value does not fall within the expected range”
Could the drivers not been install correctly? I did not do the install.
Any and all help would be appreciated!