0

Does anyone know if there are any issues in using the basic ODBC Api for database access on 64 bit Windows Vista/7 systems? This has been my preferred database access technology for a long time, and I'd prefer not moving to ADO or something else if I don't have to. It'll probably be more than a year before my organization moves off 32 bit XP, but I'm kind of looking ahead. For that matter, I don't even know if ODBC was ported (if that's the right word) to 64 bit. Anyone know about this or have some links?

Edited by Frederick2: n/a

2
Contributors
3
Replies
4
Views
7 Years
Discussion Span
Last Post by Frederick2
Featured Replies
  • Guess I should have figured lots of other folks are wondering the same thing and googled it. Found some good info here... [url]http://www.easysoft.com/developer/interfaces/odbc/64-bit.html[/url] Read More

0

64-bit memory addressing enables applications to store large data sets entirely in memory. This eliminates the performance penalty associated with swapping portions of the data in and out to disk

Yea, that's great ... until the lights go out unexpectently :) But that wouldn't matter if the database is read-only anyway, or immediately saves changes to disk on updates.

Otherwise that was an excellent article.

Edited by Ancient Dragon: n/a

0

Yea, that's great ... until the lights go out unexpectently :) But that wouldn't matter if the database is read-only anyway, or immediately saves changes to disk on updates.

Otherwise that was an excellent article.

I did some reading up on Office 2010 which apparently has the 32 bit & 64 bit bundled together, and the default installation is 32 bit which is somehow jerry rigged to supposedly have the same limits as the 64 bit (don't know how that could be?) so why install the 64 bit, as the 64 bit has some compatibility problems with 32 bit apps so that's why the default installation is 32 bit, but you can install the 64 bit if you want, etc......

yea, I'm confused too!!!

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.