odbccmpt Utility

The odbccmpt utility enables or disables the 6.5 ODBC compatibility option for an ODBC application executable file.

Syntax

odbccmpt file_name [ -d ]

Arguments

file_name

Is the name of the application executable file for which the 6.5 ODBC compatibility option is to be enabled or disabled. Specify the executable file name without any path or file extension. For example, if the full path and name of your executable file is C:\Winnt\System32\MyApp.exe, only specify MyApp. Do not enclose file_name in quotation marks.

Only specify the names of ODBC applications written for Microsoft® SQL Server™ version 6.5 or earlier. Do not specify the name of the executable file for:

• Any application in the Microsoft SQL Server 7.0 program group.
• Any SQL Server 7.0 command prompt utility.
• The SQL Server executable file, Sqlservr.exe.

-d

Specifies that the 6.5 ODBC compatibility option is to be disabled for the application named in file_name. If -d is not specified, the 6.5 ODBC compatibility option is enabled for the application named in file_name.

Remarks

The 6.5 ODBC compatibility option sets certain behaviors of the 3.7 SQL Server ODBC driver to be compatible with earlier SQL Server ODBC drivers. This is only needed when using the 3.7 SQL Server ODBC driver and connecting to SQL Server 7.0 using applications developed with earlier versions of the SQL Server ODBC driver. The 6.5 ODBC compatibility option can be turned on for applications using either the ODBC 2.x or ODBC 3.x API.

odbccmpt does not need to be run for applications connecting to earlier versions of SQL Server using the 3.7 SQL Server ODBC driver. The 3.7 driver automatically runs in compatibility mode when it connects to earlier versions of SQL Server. odbccmpt does not need to be run for applications using earlier versions of the SQL Server ODBC driver connecting to SQL Server 7.0. SQL Server 7.0 automatically treats any application using the earlier drivers as a 6.5-level application.

Enabling the 6.5 ODBC compatibility option for an application causes the application to be treated as a 6.5-level application. The setting enables these changes in the behavior of the 3.7 SQL Server ODBC driver when it connects to SQL Server 7.0:

• The driver exhibits SQL Server 6.5 behavior for SQLPrepare and SQLExecute. The driver does not use the prepare/execute support built into SQL Server 7.0. The driver generates temporary stored procedures if the option to generate stored procedures for SQLPrepare is turned on.
• The SET CONCAT_NULL_YIELDS_NULL option is turned off.
• An input parameter can be bound as either SQL_PARAM_INPUT_OUTPUT or SQL_PARAM_OUTPUT with SQLBindParameter.
• Result sets are returned by the driver in a format comparable to the result sets returned to a SQL Server 6.5 client:
  • Data from nchar and nvarchar columns are not treated as Unicode data, they are interpreted as character data using the Windows code page on the server running SQL Server. The ODBC catalog functions report nchar, nvarchar, and uniqueidentifier columns as char, varchar, and varbinary respectively.
  • Data cannot be retrieved from ntext columns.
  • nchar and nvarchar columns bound to SQL_C_DEFAULT return character data instead of Unicode data.
  • char, varchar, binary, and varbinary data values over 255 bytes are truncated to 255 bytes when they are returned to the application. nchar and nvarchar data values over 255 characters are truncated to 255 char or varchar characters.
  • Object names longer than 30 bytes are truncated to 30 bytes.

    This truncation may affect additional operations, such as preventing SQLSetPos updates referencing text and image columns.

  • Null values in bit columns are returned as 0.

    Catalog results show all bit columns as NOT NULL because bit columns did not support null values in SQL Server 6.5.

  • Data from uniqueidentifier columns is returned as varbinary data.
  • The final node in the version string returned by the SQL_DBMS_VER parameter of SQLGetInfo never exceeds 255, regardless of the actual version string returned from the SQL Server the application is connected to.
  • The SQLGetInfo attributes reporting the data types supported by the driver do not report the new data types introduced in SQL Server 7.0.

The 6.5 ODBC compatibility option can only be set at the level of an executable file. It cannot be set for individual DLLs.

When odbccmpt is run to enable the 6.5 ODBC compatibility option, it creates a registry key:

HKEY_LOCAL_MACHINE
    SOFTWARE
        Microsoft
            MSSQLServer
                Client
                    ODBCAppCompat
                        file_name:REG_SZ:6.5

When odbccmpt is run with the -d parameter, this key is removed. No error message is returned if odbccmpt is run with the -d parameter and there is no registry key for file_name.

Whenever the 3.7 SQL Server ODBC driver connects to SQL Server 7.0, it checks the registry for a key matching the name of the executable file for the application. If a match is found, the driver enables the 6.5 ODBC compatibility option. If no match is made, the 6.5 ODBC compatibility option is not enabled.

Note Most ODBC applications can switch without change from the 2.65 SQL Server ODBC driver to the 3.7 driver. odbccmpt is a migration aid to assist with moving applications from SQL Server version 6.5 to version 7.0. It should be used only for applications having problems in moving to SQL Server 7.0 and the 3.7 SQL Server ODBC driver. odbccmpt should only be used until the application has been corrected.

Examples

A. Enable the 6.5 ODBC compatibility option

odbccmpt MyApp

B. Disable the 6.5 ODBC compatibility option

odbccmpt MyApp -d