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 |
|
daniel2000
Starting Member
3 Posts |
 Posted - 2009-04-01 : 10:30:53
|
| I have a Windows 2003 Server SP2 64-Bit with two instances of SQL Server 2005 SP2 installed. One instance is 64-Bit, the other is 32-Bit.I also have ingres 3.0 32-bit client installed. Within c:\windows\syswow64\odbcad32.exe I have created an ODBC connection to my ingres database (system dsn).From the 32-bit sql server instance I am able to create a linked server pointing to this system dsn and can successfully select data from it.I need to do the same thing from the 64-bit sql server instance. Can anyone help?cheersDaniel |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-04-01 : 10:34:46
|
| Does it have 64-bit driver? |
 |
|
|
daniel2000
Starting Member
3 Posts |
Posted - 2009-04-01 : 11:02:20
|
| I have 64-bit MSDASQL installed. The ingres driver is 32-bit. |
|
|
|
|
|
|
Ingres linked server please help