Using FoxPro DBF with ASP

[sdpsc]

How do I get a FoxPro DBF file to work with ASP? I have the following connection string working with an Access MDB:

strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("cooproductions.mdb")

What does the provider part need to be to work with a DBF? Thanks!

 

[DotNetGnat]

something like this:

"Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=c:\myvfpdbfolder;Exclusive=No;Collate=Machine;NULL=NO;DELETED=NO;BACKGROUNDFETCH=NO"

please look at

http://www.connectionstrings.com

-DNG

 

[sdpsc]

Thanks! I'm not getting this to work though, I have this code:

---

set cn = CreateObject("ADODB.Connection")

strConnectionString = "Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;Exclusive=No;Collate=Machine;NULL=NO;DELETED=NO;BACKGROUNDFETCH=NO;Data Source=" & server.mappath("dnc.dbf")

cn.open strConnectionString

---

And I get this error:

---

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name too long

---

Any help would be greatly appreciated!

 

[DotNetGnat]

how about using this:

"Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:\mydbpath;"

-DNG

 

[DotNetGnat]

the string i provided in my first reply was for Visual FoxPro..sorry...please take a look at that website...you can find all the connection strings...

-DNG