Connection Problem

More
9 years 6 months ago #628 by siraj098
siraj098 created the topic: Connection Problem
Hi I have just downloaded the PNG OLEDB driver for evaluation. I am having problem in making the connection through SSIS connection manager. Any advice will be appritaited.

Regards
Siraj

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

More
9 years 6 months ago #630 by Moderator
Moderator replied the topic: Re: Connection Problem
Make sure that the following controls are filled with correct information:
"Server or file name" - computer name with PostgreSQL server (or localhost);
"User name" - PostgreSQL user name;
"Password" - the password.

Click on arrow in "Initial Catalog" combo. The list of databases should be displayed. If the list is empty, then either there is a firewall preventing the connection, or password is not correct.

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

More
9 years 3 months ago #820 by rhino155
rhino155 replied the topic: Re: Connection Problem
Hi,

I'm trying to connect from sql server 2008 SSIS over the WAN to a postgresql using pgnp data source. I'm receiving the following error:

"test connection failed because of an error in initializing provider. Value does not fall within the expected range."

Here are my setting in the SSIS Connection Mgr:

Provider: .Net Providers for OleDb\PostgreSQL Native Provider
Server or File Name: <Target Server IP Address>
Location: <"">
User Name: <user name>
Password : <pswd>

Should the port be included in the ServerName?
I noticed an earlier post suggested appending the database name to the server name? What would be the syntax for that? "ServerName:DatabaseName"? "ServerName/DatabaseName"?

Any help would be appreciated.

Thanks

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

More
9 years 3 months ago #821 by rhino155
rhino155 replied the topic: Re: Connection Problem
Never mind, I figured it out. Actually I clicked on the DataLinks button and filled out the same connection info and it worked.

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

More
5 years 10 months ago #11166 by erin.nichols
erin.nichols replied the topic: Re: Connection Problem
I'm receiving the same error rhino155 was while I'm trying to connect from my machine to a remote machine. I tried the solution that worked for them and it does not for me. Are there any other potential fixes?

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

More
5 years 10 months ago #11167 by Moderator
Moderator replied the topic: Re: Connection Problem
Could you check connectivity from the computer using a UDL file? If DDL connect test worked, please check if all connection string parameters were populated correctly. Let us know if it still did not work. Thank you!

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

Time to create page: 0.083 seconds
Powered by Kunena Forum