SSIS establish a connection

  • rvallee
  • Topic Author
  • Visitor
  • Visitor
11 years 5 months ago #1019 by rvallee
SSIS establish a connection was created by rvallee
All,
MSSQL 2005 v:9.0.4035, PGNP.dll v:1.3.0.2227

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!

Rob

Please Log in or Create an account to join the conversation.

More
11 years 5 months ago #1020 by Moderator
Rob,
if the provider is visible in the list of providers, then it is installed correctly.

Have you tried to open a test connection from a udl file or from an ADO tool? There could be dozens of reasons why connection cannot be opened, including firewall, incorrect connection configuration, etc. Could you please review recommendations from Users Manual: www.pgoledb.com/index.php?option=com_fil...ask=download&cid[0]=3&Itemid=68 ?

Please Log in or Create an account to join the conversation.

  • rvallee
  • Topic Author
  • Visitor
  • Visitor
11 years 5 months ago #1022 by rvallee
Replied by rvallee on topic Re: SSIS establish a connection
Thanks for the reply. Here is what I did to make it work. First I don't believe that it's your driver. SSIS will not reconize it unless I do...
Create a new OLE connection in SSIS. Once you open the connector setup window, select the Native OLE\DB PostgreSQL Native Provider from the dropdown box, go straight to the "Data Links" button and click it. Supply all the information there. Click OK and test connection. All is fine.

For some reason, SSIS does not like it any other way. At least with me.

Everything is working great now!

Rob

Please Log in or Create an account to join the conversation.

Time to create page: 0.059 seconds
Powered by Kunena Forum