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.

All Forums  Old Forums  CLOSED - SQL Server 2005/Yukon  SQL Server 05 64-bit and 32-bit ODBC for Sybase

Author  Topic  ewebb02 Starting Member 6 Posts Posted - 2006-04-20 : 10:50:36 I'm trying to get my 64-bit SQL 05 DB (Running on Windows Server 2003 64-bit edition) to talk to a 32-bit Sybase Server using a 32-bit ODBC connection. I got it to talk fine when setting up the SSIS package, but whenever I try to run it, I get an error. I'm running it manually, not through a deployed SQL Job, just through the BI studio. Is there a way to get these two machines to talk to one another? Any suggestions would be most appreciated.