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
Ryan wrote:
>
> We were planning on setting up our CF servers with ODBC drivers to
> MS SQL server. Do you mean we won't be able to use stored procedures,
> even using the CFSTOREDPROC tag? We were not going to go with the
> enterprise version, but even if we did are there native MS SQL drivers
> for linux? Thanks,
>
> Ryan
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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.
