asked on

problem using stored procedures

I have no problem accessing sql server with the following connection string

SET conn = Server.CreateObject("ADODB.Connection")
conn.open Application("dbConnect"),Application("dbUSER"),Application("dbPW")

But I cannot get the stored procedures working!! Whats wrong with the following please?

cnnStoredProc.Open="Provider=SQLOLEDB.1;Password=" & Application("dbPW") & ";Persist Security Info=True;User ID=xxxxx;Initial Catalog=dbname;Data Source=www.xxx.co.uk"

the code is classic asp.

thanks

ASKER CERTIFIED SOLUTION

Pryrates

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

jogos

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

michaeldean99

ASKER

no, they are not the real codes!

I cannot get the classic asp code to process the stored procedure. I get
Wrong number of arguments or invalid property assignment

At the moment I cannot access the online database so I cannot establish the problem. I was checking that that my code was correct. It seems to be so I will have to wait for the dba to look at the online database.
thanks

jogos

And you're getting that message on the call of the stored procedure? Annyway then you don't get it on your connection so that part of your question is gone.

Leaves you with the parameters or their types that don't match the procedure.

SOLUTION

Pryrates

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial