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?
-----Original Message-----
From: Mike [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 6:20 PM
To: CF-Talk
Subject: odbc ole-db
odbc ole-db
What is the deference's?
Is there any advantage or disadvantage over one or the other?
Thanks for the answers on the last question you guys are a life saver!
Thanks
Mike
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
