Insufficient data from Andrew Fryer

The place where I page to when my brain is full up of stuff about the Microsoft platform

64 bit odbc connectivity to SQL Server

64 bit odbc connectivity to SQL Server

  • Comments 4
  • Likes

Working for Microsoft is strangely like working for the government, yu are essentially trying to please everyone, but there are significant minorities on any given issue who aren’t that satisfied.

Let me explain with a real world example..

The lack of 64 bit jet and odbc drivers mean that anyone trying to get data into 64 bit SQL Server from Excel and Access has to do all sorts of chicanery.  Clearly those affected feel this is a big issue - after all this is simply a case of moving data from one Microsoft product to another. Virtually every Business Intelligence project is affected by this as there is always some niche data in Excel or Access that is needed in the data warehouse and typically these projects rely on 64 bit SQL Server.

So why is this issue still hanging around? The answer is democracy, there have been more people asking the office and SQL Server teams for other features than for this one. Eventually this issues will be a high enough priority to make it worthwhile to do and that may well happen in Office 14 (but I am making no promises here). 

Where Microsoft differs from Government is that you can often vote on a given issue rather than just vote in a party and leave them to get on with it. So if you are really unhappy about the lack of 64 bit odbc support then please please register your concerns on connect, and when you search for this issue as I did you realise that there a whopping 65 votes for it, last time it was raised over a year ago, and maybe thaa’s why the product teams haven’t picked up on it! 

  • 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:

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

  • 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!

  • 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. :)

  • 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

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


Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment