Every NULL Interface PTR error I've seen means you don't have an OLEDB datasource configured correctly.
Make sure the datasource PARAGON is confingured correctly and is, indeed, an OLEDB datasource. -----Original Message----- From: Ian Skinner [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 23, 2002 1:43 PM 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
