Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Useing ASP with .DBF files...but getting error with OLE DB Provider

Status
Not open for further replies.

jimbob550

Programmer
Jun 28, 2001
7
US
Hello,
I'm createing a site that has to use a .dbf file full of records to display stats or current issues with the fields in it.

I have tried making the database connection using ODBC using each type of the .dbf system drivers and I've also tried typing this in the code instead:

connString = "Driver={Microsoft Visual FoxPro Driver};" & _
"SourceType=DBF;" & _
"SourceDB=" & Server.MapPath("\db") & ";" & _
"Exclusive=No;"

And also tried

connString = "Driver={Microsoft Visual FoxPro Driver};" & _
"UID=;PWD=;" & _
"SourceDB=c:\Inetpub\ & _
"SourceType=DBF;Exclusive=No;" & _
"BackgroundFetch=Yes;Collate=Machine;" & _
"Null=Yes;Deleted=Yes;"


No matter what though it won't work. Here is the error I receive:

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
ODBC driver does not support the requested properties.
/gen/tasks.asp, line 95


Does anyone know how I can get this to work?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top