|
 |
asp_databases thread: Beginning ASP databases: '80004005' : Driver does not support this function
Message #1 by webdev@l... on Fri, 27 Oct 2000 21:51:59 +0100
|
|
I have got to page 76 of Beginning ASP Databases.
My ASP extensions seem to have installed properly.
My testsailor.asp page, sitting in my PWS root folder, using the files
downloaded from the Wrox site for the book, shows in my browser thus:
-----------------------------
Next line from ASP will work
if ASP extensions installed correctly:
From ASP
Next line from ADO will work if a DSN named sailors has been set
for the database which is named SAILORS.MDB.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Driver does not support this function
/testsailor.asp, line 20
------------------------------------
Line 20 is
oRS.movefirst
I can find no reference to error 80004005 "Drive does not support this
function" in any of the relevant faqs or at MSDN.
If I replace line 20 with
oRS.MoveLast
I get:
------------------------------
Microsoft OLE DB Provider for ODBC Drivers error '80040e24'
The rowset does not support fetching backwards
/testsailor.asp, line 20
-----------------------------
I get the same errors if I make my own Access 97 database and write my own
asp file, subsituting accordingly.
I don't know what I can infer from this and am lost at how to further
diagnose the problem.
Everything looks fine in the DSN settings.
Installing the latest MDAC has made no difference. Neither has reverting
from IExplorer 5 to my previous version of Explorer (vs.4)
Thank you for any guidance.
Andrew
Message #2 by "Dallas Martin" <dmartin@z...> on Sat, 28 Oct 2000 09:00:38 -0400
|
|
Did you check for the EOF/BOF first before issuing any
MOVE... commands? If no recrods were returned by your query,
then you can't "move" anywhere.
----- Original Message -----
From: <webdev@l...>
To: "ASP Databases" <asp_databases@p...>
Sent: Friday, October 27, 2000 4:51 PM
Subject: [asp_databases] Beginning ASP databases: '80004005' : Driver does
not support this function
> I have got to page 76 of Beginning ASP Databases.
> My ASP extensions seem to have installed properly.
> My testsailor.asp page, sitting in my PWS root folder, using the files
> downloaded from the Wrox site for the book, shows in my browser thus:
> -----------------------------
> Next line from ASP will work
> if ASP extensions installed correctly:
> >From ASP
>
> Next line from ADO will work if a DSN named sailors has been set
> for the database which is named SAILORS.MDB.
>
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> [Microsoft][ODBC Driver Manager] Driver does not support this function
>
> /testsailor.asp, line 20
> ------------------------------------
> Line 20 is
> oRS.movefirst
>
> I can find no reference to error 80004005 "Drive does not support this
> function" in any of the relevant faqs or at MSDN.
>
> If I replace line 20 with
> oRS.MoveLast
> I get:
> ------------------------------
> Microsoft OLE DB Provider for ODBC Drivers error '80040e24'
>
> The rowset does not support fetching backwards
>
> /testsailor.asp, line 20
> -----------------------------
> I get the same errors if I make my own Access 97 database and write my own
> asp file, subsituting accordingly.
> I don't know what I can infer from this and am lost at how to further
> diagnose the problem.
>
> Everything looks fine in the DSN settings.
> Installing the latest MDAC has made no difference. Neither has reverting
> from IExplorer 5 to my previous version of Explorer (vs.4)
>
> Thank you for any guidance.
>
> Andrew
Message #3 by Maxime Bombardier <BombardierM@s...> on Sat, 28 Oct 2000 18:14:18 -0400
|
|
If you are opening the recordset with adOpenForwardOnly, you are not able to
do anything else than MoveNext; thus having a problem with MoveFirst or
MoveBackward.
You can use the adOpenStatic, adOpenDynamic, or adOpenKeyset to do this.
Refer to the ADO documentation, which you probably have in Beginning ASP
Databases, for the differences of each open type.
Maxime Bombardier
-----Original Message-----
From: webdev@l... [mailto:webdev@l...]
Sent: Friday, October 27, 2000 4:52 PM
To: ASP Databases
Subject: [asp_databases] Beginning ASP databases: '80004005' : Driver
does not support this function
I have got to page 76 of Beginning ASP Databases.
My ASP extensions seem to have installed properly.
My testsailor.asp page, sitting in my PWS root folder, using the files
downloaded from the Wrox site for the book, shows in my browser thus:
-----------------------------
Next line from ASP will work
if ASP extensions installed correctly:
From ASP
Next line from ADO will work if a DSN named sailors has been set
for the database which is named SAILORS.MDB.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Driver does not support this function
/testsailor.asp, line 20
------------------------------------
Line 20 is
oRS.movefirst
I can find no reference to error 80004005 "Drive does not support this
function" in any of the relevant faqs or at MSDN.
If I replace line 20 with
oRS.MoveLast
I get:
------------------------------
Microsoft OLE DB Provider for ODBC Drivers error '80040e24'
The rowset does not support fetching backwards
/testsailor.asp, line 20
-----------------------------
I get the same errors if I make my own Access 97 database and write my own
asp file, subsituting accordingly.
I don't know what I can infer from this and am lost at how to further
diagnose the problem.
Everything looks fine in the DSN settings.
Installing the latest MDAC has made no difference. Neither has reverting
from IExplorer 5 to my previous version of Explorer (vs.4)
Thank you for any guidance.
Andrew
|
|
|
View Cart
