running a stored procedure on sql server 2k.
sp executes fine from query analyzer and
returns a result.
when i try to call the sp from cf using
either cfquery or cfstoredproc
i get a 'query does not exist error' on the output.
that was/is on an OLEDB connection.
added an odbc datasource and the problem is gone,
i.e., the query is found and the results outputted.
what do i need to do to get the sp to
work under OLE as it does under ODBC?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
