Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
qman
Constraint Violating Yak Guru
442 Posts |
 Posted - 2011-07-25 : 12:44:45
|
| I have a Windows 2008 64BIT server running SQL 2008 R2.I have defined system ODBC's which point to a DB2 DB.Why am I unable to create an ODBC connection via the Connection Manager? When I go to select my ODBC, the list is empty.It appears SSIS is pointing to the list of 32bit ODBC's which in my case, there are none. How can I get SSIS to look to the 64bit ODBC manager/list of ODBC?ThanksQ |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-07-25 : 12:49:47
|
| what have you set as value for 64bitruntime property in debug properties?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
qman
Constraint Violating Yak Guru
442 Posts |
Posted - 2011-07-25 : 12:54:40
|
| That value is set to True at the moment. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-07-25 : 13:00:37
|
| then it should look for 64 bit connectors . if its not finding there might not be one.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
qman
Constraint Violating Yak Guru
442 Posts |
Posted - 2011-07-25 : 13:04:59
|
| It looks to be pointing to the 32 bit ODBC's no matter if the 64bitruntime property is set to true or false. I have three 64 bit ODBC's defined in the 64 bit ODBC manager.For a test, I created 3 32 bit ODBC's which show up no matter which setting the 64bitruntime property is set for.Weird.... |
|
|
|
qman
Constraint Violating Yak Guru
442 Posts |
Posted - 2011-07-25 : 14:33:05
|
| It appears that Visual Studio 2008 is only 32 bit, and as such does not support 64 bit ODBC's. I am forced to use the 32 bit ODBC manager. |
|
|
|
|
|
|
Can't create ODBC Connection.