64 bit odbc connectivity to SQL Server

re: 64 bit odbc connectivity to SQL Server

Hugh Williams — Thu, 28 Aug 2008 11:59:27 GMT

It is not too complicated as you can use an ODBC Bridge Product like the Multi-Tier ODBC to ODBC Bridge available from OpenLink Software:

http://uda.openlinksw.com/odbc/mt/odbc-odbc-mt/

The would allow you to make a 64bit ODBC client connection back to a 32bit ODBC Driver like Access'es, Excels, or any other ...

re: 64 bit odbc connectivity to SQL Server

Rick — Thu, 28 Aug 2008 18:05:25 GMT

You know, I understand what you're saying and it makes perfect sense. Except for the fact that this particular issue is so egregious. I can't fathom how we thought we could move to a 64-bit environment for data without native JET access. There's tons of data stored in Excel/Access and until the Desktop becomes 64-bit this unpleasant reality will persist. So let's go vote people!

re: 64 bit odbc connectivity to SQL Server

Tony — Wed, 08 Oct 2008 22:42:03 GMT

Yeah this is an issue. This was working well before then when we upgraded to 64 bit it stopped working. As far as I'm concerned, the product is getting worse. :)

re: 64 bit odbc connectivity to SQL Server

Andrew_Fryer — Thu, 09 Oct 2008 20:00:55 GMT

Tony,

I would argue that SQL Server is vastly better in SQL Server 2008, than in 2000 (not least because it runs on x64 now and not just ia64). Having said that I agree it needs to be fixed, so can you hammer away on connect

http://connect.microsoft.com

and start a campaign ot fix it as, you are more likely to be listened to than I am.

Andrew