When an application requests a result set from new SQL Server 2008 collations, you may receive an "MSG 40242" or "MSG 40205" error when the ODBC driver for SQL Server is used or an "MSG 40234" error when the SQL OLE DB pro...

Applies To
Microsoft Windows XP Home Edition Microsoft Windows XP Professional Windows Vista Enterprise 64-bit Edition Windows Vista Home Basic 64-bit Edition Windows Vista Home Premium 64-bit Edition Windows Vista Ultimate 64-bit Edition Windows Vista Business Windows Vista Business 64-bit Edition Windows Vista Enterprise Windows Vista Home Basic Windows Vista Home Premium Windows Vista Ultimate Windows Server 2008 Datacenter without Hyper-V Windows Server 2008 Enterprise without Hyper-V Windows Server 2008 for Itanium-Based Systems Windows Server 2008 Standard without Hyper-V Windows Server 2008 Datacenter Windows Server 2008 Enterprise Windows Server 2008 Standard

Symptoms

Consider the following scenario:

  • You have data that is stored in one of the new Microsoft SQL Server 2008 collations.

  • You have an application on a computer that is running one of the following operating systems:

    • Windows XP
    • Windows Server 2003
    • Windows Vista
    • Windows Server 2008

In this scenario, you may experience one of the following symptoms:

Symptom 1

You receive an error message when the following conditions are true:

  • The application uses the Open Database Connectivity (ODBC) driver or the SQL OLE DB provider to request a result set.
  • The result set contains a column that uses one of the new collations.
  • The column is defined as the SQLTEXT type, the SQLBIGCHAR type, or the SQLBIGVARCHAR type.

If the application uses the ODBC driver, you receive the following error message:

Note

Msg 40242

Unable to resolve column level collations system

If the application uses the SQL OLE DB provider, you receive the following error message:

Note

Msg 40234

Unicode conversion failed. Code page of server not on client

Symptom 2

The connection to the new SQL Server 2008 collations is closed, and an error message is logged in the SQL Server Error log file when the following conditions are true:

  • The application uses the Open Database Connectivity (ODBC) driver or the SQL OLE DB provider to request a result set.
  • The result set contains data of the SQL_VARIANT data type.
  • The data is stored in one of the new collations, and the SQL_VARIANT data contains the SQLTEXT type, the SQLBIGCHAR type, or the SQLBIGVARCHAR type.

If the application uses the ODBC driver, you receive the following error message:

Note

Msg 40242

Unable to resolve column level collations system

If the application uses the SQL OLE DB provider, you receive the following error message:

Note

Msg 40234

Unicode conversion failed. Code page of server not on client

Symptom 3

The client application requests an output parameter. If the output parameter uses one of the new collations, the parameter is defined as the SQLBIGCHAR type, the SQLBIGVARCHAR type, or the SQLTEXT type, and an error is returned to the client application.

If the application uses the ODBC driver, you receive the following error message:

Note

Msg 40242

Unable to resolve column level collations system

If the application uses the SQL OLE DB provider, you receive the following error message:

Note

Msg 40234

Unicode conversion failed. Code page of server not on client

Symptom 4

The connection to the new SQL Server 2008 collations is closed, and an error message is logged in the SQL Server Error log file when the following conditions are true:

  • The application requests an output parameter.
  • The data type of the output parameter is SQL_VARIANT.
  • The output parameter uses one of the new collations, and the SQL_VARIANT data contains the SQLCHAR type or the SQLVARCHAR type.

If the application uses the ODBC driver, you receive the following error message:

Note

Msg 40242

Unable to resolve column level collations system

If the application uses the SQL OLE DB provider, you receive the following error message:

Note

Msg 40234

Unicode conversion failed. Code page of server not on client

Symptom 5

The client application connects to a database, and the default collation that the database uses is one of the new collations. In this case, an error is returned to the client application.

If the application uses the ODBC driver, you receive the following error message:

Note

Msg 40205

Unicode conversion failed

If the application uses the SQL OLE DB provider, you receive the following error message:

Note

Msg 40234

Unicode conversion failed. Code page of server not on client

Symptom 6

When you run the USE statement to switch to a database that uses one of the new collations, you receive the error messages that are listed for "Symptom 5."

Cause

This problem occurs when the data is stored in one of the new collations in SQL Server 2008. The client-side application does not recognize the new collations in SQL Server 2008.

Resolution

An update is available to resolve these problems.

  1. After you apply this update in Windows Vista or in Windows Server 2008, you can request data that uses new SQL Server 2008 collations.
  2. After you apply this update in Windows XP or in Windows Server 2003, you can request data that uses new Unicode SQL Server 2008 collations. However, if you request data that uses new ANSI SQL Server 2008 collations, you still encounter the problems that are described in this article.

Download information

The following files are available for download from the Microsoft Download Center:

Update for Windows XP for x86-based versions (KB954920)

Download Download the 954920 package now.

Update for Windows Server 2003 for x86-based versions (KB954920)

Download Download the 954920 package now.

Update for Windows Server 2003 x64-based versions (KB954920)

Download Download the 954920 package now.

Update for Windows Server 2003 for Itanium-based versions (KB954920)

Download Download the 954920 package now.

Update for Windows Vista for x86-based versions (KB954920)

Download Download the 954920 package now.

Update for Windows Vista for x64-based versions (KB954920)

Download Download the 954920 package now.

Update for Windows Server 2008 for x86-based versions (KB954920)

Download Download the 954920 package now.

Update for Windows Server 2008 for x64-based versions (KB954920)

Download Download the 954920 package now.

Update for Windows Server 2008 for Itanium-based Systems (KB954920)

Download Download the 954920 package now.

Release Date: September 23, 2008

For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to obtain Microsoft support files from online services
Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.

Update information for Windows XP

Prerequisites

To apply this update, you must have Windows XP Service Pack 2 (SP2) or Windows XP Service Pack 3 (SP3) installed on the computer.

Restart requirement

You have to restart the computer after you apply this update.

Update replacement information

This update does not replace any other previously released updates.

File information

The English version of this update has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

Windows XP SP2, x86-based versions

File name File version File size Date Time Platform SP requirement
Odbcbcp.dll 2000.85.1140.0 24,576 21-Aug-2008 16:23 x86 SP2
Sqloledb.dll 2000.85.1140.0 528,384 21-Aug-2008 16:23 x86 SP2
Sqlsrv32.dll 2000.85.1140.0 446,464 21-Aug-2008 16:23 x86 SP2
Odbcbcp.dll 2000.85.1140.0 24,576 21-Aug-2008 17:00 x86 SP2
Sqloledb.dll 2000.85.1140.0 528,384 21-Aug-2008 17:00 x86 SP2
Sqlsrv32.dll 2000.85.1140.0 446,464 21-Aug-2008 17:00 x86 SP2

Windows XP SP3, x86-based versions

File name File version File size Date Time Platform SP requirement
Odbcbcp.dll 2000.85.3006.0 24,576 21-Aug-2008 16:41 x86 SP3
Sqloledb.dll 2000.85.3006.0 528,384 21-Aug-2008 16:41 x86 SP3
Sqlsrv32.dll 2000.85.3006.0 446,464 21-Aug-2008 16:41 x86 SP3
Odbcbcp.dll 2000.85.3006.0 24,576 21-Aug-2008 16:44 x86 SP3
Sqloledb.dll 2000.85.3006.0 528,384 21-Aug-2008 16:44 x86 SP3
Sqlsrv32.dll 2000.85.3006.0 446,464 22-Aug-2008 05:14 x86 SP3

Update information for Windows Server 2003

Prerequisites

To apply this update, you must have Windows Server 2003 Service Pack 1 or Windows Server 2003 Service Pack 2 installed on the computer.

Restart requirement

You have to restart the computer after you apply this hotfix.

Hotfix replacement information

This hotfix does not replace any other previously released hotfixes.

File information

The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

Windows Server 2003 SP1, x86-based versions

File name File version File size Date Time Platform SP requirement
Odbcbcp.dll 2000.86.3197.0 24,576 25-Aug-2008 13:49 x86 SP1
Sqloledb.dll 2000.86.3197.0 532,480 25-Aug-2008 13:49 x86 SP1
Sqlsrv32.dll 2000.86.3197.0 446,464 25-Aug-2008 13:49 x86 SP1
Odbcbcp.dll 2000.86.3197.0 24,576 25-Aug-2008 13:45 x86 SP1
Sqloledb.dll 2000.86.3197.0 532,480 25-Aug-2008 13:45 x86 SP1
Sqlsrv32.dll 2000.86.3197.0 446,464 25-Aug-2008 13:45 x86 SP1

Windows Server 2003 SP2, x86-based versions

File name File version File size Date Time Platform SP requirement
Odbcbcp.dll 2000.86.4360.0 24,576 25-Aug-2008 13:23 x86 SP2
Sqloledb.dll 2000.86.4360.0 532,480 25-Aug-2008 13:23 x86 SP2
Sqlsrv32.dll 2000.86.4360.0 446,464 25-Aug-2008 13:23 x86 SP2
Odbcbcp.dll 2000.86.4360.0 24,576 25-Aug-2008 13:54 x86 SP2
Sqloledb.dll 2000.86.4360.0 532,480 25-Aug-2008 13:54 x86 SP2
Sqlsrv32.dll 2000.86.4360.0 446,464 26-Aug-2008 02:45 x86 SP2

Windows Server 2003 SP1, x64-based versions

File name File version File size Date Time Platform SP requirement Service branch
Odbcbcp.dll 2000.86.3197.0 32,768 26-Aug-2008 02:50 x64 SP1 Not Applicable
Sqloledb.dll 2000.86.3197.0 876,544 26-Aug-2008 02:50 x64 SP1 Not Applicable
Sqlsrv32.dll 2000.86.3197.0 675,840 26-Aug-2008 02:50 x64 SP1 Not Applicable
Wodbcbcp.dll 2000.86.3197.0 24,576 26-Aug-2008 02:50 x86 SP1 WOW
Wsqloledb.dll 2000.86.3197.0 532,480 26-Aug-2008 02:50 x86 SP1 WOW
Wsqlsrv32.dll 2000.86.3197.0 446,464 26-Aug-2008 02:50 x86 SP1 WOW
Odbcbcp.dll 2000.86.3197.0 32,768 26-Aug-2008 02:51 x64 SP1 Not Applicable
Sqloledb.dll 2000.86.3197.0 876,544 26-Aug-2008 02:51 x64 SP1 Not Applicable
Sqlsrv32.dll 2000.86.3197.0 675,840 26-Aug-2008 02:51 x64 SP1 Not Applicable
Wodbcbcp.dll 2000.86.3197.0 24,576 26-Aug-2008 02:51 x86 SP1 WOW
Wsqloledb.dll 2000.86.3197.0 532,480 26-Aug-2008 02:51 x86 SP1 WOW
Wsqlsrv32.dll 2000.86.3197.0 446,464 26-Aug-2008 02:51 x86 SP1 WOW

Windows Server 2003 SP2, x64-based versions

File name File version File size Date Time Platform SP requirement Service branch
Odbcbcp.dll 2000.86.4360.0 32,768 26-Aug-2008 02:56 x64 SP2 Not Applicable
Sqloledb.dll 2000.86.4360.0 876,544 26-Aug-2008 02:56 x64 SP2 Not Applicable
Sqlsrv32.dll 2000.86.4360.0 675,840 26-Aug-2008 02:57 x64 SP2 Not Applicable
Wodbcbcp.dll 2000.86.4360.0 24,576 26-Aug-2008 02:57 x86 SP2 WOW
Wsqloledb.dll 2000.86.4360.0 532,480 26-Aug-2008 02:57 x86 SP2 WOW
Wsqlsrv32.dll 2000.86.4360.0 446,464 26-Aug-2008 02:57 x86 SP2 WOW
Odbcbcp.dll 2000.86.4360.0 32,768 26-Aug-2008 02:50 x64 SP2 Not Applicable
Sqloledb.dll 2000.86.4360.0 880,640 26-Aug-2008 02:50 x64 SP2 Not Applicable
Sqlsrv32.dll 2000.86.4360.0 675,840 26-Aug-2008 02:50 x64 SP2 Not Applicable
Wodbcbcp.dll 2000.86.4360.0 24,576 26-Aug-2008 02:50 x86 SP2 WOW
Wsqloledb.dll 2000.86.4360.0 532,480 26-Aug-2008 02:50 x86 SP2 WOW
Wsqlsrv32.dll 2000.86.4360.0 446,464 26-Aug-2008 02:50 x86 SP2 WOW

Windows Server 2003 SP1, Itanium-based versions

File name File version File size Date Time Platform SP requirement Service branch
Odbcbcp.dll 2000.86.3197.0 53,248 26-Aug-2008 02:50 IA-64 SP1 Not Applicable
Sqloledb.dll 2000.86.3197.0 1,585,152 26-Aug-2008 02:50 IA-64 SP1 Not Applicable
Sqlsrv32.dll 2000.86.3197.0 1,130,496 26-Aug-2008 02:50 IA-64 SP1 Not Applicable
Wodbcbcp.dll 2000.86.3197.0 24,576 26-Aug-2008 02:50 x86 SP1 WOW
Wsqloledb.dll 2000.86.3197.0 532,480 26-Aug-2008 02:50 x86 SP1 WOW
Wsqlsrv32.dll 2000.86.3197.0 446,464 26-Aug-2008 02:50 x86 SP1 WOW
Odbcbcp.dll 2000.86.3197.0 53,248 26-Aug-2008 02:50 IA-64 SP1 Not Applicable
Sqloledb.dll 2000.86.3197.0 1,585,152 26-Aug-2008 02:50 IA-64 SP1 Not Applicable
Sqlsrv32.dll 2000.86.3197.0 1,126,400 26-Aug-2008 02:50 IA-64 SP1 Not Applicable
Wodbcbcp.dll 2000.86.3197.0 24,576 26-Aug-2008 02:50 x86 SP1 WOW
Wsqloledb.dll 2000.86.3197.0 532,480 26-Aug-2008 02:50 x86 SP1 WOW
Wsqlsrv32.dll 2000.86.3197.0 446,464 26-Aug-2008 02:50 x86 SP1 WOW

Windows Server 2003 SP2, Itanium-based versions

File name File version File size Date Time Platform SP requirement Service branch
Odbcbcp.dll 2000.86.4360.0 53,248 26-Aug-2008 02:50 IA-64 SP2 Not Applicable
Sqloledb.dll 2000.86.4360.0 1,589,248 26-Aug-2008 02:50 IA-64 SP2 Not Applicable
Sqlsrv32.dll 2000.86.4360.0 1,130,496 26-Aug-2008 02:50 IA-64 SP2 Not Applicable
Wodbcbcp.dll 2000.86.4360.0 24,576 26-Aug-2008 02:50 x86 SP2 WOW
Wsqloledb.dll 2000.86.4360.0 532,480 26-Aug-2008 02:50 x86 SP2 WOW
Wsqlsrv32.dll 2000.86.4360.0 446,464 26-Aug-2008 02:50 x86 SP2 WOW
Odbcbcp.dll 2000.86.4360.0 53,248 26-Aug-2008 02:54 IA-64 SP2 Not Applicable
Sqloledb.dll 2000.86.4360.0 1,585,152 26-Aug-2008 02:54 IA-64 SP2 Not Applicable
Sqlsrv32.dll 2000.86.4360.0 1,126,400 26-Aug-2008 02:54 IA-64 SP2 Not Applicable
Wodbcbcp.dll 2000.86.4360.0 24,576 26-Aug-2008 02:54 x86 SP2 WOW
Wsqloledb.dll 2000.86.4360.0 532,480 26-Aug-2008 02:54 x86 SP2 WOW
Wsqlsrv32.dll 2000.86.4360.0 446,464 26-Aug-2008 02:54 x86 SP2 WOW

Update information for Windows Vista and for Windows Server 2008

Prerequisites

To apply this hotfix, the computer must run one of the following:

  • Windows Vista
  • Windows Vista SP1
  • Windows Server 2008

Restart requirement

You have to restart the computer after you apply this hotfix.

Hotfix replacement information

This hotfix does not replace any other previously released hotfixes.

File information

The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

Windows Vista, x86-based versions

File name File version File size Date Time Platform
Odbcbcp.dll 6.0.6000.16736 28,672 22-Aug-2008 03:34 x86
Odbcbcp.dll 6.0.6000.20901 28,672 22-Aug-2008 03:15 x86
Sqlsrv32.dll 6.0.6000.16736 520,192 22-Aug-2008 03:34 x86
Sqlsrv32.dll 6.0.6000.20901 520,192 22-Aug-2008 03:15 x86
Sqloledb.dll 6.0.6000.16736 663,552 22-Aug-2008 03:34 x86
Sqloledb.dll 6.0.6000.20901 663,552 22-Aug-2008 03:15 x86

Windows Vista SP1 and Windows Server 2008, x86-based versions

File name File version File size Date Time Platform
Odbcbcp.dll 6.0.6001.18127 28,672 22-Aug-2008 03:38 x86
Odbcbcp.dll 6.0.6001.22249 28,672 22-Aug-2008 03:32 x86
Sqlsrv32.dll 6.0.6001.18127 524,288 22-Aug-2008 03:38 x86
Sqlsrv32.dll 6.0.6001.22249 524,288 22-Aug-2008 03:32 x86
Sqloledb.dll 6.0.6001.18127 663,552 22-Aug-2008 03:38 x86
Sqloledb.dll 6.0.6001.22249 663,552 22-Aug-2008 03:32 x86

Windows Vista, x64-based versions

File name File version File size Date Time Platform
Odbcbcp.dll 6.0.6000.16736 32,768 22-Aug-2008 03:31 x64
Odbcbcp.dll 6.0.6000.20901 32,768 22-Aug-2008 03:24 x64
Sqlsrv32.dll 6.0.6000.16736 581,632 22-Aug-2008 03:31 x64
Sqlsrv32.dll 6.0.6000.20901 581,632 22-Aug-2008 03:25 x64
Sqloledb.dll 6.0.6000.16736 790,528 22-Aug-2008 03:31 x64
Sqloledb.dll 6.0.6000.20901 790,528 22-Aug-2008 03:25 x64
Odbcbcp.dll 6.0.6000.16736 28,672 22-Aug-2008 03:34 x86
Odbcbcp.dll 6.0.6000.20901 28,672 22-Aug-2008 03:15 x86
Sqlsrv32.dll 6.0.6000.16736 520,192 22-Aug-2008 03:34 x86
Sqlsrv32.dll 6.0.6000.20901 520,192 22-Aug-2008 03:15 x86
Sqloledb.dll 6.0.6000.16736 663,552 22-Aug-2008 03:34 x86
Sqloledb.dll 6.0.6000.20901 663,552 22-Aug-2008 03:15 x86

Windows Vista with Service Pack 1 and Windows Server 2008, x64-based versions

File name File version File size Date Time Platform
Odbcbcp.dll 6.0.6001.18127 32,768 22-Aug-2008 03:45 x64
Odbcbcp.dll 6.0.6001.22249 32,768 22-Aug-2008 04:40 x64
Sqlsrv32.dll 6.0.6001.18127 581,632 22-Aug-2008 03:45 x64
Sqlsrv32.dll 6.0.6001.22249 581,632 22-Aug-2008 04:40 x64
Sqloledb.dll 6.0.6001.18127 786,432 22-Aug-2008 03:45 x64
Sqloledb.dll 6.0.6001.22249 786,432 22-Aug-2008 04:40 x64
Odbcbcp.dll 6.0.6001.18127 28,672 22-Aug-2008 03:38 x86
Sqlsrv32.dll 6.0.6001.18127 524,288 22-Aug-2008 03:38 x86
Sqlsrv32.dll 6.0.6001.22249 524,288 22-Aug-2008 03:32 x86
Sqloledb.dll 6.0.6001.18127 663,552 22-Aug-2008 03:38 x86
Sqloledb.dll 6.0.6001.22249 663,552 22-Aug-2008 03:32 x86

Windows Server 2008, Itanium-based versions

File name File version File size Date Time Platform
Odbcbcp.dll 6.0.6001.18127 53,248 22-Aug-2008 03:55 IA-64
Odbcbcp.dll 6.0.6001.22249 53,248 22-Aug-2008 04:53 IA-64
Sqlsrv32.dll 6.0.6001.18127 1,085,440 22-Aug-2008 03:55 IA-64
Sqlsrv32.dll 6.0.6001.22249 1,085,440 22-Aug-2008 04:54 IA-64
Sqloledb.dll 6.0.6001.18127 1,470,464 22-Aug-2008 03:55 IA-64
Sqloledb.dll 6.0.6001.22249 1,470,464 22-Aug-2008 04:54 IA-64
Odbcbcp.dll 6.0.6001.18127 28,672 22-Aug-2008 03:38 x86
Odbcbcp.dll 6.0.6001.22249 28,672 22-Aug-2008 03:32 x86
Sqlsrv32.dll 6.0.6001.18127 524,288 22-Aug-2008 03:38 x86
Sqlsrv32.dll 6.0.6001.22249 524,288 22-Aug-2008 03:32 x86
Sqloledb.dll 6.0.6001.18127 663,552 22-Aug-2008 03:38 x86
Sqloledb.dll 6.0.6001.22249 663,552 22-Aug-2008 03:32 x86

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

More Information

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

824684 Description of the standard terminology that is used to describe Microsoft software updates