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 language

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

2001-04-09 Thread Greg Jordan
one big advantage with OLE DB over ODBC using SQL Server is this: ODBC - for each database you have to set up an DSN OLE DB - you set up one DSN and all the databases can be referenced via that ONE DSN Greg -Original Message- From: Mike [mailto:[EMAIL PROTECTED]] Sent: Monday, April

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:

RE: odbc ole-db

2001-04-09 Thread Nick McClure
ODBC can do this as well. In the select statement you user Database.dbo.table in ODBC as well. It all depends on the security settings you have. 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