Hey all!
I’ve been researching this for the last couple of days and I think I may be screwed, but I thought I’d ask here in case someone had a fix for this.
My client has a 64 bit 2003 server running 64 bit SQL Server. They have some old tech for running their equipment that puts data into an old Access database (97 or 2000, not sure).
I created a 32 bit System DSN for the database, but I can’t create a linked server. One dude on the net cloned the 32 bit registry entries for his ODBC in the 64 bit section and it worked for him, but that didn’t work for me.
The only other solution I’ve found is to install a 32 bit version of SQL Server on the same box and connect Access to the 32 bit one and then connect to the 64 bit one. That seems pretty janky. Our third option on the table is to write a custom service to handle the communication.
Thoughts? Idea?
Thanks!