SQL2000 SP4 and 64bit server with JetDriver...

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...


.

Relevant Pages

  • Re: Catching an Open Excel File with VBScript
    ... the the Jet driver gives the same problem. ... >> is done loading and I close the Excel file, any time I try to open any ... >> loading the webpage, only if I have the specific file open that I'm ...
    (microsoft.public.excel.programming)
  • Re: Jet Database Driver Documentation
    ... I understand that you need to get documentation of SQL ... > syntax and SQL function that Jet 4 driver supports. ... intend to waste money on a MS Office upgrade. ... For now, it does satisfy the current need for the Jet driver, but not the ODBC ...
    (microsoft.public.data.oledb)
  • SQL2000 SP4 and 64bit server with JetDriver...
    ... query Foxpro tables via ADO components in Delphi. ... After installing the MSJet-Driver, the Jet driver ... I have seen some references by MS stating that the Jet driver is ... How else can I build a LinkedServer to connect and query those ...
    (microsoft.public.sqlserver.odbc)
  • SQL2000 SP4 and 64bit server with JetDriver...
    ... query Foxpro tables via ADO components in Delphi. ... After installing the MSJet-Driver, the Jet driver ... I have seen some references by MS stating that the Jet driver is ... How else can I build a LinkedServer to connect and query those ...
    (microsoft.public.sqlserver.odbc)