-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
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
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
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
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:
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
6 matches
Mail list logo