|
 |
asp_databases thread: Error using CursorLocation on SQLServer from Client Side
Message #1 by "Santosh Singh" <singh_santosh_care@y...> on Mon, 26 Jun 2000 7:35:48
|
|
I am getting following error messages following usage of CursorLocation
------------------------------------------
CODE:
cn.CursorLocation = adUseClient 'This is line No. 11
cn.Open "DSN=sqldata;UID=sa"
------------------------------------------
ERROR:
ADODB.Connection error '800a0bb9'
The application is using arguments that are of the wrong type, are out of
acceptable range, or are in conflict with one another.
/mytemp/dsn2.asp, line 11
------------------------------------------
Help!!!
Message #2 by Ian Nutt <iann@w...> on Mon, 26 Jun 2000 12:43:54 +0100
|
|
Santosh,
Looks like your code doesn't have a definition of adUseClient. Choose one
of the three easy solutions:
1. Declare a constant called adUseClient to your ASP page -- give it the the
value 3
2. #INCLUDE the file called adovbs.inc into hte top of your page. You'll
find adovbs.inc somewhere on your system (you can search your hard disk for
it).
(Note: you can read adovbs.inc by opening it in NotePad - it's just a huge
list of constant definitions. That's where you'll find that adUseClient
3.)
3. Add a reference to the ADO constants library, msado15.dll, as described
on page 519 of "Beginning ASP 3.0", and as used throughout Chapters 13-15.
There's more general info about this on pages 518-520.
Cheers, Ian
-----Original Message-----
From: Santosh Singh
Sent: Monday, June 26, 2000 8:36 AM
To: ASP Databases
Subject: [asp_databases] Error using CursorLocation on SQLServer from
Client Side
I am getting following error messages following usage of CursorLocation
------------------------------------------
CODE:
cn.CursorLocation = adUseClient 'This is line No. 11
cn.Open "DSN=sqldata;UID=sa"
------------------------------------------
ERROR:
ADODB.Connection error '800a0bb9'
The application is using arguments that are of the wrong type, are out of
acceptable range, or are in conflict with one another.
/mytemp/dsn2.asp, line 11
------------------------------------------
Help!!!
Message #3 by Ian Nutt <iann@w...> on Mon, 26 Jun 2000 13:20:19 +0100
|
|
More on point 3 (just in case you don't have "Beginning ASP 3.0"):
Add the following line at the top of your ASP page:
<!-- METADATA TYPE="typelib"
FILE="C:\Program Files\Common Files\System\ado\msado15.dll" -->
Make sure your pathname points to the msado15.dll file :-)
Ian
-----Original Message-----
From: Ian Nutt [mailto:iann@w...]
Sent: Monday, June 26, 2000 12:44 PM
To: ASP Databases
Subject: [asp_databases] RE: Error using CursorLocation on SQLServer
from Client Side
Santosh,
Looks like your code doesn't have a definition of adUseClient. Choose one
of the three easy solutions:
1. Declare a constant called adUseClient to your ASP page -- give it the the
value 3
2. #INCLUDE the file called adovbs.inc into hte top of your page. You'll
find adovbs.inc somewhere on your system (you can search your hard disk for
it).
(Note: you can read adovbs.inc by opening it in NotePad - it's just a huge
list of constant definitions. That's where you'll find that adUseClient
3.)
3. Add a reference to the ADO constants library, msado15.dll, as described
on page 519 of "Beginning ASP 3.0", and as used throughout Chapters 13-15.
There's more general info about this on pages 518-520.
Cheers, Ian
-----Original Message-----
From: Santosh Singh
Sent: Monday, June 26, 2000 8:36 AM
To: ASP Databases
Subject: [asp_databases] Error using CursorLocation on SQLServer from
Client Side
I am getting following error messages following usage of CursorLocation
------------------------------------------
CODE:
cn.CursorLocation = adUseClient 'This is line No. 11
cn.Open "DSN=sqldata;UID=sa"
------------------------------------------
ERROR:
ADODB.Connection error '800a0bb9'
The application is using arguments that are of the wrong type, are out of
acceptable range, or are in conflict with one another.
/mytemp/dsn2.asp, line 11
------------------------------------------
Help!!!
|
|
|
View Cart
