Home Services Partners Company
One and only 64-bit Oracle ODBC driver for Microsoft Access on Windows 7

One and only 64-bit Oracle ODBC driver for Microsoft Access on Windows 7

October 03, 2012 0 Comments

From consulting with several Oracle shops recently, I have learned that premium Progress DataDirect ODBC connectivity to Oracle databases from MS Access is equally as exciting as the mobile-bigdata-cloud mega trends to many of those organizations today. I remain impressed at the  number of Microsoft Access power users running enterprises today, and this was further confirmed based on the interest in connecting Microsoft Access directly to Salesforce.com using ODBC.  To understand why Oracle shops are flocking to DataDirect for MS Access ODBC connectivity, here are some reasons they shared:

Support multiple versions of Oracle with single ODBC driver.

In an ideal world, all of your database servers would be the latest/greatest version and no one ever has to fly third class on a domestic flight.  For the real world, DataDirect drivers solve all of your application challenges supporting multiple database versions, and we will have Oracle 12 certified before you're ready to go live.

Database Driver Windows 7 Vista Server 2008 Server 2003 XP 2000
Oracle 12 Oracle Wire Protocol 7.1 7.1 7.1 7.1 7.1 7.1
Oracle 11g R1, R2 (11.1, 11.2) 7.1 7.1 7.0 7.0 7.0 7.0
Oracle 10g R1, R2 (10.1, 10.2) 7.1 7.1 7.1 7.1 7.1 7.1
Oracle 9i R1, R2 (9.1, 9.2) 7.1 7.1 7.1 7.1 7.1 7.1
Oracle 8i R3 (8.1.7) 7.1 7.1 7.1 7.1 7.1 7.1

Need easy deployment after upgrading to 32-bit or 64-bit Windows 7 or Server 2008

DataDirect wire protocol technology means no database client libraries need to be deployed to end users; and I've seen MS Access/ODBC deployments across 500+ workstations in an organization. It can be challenging to manage all those 32-bit and 64-bit $ORACLE_HOME locations when multiple versions of the database client are installed side by side. Newer versions of MS Access such as 2010 can be either 32-bit or 64-bit versions, and you are covered by DataDirect's impressive breadth of platform support.

Need consistent high performance Oracle ODBC Drivers

DataDirect delivers superior performance over competing drivers. I consistently hear that performance varies depending on the combinations of database client (8i,9i,10g,11g) and server versions (8i,9i,10g,11g); however the single DataDirect ODBC Wire Protocol driver significantly outperforms the best non-DataDirect benchmark.

It just works

We get that a lot.

How to get started

1. Download a trial of the DataDirect Connect for ODBC Wire Protocol drivers.

2. Set the following MS Access specific connection property per this knowledge article.

3. Launch MS Access 2010 (same steps apply for 2003 and previous versions)

4. Select “Blank Database” template and create access database

5. Click on External Data

6. Click “ODBC Database” Button

7. Next, select where you want to store the data in Access

You're now ready to experience DataDirect connectivity!


What else can DataDirect do for MS Access data?

If you have MS Access databases, and want integration of that data into your business intelligence and data warehousing infrastructure, we have solutions using DataDirect SequeLink to integrate Unix/Linux applications such as SAS, IBM Cognos, SAP Data Services, Business Objects, SSIS, or Ab Initio to name a few. Or you can federate your data within Oracle using the database gateway for ODBC to MS Access or SQL Server Linked Server.  Call 1-800-876-3101 to speak with a live Solutions Consultant to learn more.

Try Free for 15 Days


Sumit Sakar

Sumit Sarkar

Sumit Sarkar is a Chief Data Evangelist at Progress, with over 10 years experience working in the data connectivity field. The world's leading consultant on open data standards connectivity with cloud data, Sumit's interests include performance tuning of the data access layer for which he has developed a patent pending technology for its analysis; business intelligence and data warehousing for SaaS platforms; and data connectivity for aPaaS environments, with a focus on standards such as ODBC, JDBC, ADO.NET and ODATA. He is an IBM Certified Consultant for IBM Cognos Business Intelligence and TDWI member. He has presented sessions on data connectivity at various conferences including Dreamforce, Oracle OpenWorld, Strata Hadoop, MongoDB World and SAP Analytics and Business Objects Conference, among many others. 

Comments are disabled in preview mode.