SSIS 2008 - ODBC System DSN drop down list empty
-
I'm trying to access several system DSN's that were configured using the Odbcad32.exe utility on a dev server. When I go to create a new data source in my SSIS 2008 package, and pick the ODBC option, the drop down list is empty and I do not see the system DSN's. I'm using SQL 2008, and I'm guessing this might be a security issue. I'm hoping someone has seen this before and has a fix.
-
Can you tell us the versions of both the server and SQL? Is one 64-bit and the other 32-bit?
-
The server is Windows 2008 R2 64bit. The SQL instance is SQL Enterprise 2008 64bit. I'm not sure about the DB2 and Oracle drivers, but they show up in the Odbcad32.exe utility. I believe my client uses ODBC on other machines to connect to the DB2 and Oracle servers, and I'm trying to do the same on the SQL Server, even if that means running the SSIS pacakge in 32bit mode.
-
On 64bit machine there are two version of the ODBC adminstrator application. I suspect you have used the 64bit version and the system setup was made in the 64bit branch of your registry. That's why you are not able to see the settings in Visual Studio (BIDS) because BIDS is 32bit application. What you have to do is find the 32bit ODBC administrator and use this app instead . Another option is to setup File DSN instead and not depend on registry settings.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
-
Do you know for sure the DSNs were set up as System DSNs?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply