Looking for Text and FoxPro DB Drivers for x64 windows.

[seanpford]

I have a client with a fairly powerful server that I want to upgrade to 64 bit, to take advantage of the 12GB of memory it has.  Unfortunately, a ColdFusion system I built requires that I download some files from Gov't websites (which all seem to have self-generated SSL certs which throw CFHTTP for a loop too, but I use CFX_http5 to get around this).  Once I download these files, i import the data into SQL and go from there.  What I can't get around is that there are NO text and DBF drivers available for the x64 versions.

Can anyone recommend an Open Source or Thurd-party driver that might work, possible via JDBC?

My only other solution is to mirror the application on a 32bit virtual machine to handle the import tasks and let the 64-bit machine handle the rest of the app. Not exactly ideal.

Any thoughts?

--Sean

[JR__Bob__Dobbs-qSBHQ2]

Is your backend database system FoxPro or do you need to import data from FoxPro and/or text files into another database?

Message was edited by: JR "Bob" Dobbs Edit for clarification.

[seanpford]

No, my backend database is SQL 2008.  I get data from 2 sources for my system, a text file from the Gov't. and a set of dbf's from a third party.  I've written import scripts to take this data and basically get it into SQL tables (as quickly as I can, for my own sanity) and then I work with it in SQL from there.  I was thinking that i may be able to use cfhttp for the text file, since it can import CSV data into a query (or at least i think it still can, since I haven't used this feature in about 5 years).

That's the deal.

Thanks for any help.

[JR__Bob__Dobbs-qSBHQ2]

Have you considered using SQL Server Integration Services (SSIS), instead of ColdFusion, to handle your data import tasks?  SSIS is a bulit-in feature of SQL Server designed to import data into and export data from SQL server and handle different file formats.  I've used SSIS to import data from CSV files.  I've included a link to information related to DBF files below.

"SQL Server 2008 – Integration Services"

http://msdn.microsoft.com/en-us/sqlserver/cc511477.aspx

"How to: Connect to a dBASE or Other DBF File"

http://msdn.microsoft.com/en-us/library/aa337084.aspx

Message was edited by: JR "Bob" Dobbs