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