| Blaise 2006-12-09, 7:13 pm |
| I have a LinkedServer in SQLServer that uses MS-Jet Driver to connect and
query Foxpro (Windows) tables via ADO components in Delphi. Everything has
worked fine for the last two years. Until now.
We just purchased a new 64bit server running Windows (2003 RC? - Zeon 64bit
processor), but still running SQLServer2000 with SP4 patch applied (support
for 64bit hardware). After installing the MSJet-Driver, the Jet driver
doesn't appear in the ODBC manager list of drivers to allow configuring a
Datasource. I have seen some references by MS stating that the Jet driver is
being "dropped" from all new releases of software and OS's. It's also not
included in the most recent release of the MDAC.
The question: How else can I build a LinkedServer to connect and query those
FoxPro files without the availability of the Jet Drivers? Or, is
there a way to "force" that jet driver to work on 64bit hardware running
32bit SQLServer-2000?
Any suggestions appreciated, as the application in question is mission
critical and in use by numerous organ transplantation services. No
JetDriver, no transplant! (just kidding...)
I hope this makes sense...
thanks,
Blaise...
|