Connecting 64 Bit AutoCAD 2012 to 32 Bit Access 2010

[jvangeld]

Hello everyone, I am working to resurrect some old AutoLISP routines that moved data generated by AutoLISP into Microsoft Access. I chose to use ADOLisp to move the data into Access. On my 32 bit development machine everything works perfectly. But now I am trying to deploy it to production machines that have the following specs:

Windows 7 64 bit

AutoCAD Map 3D 2012 64 bit

Access 2010 32 bit

I can go to the appropriate ODBC Data Source Administrator programs (both in SysWOW64 and System32) and see that the 32 bit driver is installed and available to the 32 bit ODBC Data Source Administrator. There is also an appropriate User DSN provider in the 32 bit ODBC program. But when I try to call the provider from AutoLISP, it tells me that the provider cannot be found. This inclines me to think that my 64 bit AutoCAD is not looking in the 32 bit drivers. The error returned by ADOLisp is:

Connecting to the database using "Provider=NewDataSource;DBQ=P:\Jeremy\Development\LISP\ADOLisp\ADOLISP_test.mdb" Connection failed! Visual LISP message Automation Error. Provider cannot be found. It may not be properly installed.

I have been looking for solutions for some time. Switching to Access 64 bit would be less than ideal because there are extensive extensions in Access that would need to be ported.

This is the official Microsoft work around, but it does not appear to address a case where you want to work with both architectures.

http://support.microsoft.com/kb/942976

This is a guy who solved the problem by telling his C# program to build as a 32 bit application. http://forums.techarena.in/windows-x64-edition/698703.htm#post4072639

So, I am wondering if there is a way to convince either AutoCAD or AutoLisp to use the 32 bit ODBC drivers.

Thanks,

Jeremy VanGelder

I-Ten Associates.

[jvangeld]

It appears that Kratz has found the solution.  He wrote a 32 bit program that will accept data from AutoCAD and then connect to Access through the ODBC driver.  I will try it and see if it works for me.

http://kratzindustries.com/CodeRedBlog/?p=92