subject:"RE\: odbc ole\-db, stored proc"

RE: odbc ole-db, stored proc

2001-04-09 Thread dm

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

RE: odbc ole-db, stored proc

2001-04-09 Thread Greg Jordan

did you add an OLE DB DSN in the CF administrator? Greg -Original Message- From: dm [mailto:[EMAIL PROTECTED]] Sent: Monday, April 09, 2001 3:34 PM To: CF-Talk Subject: RE: odbc ole-db, stored proc running a stored procedure on sql server 2k. sp executes fine from query analyzer

RE: odbc ole-db, stored proc

2001-04-09 Thread dm

this fixed it: CFQUERY SET NOCOUNT ON Exec MyProc SET NOCOUNT OFF /CFQUERY ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: