I am having trouble getting an asp to connect to the data. this is the code and error message:
CODE:
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open "Driver={Microsoft Visual FoxPro Driver};"_
& "SourceType=DBF;Provider=MSDASQL.1;Exclusive=No;"_
& "SourceDB=\\servername\directory\Data" **OR** 'looks at a network server
& "SourceDB=.\Data" 'looks at the web server
set rs1 = oConn.Execute("select distinct cname from agencycodes")
ERROR:
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Visual FoxPro Driver]File 'agencycodes.dbf' does not exist
The table does exist. Any ideas?
Extreme Programming = Plan -> Design -> Code -> Test