asp_databases thread: dsn to sqloledb
Message #1 by dont worry <aspmailbox@y...> on Wed, 13 Feb 2002 09:17:25 -0800 (PST)
|
|
I want to change my connection to SQLOLEDB but it
starts to give me the following error.
"Item cannot be found in the collection corresponding
to the request name or ordinal"
why does this happen? how do I fix it.
SQLOLEDB is suppose to be much faster.
thanks
__________________________________________________
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com
Message #2 by "Jeffrey Lee" <leech74@s...> on Thu, 14 Feb 2002 01:31:49 +0800
|
|
Show us your code.
----- Original Message -----
From: "dont worry" <aspmailbox@y...>
To: "ASP Databases" <asp_databases@p...>
Sent: Thursday, February 14, 2002 1:17 AM
Subject: [asp_databases] dsn to sqloledb
> I want to change my connection to SQLOLEDB but it
> starts to give me the following error.
> "Item cannot be found in the collection corresponding
> to the request name or ordinal"
> why does this happen? how do I fix it.
>
> SQLOLEDB is suppose to be much faster.
> thanks
>
> __________________________________________________
> Do You Yahoo!?
> Send FREE Valentine eCards with Yahoo! Greetings!
> http://greetings.yahoo.com
>
$subst('Email.Unsub').
Message #3 by "Ken Schaefer" <ken@a...> on Thu, 14 Feb 2002 16:42:38 +1100
|
|
>> The error is on line 8
> How do you know? I didn't post any code
Exactly
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "dont worry" <aspmailbox@y...>
Subject: [asp_databases] dsn to sqloledb
: I want to change my connection to SQLOLEDB but it
: starts to give me the following error.
: "Item cannot be found in the collection corresponding
: to the request name or ordinal"
: why does this happen? how do I fix it.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Message #4 by dont worry <aspmailbox@y...> on Fri, 15 Feb 2002 07:44:47 -0800 (PST)
|
|
Set dbConn = Server.CreateObject("ADODB.Connection")
dbConn.ConnectionTimeout = 15
dbConn.CommandTimeout = 30
'dbConn.Open
"DSN=MyDSN;UID=MyUserID;PWD=MyPassword;DATABASE=MyDatabase"
dbConn.Open "DSN=mca;UID=mca;PWD=83;DATABASE=MCA"
'dbConn.Open "Provider=SQLOLEDB;Data
Source=WEBSVR;Inital Catalog=MCA;User
ID=MCA;PASSWORD=83"
-----
I have a stored procedure that returns two values.
SOmething like
If exist(select uid from tble where uid=@uid)
BEGIN
Select p=1,msg='found'
END
Return
----
If works with dsn , but when I change it to SQLOLEDB
it doens't find I BELIEVE the return values?
thanks
--- Jeffrey Lee <leech74@s...> wrote:
> Show us your code.
> ----- Original Message -----
> From: "dont worry" <aspmailbox@y...>
> To: "ASP Databases" <asp_databases@p...>
> Sent: Thursday, February 14, 2002 1:17 AM
> Subject: [asp_databases] dsn to sqloledb
>
>
> > I want to change my connection to SQLOLEDB but it
> > starts to give me the following error.
> > "Item cannot be found in the collection
> corresponding
> > to the request name or ordinal"
> > why does this happen? how do I fix it.
> >
> > SQLOLEDB is suppose to be much faster.
> > thanks
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Send FREE Valentine eCards with Yahoo! Greetings!
> > http://greetings.yahoo.com
> >
> $subst('Email.Unsub').
>
>
$subst('Email.Unsub').
__________________________________________________
Do You Yahoo!?
Got something to say? Say it better with Yahoo! Video Mail
http://mail.yahoo.com
|
View Cart
