ODBC Drivers error '80004005'

[Ian Webb]

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(&#34;asp-test.mdb&#34 &#39;Point to the database
MyDb.DbUnit=1 &#39;Set unit to 1
MyDb.DBColor=&#34;11,auto,#FFFF88&#34; &#39;Choose a color scheme
MyDb.DbImageDir=&#34;images/&#34; &#39;Define where image files are
MyDb.DbGridTableTag=&#34;border=3 cellspacing=3 cellpadding=4&#34; &#39;Turn on borders, etc.
MyDb.DbMode=&#34;Grid&#34; &#39;Show as a grid
MyDb.DbGridInc = &#34;6&#34; &#39;Show 6 rows on the grid
MyDb.DbSQL = &#34;Select * FROM Products&#34; &#39;Choose which table & records to view
MyDb.DbNavigationItem=&#34;top,prev,next,bottom,gr idrow,gridcol,filter,resetfilter,download,color,re load&#34;
MyDb.DbNavigationIcon=&#34;std&#34;
MyDb.DbColGraph=&#34;Products,UnitsInStock,200,,bl uebar.gif,8;&#34;
MyDb.DbFilterFlds=&#34;ProductID,ProductName&#34;
MyDb.DbFilterDropFlds=&#34;Products,ProductID,Prod uctName&#34;

MyDb.aspDBFree &#39;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

[Ian Webb]

Dear Mark,
I changed line 32 from MyDb.Dbmdb=Server.MapPath(&#34;asp-test.mdb&#34
to MyDb.Dbmdb=Server.MapPath(&#34;ASPdb&#34as suggested.
ASPdb being my DSN to the database.
I&#39;m still getting the same error in line 46.
Microsoft OLE DB Provider for ODBC Drivers error &#39;80004005&#39;
Could not find file &#39;(unknown)&#39;.
/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 = &#34;...

and add a line that says:

Mydb.dbDSN = &#34;yourDSNname&#34;

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&#39;s where placed in a scripts folder.

Microsoft OLE DB Provider for ODBC Drivers error &#39;80004005&#39;
[Microsoft][ODBC Microsoft Access Driver] Could not find file &#39;(unknown)&#39;
./ASPdbFree/scripts/asp-test-free.asp, line 46

<%
MyDb.Dbmdb=Server.MapPath(&#34;asp-test.mdb&#34 &#39;Point to the database
MyDb.DbUnit=1 &#39;Set unit to 1
MyDb.DBColor=&#34;11,auto,#FFFF88&#34; &#39;Choose a color scheme
MyDb.DbImageDir=&#34;images/&#34; &#39;Define where image files are
MyDb.DbGridTableTag=&#34;border=3 cellspacing=3 cellpadding=4&#34; &#39;Turn on borders, etc.
MyDb.DbMode=&#34;Grid&#34; &#39;Show as a grid
MyDb.DbGridInc = &#34;6&#34; &#39;Show 6 rows on the grid
MyDb.DbSQL = &#34;Select * FROM Products&#34; &#39;Choose which table & records to view
MyDb.DbNavigationItem=&#34;top,prev,next,bottom,gr idrow,gridcol,filter,resetfilter,download,color,re load&#34;
MyDb.DbNavigationIcon=&#34;std&#34;
MyDb.DbColGraph=&#34;Products,UnitsInStock,200,,bl uebar.gif,8;&#34;
MyDb.DbFilterFlds=&#34;ProductID,ProductName&#34;
MyDb.DbFilterDropFlds=&#34;Products,ProductID,Prod uctName&#34;

MyDb.aspDBFree &#39;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

[Frank]

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&#39;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&#39;s where placed in a scripts folder.

Microsoft OLE DB Provider for ODBC Drivers error &#39;80004005&#39;
[Microsoft][ODBC Microsoft Access Driver] Could not find file &#39;(unknown)&#39;
./ASPdbFree/scripts/asp-test-free.asp, line 46

<%
MyDb.Dbmdb=Server.MapPath(&#34;asp-test.mdb&#34 &#39;Point to the database
MyDb.DbUnit=1 &#39;Set unit to 1
MyDb.DBColor=&#34;11,auto,#FFFF88&#34; &#39;Choose a color scheme
MyDb.DbImageDir=&#34;images/&#34; &#39;Define where image files are
MyDb.DbGridTableTag=&#34;border=3 cellspacing=3 cellpadding=4&#34; &#39;Turn on borders, etc.
MyDb.DbMode=&#34;Grid&#34; &#39;Show as a grid
MyDb.DbGridInc = &#34;6&#34; &#39;Show 6 rows on the grid
MyDb.DbSQL = &#34;Select * FROM Products&#34; &#39;Choose which table & records to view
MyDb.DbNavigationItem=&#34;top,prev,next,bottom,gr idrow,gridcol,filter,resetfilter,download,color,re load&#34;
MyDb.DbNavigationIcon=&#34;std&#34;
MyDb.DbColGraph=&#34;Products,UnitsInStock,200,,bl uebar.gif,8;&#34;
MyDb.DbFilterFlds=&#34;ProductID,ProductName&#34;
MyDb.DbFilterDropFlds=&#34;Products,ProductID,Prod uctName&#34;

MyDb.aspDBFree &#39;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