I'll take a crack at it...
do you really have to specify all those extra attributes: provider,
providerdsn, etc?
I'm thinking that your value for provider is incorrect. If you in fact
created a datasource in the administrator and it verified, you shouldn't
have to specify a provider in the procedure call unless you're doing
something funky.
Just a guess.
Jeremy
> -----Original Message-----
> From: Houk, Gary [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 22, 2001 3:17 PM
> To: [EMAIL PROTECTED]
> Subject: OLEDB error when using stored procedures
>
>
> I have created an OLEDB connection through CF administrator.
> I have also
> created a SP that executes successfully when using the query analyzer.
> However, when trying to get it into a page, I get the following error:
>
> Error Diagnostic Information
> OLEDB Error Code = 0
>
> NULL Interface Ptr
>
> SQL = "sp_volproducts"
>
> Data Source = "EXTRANET"
>
> The error occurred while processing an element with a general
> identifier
> of (CFSTOREDPROC), occupying document position (12:1) to
> (21:29) in the
> template file g:\inetpub\wwwroot\vol_mup\test.cfm.
>
> Here is my code:
>
> <cfstoredproc procedure="sp_volproducts"
> datasource="EXTRANET"
> username="cfoledb"
> password="fusionman"
> dbserver="TPSQL\MIS"
> dbname="EXTRANET"
> provider="EXTRANET"
> providerdsn="EXTRANET"
> debug="Yes"
> dbtype="oledb">
>
>
> </cfstoredproc>
>
> Both the database and datasource are named EXTRANET. Can
> anyone point me
> in the right direction here?
>
> Thanks in advance,
>
> - Gary
>
>
> --------------------------------------------------------------
> -----------
> This email server is running an evaluation copy of the
> MailShield anti-
> spam software. Please contact your email administrator if you have any
> questions about this message. MailShield product info:
> www.mailshield.com
>
> -----------------------------------------------
> To post, send email to [EMAIL PROTECTED]
> To subscribe / unsubscribe: http://www.dfwcfug.org
>
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
