Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot get data source
Message
General information
Forum:
ASP.NET
Category:
Other
Title:
Cannot get data source
Miscellaneous
Thread ID:
00601488
Message ID:
00601488
Views:
73
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
Next
Reply
Map
View

Click here to load this message in the networking platform