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
