Error after switching from ODBC DSN connection to OLEDB

dweddyRaf

New Member
I've been having timeout and login connection issues from my ASP application to my SQL Server database. My hosting provider suggested changing my connection string from ODBC DSN to OLEDB. Once I did that I get this error when executing my first stored procedure.\[quote\] Procedure or function 'storedproc' expects parameter '@param1', which was not supplied.\[/quote\]Here is my connection string\[code\]Dim objconnSet objconn = Server.CreateObject("ADODB.Connection")objconn.open "Provider=SQLOLEDB;Data Source=localhost\sqlexpress;Initial Catalog=db;user id=user;password=pw"\[/code\]Here is my stored proc call\[code\]Dim objrs, cmdSet cmd = Server.CreateObject("ADODB.Command")Set cmd.ActiveConnection = objconncmd.CommandText = "storedproc"cmd.Parameters.Append(cmd.CreateParameters("param1",adDouble,adParamInput,,session("param1")))Set objrs = Server.CreateObject("ADODB.Recordset")objrs.CursorLocatoin = adUseClientobjrs.Open cmd\[/code\]Any ideas why my proc call doesn't work with a different connection string?
 
Back
Top