-
ODBC Drivers error '80004005'
When running asp-test-free.asp the following error occured.
I downloaded ASPdbFee & placed the dll in the system32 folder & successfully registered it. Using Vis Interdev6, set upa project ASPdbFree with the asp-test.mdb database inside. Then set the ODBC path to the database and used a system DSN called ASPdbFree. All the ASP's where placed in a scripts folder.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'
./ASPdbFree/scripts/asp-test-free.asp, line 46
<%
MyDb.Dbmdb=Server.MapPath("asp-test.mdb" 'Point to the database
MyDb.DbUnit=1 'Set unit to 1
MyDb.DBColor="11,auto,#FFFF88" 'Choose a color scheme
MyDb.DbImageDir="images/" 'Define where image files are
MyDb.DbGridTableTag="border=3 cellspacing=3 cellpadding=4" 'Turn on borders, etc.
MyDb.DbMode="Grid" 'Show as a grid
MyDb.DbGridInc = "6" 'Show 6 rows on the grid
MyDb.DbSQL = "Select * FROM Products" 'Choose which table & records to view
MyDb.DbNavigationItem="top,prev,next,bottom,gr idrow,gridcol,filter,resetfilter,download,color,re load"
MyDb.DbNavigationIcon="std"
MyDb.DbColGraph="Products,UnitsInStock,200,,bl uebar.gif,8;"
MyDb.DbFilterFlds="ProductID,ProductName"
MyDb.DbFilterDropFlds="Products,ProductID,Prod uctName"
MyDb.aspDBFree 'Display it!
%>
line 46 being MyDb.aspDBFree.
Do you have to set the scripts folder to run & execute programs & files?
How do I do this?
Or is the error caused by another problem.
Can you please help.
Yours,
ian@rite.net
-
ODBC Drivers error '80004005' (reply)
Dear Mark,
I changed line 32 from MyDb.Dbmdb=Server.MapPath("asp-test.mdb"
to MyDb.Dbmdb=Server.MapPath("ASPdb"as suggested.
ASPdb being my DSN to the database.
I'm still getting the same error in line 46.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Could not find file '(unknown)'.
/ASPdbFree/asp-test-free.asp, line 46
Can you help?
Regards,
Ian.
------------
Mark at 3/14/00 8:46:55 AM
Ian,
If you created a System DSN, then use that to point to your database instead of dbMDB. So remove the line that says:
Mydb.dbMDB = "...
and add a line that says:
Mydb.dbDSN = "yourDSNname"
That should take care of it.
Mark.
------------
Ian Webb at 3/14/00 6:00:45 AM
When running asp-test-free.asp the following error occured.
I downloaded ASPdbFee & placed the dll in the system32 folder & successfully registered it. Using Vis Interdev6, set upa project ASPdbFree with the asp-test.mdb database inside. Then set the ODBC path to the database and used a system DSN called ASPdbFree. All the ASP's where placed in a scripts folder.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'
./ASPdbFree/scripts/asp-test-free.asp, line 46
<%
MyDb.Dbmdb=Server.MapPath("asp-test.mdb" 'Point to the database
MyDb.DbUnit=1 'Set unit to 1
MyDb.DBColor="11,auto,#FFFF88" 'Choose a color scheme
MyDb.DbImageDir="images/" 'Define where image files are
MyDb.DbGridTableTag="border=3 cellspacing=3 cellpadding=4" 'Turn on borders, etc.
MyDb.DbMode="Grid" 'Show as a grid
MyDb.DbGridInc = "6" 'Show 6 rows on the grid
MyDb.DbSQL = "Select * FROM Products" 'Choose which table & records to view
MyDb.DbNavigationItem="top,prev,next,bottom,gr idrow,gridcol,filter,resetfilter,download,color,re load"
MyDb.DbNavigationIcon="std"
MyDb.DbColGraph="Products,UnitsInStock,200,,bl uebar.gif,8;"
MyDb.DbFilterFlds="ProductID,ProductName"
MyDb.DbFilterDropFlds="Products,ProductID,Prod uctName"
MyDb.aspDBFree 'Display it!
%>
line 46 being MyDb.aspDBFree.
Do you have to set the scripts folder to run & execute programs & files?
How do I do this?
Or is the error caused by another problem.
Can you please help.
Yours,
ian@rite.net
-
ODBC Drivers error '80004005' (reply)
two suggestions -
1. Tryto get a plain an dsimple aspdb file working first and then try VID6.
2. Do not and try not to use server.mappath. Hard code the path.
Also, you said you register the ASPDBFree DLL and that's it ? How about the VB6 runtime files. You need to install that too.
FK
------------
Ian Webb at 3/14/00 6:00:45 AM
When running asp-test-free.asp the following error occured.
I downloaded ASPdbFee & placed the dll in the system32 folder & successfully registered it. Using Vis Interdev6, set upa project ASPdbFree with the asp-test.mdb database inside. Then set the ODBC path to the database and used a system DSN called ASPdbFree. All the ASP's where placed in a scripts folder.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'
./ASPdbFree/scripts/asp-test-free.asp, line 46
<%
MyDb.Dbmdb=Server.MapPath("asp-test.mdb" 'Point to the database
MyDb.DbUnit=1 'Set unit to 1
MyDb.DBColor="11,auto,#FFFF88" 'Choose a color scheme
MyDb.DbImageDir="images/" 'Define where image files are
MyDb.DbGridTableTag="border=3 cellspacing=3 cellpadding=4" 'Turn on borders, etc.
MyDb.DbMode="Grid" 'Show as a grid
MyDb.DbGridInc = "6" 'Show 6 rows on the grid
MyDb.DbSQL = "Select * FROM Products" 'Choose which table & records to view
MyDb.DbNavigationItem="top,prev,next,bottom,gr idrow,gridcol,filter,resetfilter,download,color,re load"
MyDb.DbNavigationIcon="std"
MyDb.DbColGraph="Products,UnitsInStock,200,,bl uebar.gif,8;"
MyDb.DbFilterFlds="ProductID,ProductName"
MyDb.DbFilterDropFlds="Products,ProductID,Prod uctName"
MyDb.aspDBFree 'Display it!
%>
line 46 being MyDb.aspDBFree.
Do you have to set the scripts folder to run & execute programs & files?
How do I do this?
Or is the error caused by another problem.
Can you please help.
Yours,
ian@rite.net
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
|
|