ODBC Access to FoxPro DBF?

I had service from another host that provided support features under MS Server for accessing MS FoxPro databases. For the moment, I'd like to avoid rewriting my ASP code and use that ODBC Driver. Is it available, or what other options do I have?
At some point, I'll probably be forced to convert to Access or SQL as a resource, but I'm not clear on the differences between ODBC, OleDB, MySQL or MS SQL connections. I've got a lot of programming time invested in FoxPro programs and utilities, so I don't want to jump without some advice.

Bill Westmiller

 

> You can use oleDB for FoxPro but not ODBC.

Where do I find a good guide to converting my ODBC ASP code to oleDB? I found a sample at Q10023 for Access ... would it be the same for FoxPro, or do I need to specify a different 'PROVIDER'?
With oleDB, I'm assuming I can access table contents within ASP as simple VBScript? IE: His last name is: <% lname %> .. or not?

 

> basically all you need to change is the connection line.

The question is whether the 'Microsoft.Jet.OLEDB.4.0' provider in the connection supports *both* MS Access and MS Foxpro data files.
If not, which connection 'Provider' should I use for Foxpro?
I'm assuming that your MS Servers do support MS VBScript as the standard ASP access syntax?

 

Try these connection strings:

free tables: "User ID=;DSN=;Cache Authentication=False;Data Source=C:\DATABASEFOLDER;Password=;Provider=VFPOLEDB.1;Collating Sequence=MACHINE;Mask Password=False;Mode=Share Deny None;Extended Properties=;Encrypt Password=False"

database (DBC-container): "User ID=;DSN=;Cache Authentication=False;Data Source=C:\DATABASEFOLDER\Database.dbc;Password=;Provider=VFPOLEDB.1;Collating Sequence=MACHINE;Mask Password=False;Mode=Share Deny None;Extended Properties=;Encrypt Password=False"