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





__________________________________________________

Do You Yahoo!?

Yahoo! Sports - Coverage of the 2002 Olympic Games

http://sports.yahoo.com

Um, what are you doing to try and check for the existance of the values? You

are returning a recordset, not return values or output parameters.



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "dont worry" <aspmailbox@y...>

Subject: [asp_databases] No one helped? Re: dsn to sqloledb





: 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?



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~