On a side note: I thought ADO was the latest MS protocol for database
access? Or is that an abstract layer above ODBC or something? Also, I
thought SQL Server's true native protocol (aside from legacy ODBC) was TDS.
That's the protocol that JDBC drivers have to talk, unless they use ODBC,
which only the crappy ones do.
Scott Stirling
Allaire Corporation
> -----Original Message-----
> From: Peter Yellman [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 08, 2000 12:38 PM
> To: CF-Linux
> Subject: Re: Can't use stored procedures if connecting via ODBC?
>
>
> First, there is no distinction between "native" and ODBC in
> regard to MS
> SQL (Microsoft primarily devised and established ODBC), and it follows
> that there are no "particular" issues using stored procedures
> with ODBC
> and MS SQL, other than those that might generally apply to the use of
> stored procedures and MS SQL. You may also choose to use
> OLEDB (a more
> recent MS data access technology) drivers to access MS SQL and certain
> other datasources if your CF server is on an MS platform.
>
> Second, I see the Merant MS SQL server driver in my list of available
> drivers on my CF 4.51 Pro installation on Linux. I assume this driver
> is an ODBC driver. That does not necessarily mean that you won't have
> problems using stored procedures with MS SQL that you wouldn't have if
> you were on an MS platform, as you might assume that MS is the best at
> implementing their own standard. I don't know if CF Enterprise adds
> anything in regard to accessing MS SQL from Linux.
>
> My recollection is that in order to use stored procedures with other
> databases such as Oracle, Sybase, etc., you must use native
> drivers (and
> therefore CF Enterprise); however, I could be wrong about this.
>
> -- Peter Yellman
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
