instead of provide="OLEDB" use:
provider="SQLOLEDB" > -----Original Message----- > From: Ian Skinner [mailto:[EMAIL PROTECTED]] > Sent: 23 March 2002 18:43 > To: CF-Talk > Subject: Problems with my first CF Stored Procedure. > > > CF Talk List > > I am writing my first cold fusion stored procedure call. I > am getting an error I do not understand and do not know how > to correct. I am unable to find any information on the > error, and I am hoping somebody out there can give me a > lead. Here is the cold fusion code I am using to call the > stored procedure. > > <CFSTOREDPROC > PROCEDURE="sp_ktChgsPmtsByDate" > DATASOURCE="Paragon" > USERNAME="sa" > PASSWORD="" > PROVIDER="OLEDB" > DBSERVER="SQL6932440" > DBNAME="paragon" > RETURNCODE="YES" > DEBUG> > > <CFPROCPARAM > TYPE="In" > DBVARNAME="@SDate" > VALUE="'#SDate#'" > CFSQLTYPE="CF_SQL_DATE"> > > <CFPROCPARAM > TYPE="In" > DBVARNAME="@EDate" > VALUE="'#EDate#'" > CFSQLTYPE="CF_SQL_DATE"> > > <CFPROCRESULT > NAME = YestPayments> > > </CFSTOREDPROC> > > But when I run this code, and all the alternate > configurations I've tried so far, I get this error. > > Error Occurred While Processing Request > Error Diagnostic Information > OLEDB Error Code = 0 > > NULL Interface Ptr > > SQL = "sp_ktChgsPmtsByDate" > > Data Source = "Paragon" > > The error occurred while processing an element with a > general identifier of > (CFSTOREDPROC), occupying document position (18:1) to > (26:7) in the > template file ...\YestPaymntsToPatAccts.cfm. > > I know the stored procedure works, and we were able to > create ASP code to access the stored procedure. But I'm > stubborn and I would like to know why I can't get this to > work in cold fusion. > > ASP Code > sSDate = Request.QueryString ("FromMonth") & "/" & > Request.QueryString ("FromDay") & "/" & > Request.QueryString ("FromYear") > > sEDate = Request.QueryString ("ToMonth") & "/" & > Request.QueryString ("ToDay") & "/" & > Request.QueryString ("ToYear") > > sSPName = Request.QueryString ("SPName") > > Set adoConnect = > Server.CreateObject("ADODB.Connection"): > > adoConnect.ConnectionTimeout = 30 'increment the time > to establish connection a bit > > adoConnect.CommandTimeout = 300 'give it five minutes > to complete the query > > adoConnect.Open "Provider=MSDASQL;Driver={SQL > Server};Server=SQL6932440;Database=paragon;UID=sa;PWD=;" > > Set adoRecordset = adoConnect.Execute (sSPName & " '"& > sSDate & "','" & sEDate & "'") > > > Thank You in Advance > > Ian Skinner > [EMAIL PROTECTED] > www.ilsweb.com > > > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
