2

Closed

Can't connect to source

description

Hello,

I have built an OLE DB Connection string using the "Edit" button on the Source Connection screen. I am able to test this connection while in the Edit dialog and it works.

When I go back out to Source Connection and use the pull down on "Table, View, or Synonym", nothing happens. This is not a permissions issue on the database; userid being used can see everything.

If I click in the OLD DB Connection String box again I will get an error message "Source connection cannot be opened"

Do you have an idea what I am doing wrong? .NET 4.5 is installed. Have tried multiple databases, multiple database types, and multiple connection methods.

Thanks
Nemo
Closed Jan 13, 2016 at 9:04 PM by kamiln

comments

kamiln wrote Sep 15, 2015 at 9:46 AM

Yes. I have the same issue on two separate computers.

wrote Sep 15, 2015 at 9:46 AM

kamiln wrote Sep 15, 2015 at 11:44 AM

I've check the issue in source code.
It's happen if you created connection with specific user name and password.
WORKAROUND:
After exit from "Data Link Properties" window - fix connection string with following steps:
1) Delete fragment: Integrated Security="";
2) Add (e.g. at the end of string): Password=XYZ;
Obviously, change XYZ to your password :)

wrote Sep 23, 2015 at 11:05 PM

wrote Oct 15, 2015 at 12:02 AM

wrote Jan 13, 2016 at 9:04 PM

Resolved with changeset 29535: Added an alternative method of connection.
Added new a comparison method of columns