odbc ole-db

2001-04-09 Thread Mike
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. Ge

RE: odbc ole-db

2001-04-09 Thread Greg Jordan
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 ~~ Stru

RE: odbc ole-db

2001-04-09 Thread Nick McClure
gt;ONE DSN > >Greg > >-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 othe

RE: odbc ole-db

2001-04-10 Thread Zachary S. Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > One of the big things about it is MS is discontinuing support > of ODBC. > Their preferred method is currently OLE DB. It also what they use to > connect to Exchange and other data types. Here's the reason for that: OLE/DB is the native langu

RE: odbc ole-db, stored proc

2001-04-09 Thread dm
ce 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 o

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 and

RE: odbc ole-db, stored proc

2001-04-09 Thread dm
this fixed it: SET NOCOUNT ON Exec MyProc SET NOCOUNT OFF ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/