Test connection failed because of an error in initializing p

Redshift related discussions

Test connection failed because of an error in initializing p

Postby danielbos » Fri Oct 18, 2013 2:25 pm

Hi all,

I am evaluation the Redshift provider but I can't get it to work.

What I did is:
- Install the Redshift provider
- Opened SSDT (2012)
- Created a MSSQL OLE DB source
- Created a Redshift target
When creating the target I filled in the server connection details including the AWS S3, as said by the manual.

When I click on 'test connection' I get:

TITLE: Connection Manager
------------------------------

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

------------------------------
BUTTONS:

OK
------------------------------

I really would like to test out the product if it works and have the performance benefits as described.

Could you help me out?

Regards,

Daniel
danielbos
 
Posts: 8
Joined: Fri Oct 18, 2013 2:19 pm

Re: Test connection failed because of an error in initializi

Postby Moderator » Thu Oct 24, 2013 10:11 pm

As we found later it was a user error: database name was not specified correctly.
User avatar
Moderator
Site Admin
 
Posts: 305
Joined: Wed Oct 29, 2008 11:27 pm


Return to Redshift OLE DB Provider

Who is online

Users browsing this forum: No registered users and 1 guest

cron