User Guide

88 Administering ColdFusion Server
Configuring Microsoft SQL Server Options (UNIX)
If ColdFusion Server is installed on a Solaris server, you can configure Microsoft SQL
Server as a ColdFusion data source using an ODBC driver.
ODBC: MERANT MS SQL Server Options for (Solaris)
The following table describes ColdFusion options for the MERANT MS SQL Server
ODBC driver. You set these options when you configure a ColdFusion data source. See
“Adding Data Sources for ColdFusion” on page 82 for more information
Login Info Database — The name of the SQL Server database.
Language — The national language used by SQL Server.
Generate Stored Procedure for Prepared Statement — Stored
procedures are created for prepared statements when this option
is selected. The SQL Server driver prepares a statement by placing
it in a procedure and compiling that procedure.
Translation Convert OEM to ANSI characters — If the SQL Server client
computer and SQL Server are using the same non-ANSI character
set, select this option. For example, if SQL Server uses code page
850 and this client computer uses code page 850 for the OEM code
page, selecting this option will ensure that extended characters
stored in the database are properly converted to ANSI for use by
Windows-based applications.
Microsoft SQL Server ODBC Options (Continued)
Option Description
MERANT MS SQL Server ODBC Options
Option Description
Data Source Name A name for your ODBC data source.
Description Descriptive information about the data source.
Database Name The name of the database to which you want to connect.
Server Name The name of the server that contains the SQL database you want
to access.
Workstation ID The workstation ID used by the client.