Connection Problem

[siraj098]

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

[Moderator]

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.

[rhino155]

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

[rhino155]

Never mind, I figured it out. Actually I clicked on the DataLinks button and filled out the same connection info and it worked.