ODBC Access to FoxPro DBF?

[westmiller]

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

[bruce]

You can use oleDB for FoxPro but not ODBC.

ODBC is another layer on top of OleDB. OleDB provide better performance and stability.

You should consider moving to MS SQL since it has many advantages over Access and Fox Pro.



[b]quote:Originally posted by westmiller

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
</blockquote id="quote"></font id="quote">

[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?

[westmiller]

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

[bkagan98]

Try these connection strings:

free tables: "User ID=;DSN=;Cache Authentication=False;Data Source=C:\DATABASEFOLDER;Password=;Provider=VFPOLE DB.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=;Pr ovider=VFPOLEDB.1;Collating Sequence=MACHINE;Mask Password=False;Mode=Share Deny None;Extended Properties=;Encrypt Password=False"

[bruce]

basically all you need to change is the connection line.

i am not too familiar w/ Foxpro so i can't give you any example.

[|)]

[b]quote:Originally posted by 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?
</blockquote id="quote"></font id="quote">