-
error '80004005'
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
General error: Invalid file dsn ' C:inerpubwwwroothayes.dsn'
/niddkweb/Exceldsn.asp, line 9
I get the above error with the following code:
<%
Set MyDb = Server.CreateObject("ASPdb.EP" ' Create the ASP-db object
MyDb.dbQuickProps = "3071;;;Grid;4,auto,lightgrey"
DRIVER="Microsoft Excel Driver (*.xls) "
' Set its std properties
MyDb.dbNavigationItem = "top, prev, next, bottom, filter, download"
MyDB.dbDSN = "FileDSN= Hayes.dsn" & ";DBQ=" & Server.MapPath "hayes1copy.xls"
MyDb.dbSQL = "Select * FROM [hayes]"
MyDb.ASPdbEP ' Display it!
%>
Can anyone help me with what's wrong in this code?
Thanks in advance,
Eric
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|