FIX: An empty string is returned when data is retrieved from a varchar (max) column by using SQL Native Client in Visual C++ .NET 2003 SP1

Article translations Article translations
Article ID: 954885 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

You create an application that uses the CDatabase object or the CRecordset object to call the GetFieldValue function in Microsoft Visual C++ .NET 2003 Service Pack 1 (SP1). You use this application to retrieve data from a field by using SQL Native Client (SNAC)-ODBC-driver. The field is of the varchar (max) Microsoft SQL Server 2005 data type. When you run the application, an empty string is returned instead of the real value.

Note The correct results are returned if the SQL ODBC driver is used.

CAUSE

This problem occurs because the SNAC driver introduces a new data type that is not expected when the MFC 7.1 libraries are written.

RESOLUTION

A supported hotfix is available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing the problem described in this article. This hotfix might receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next software update that contains this hotfix.

If the hotfix is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, contact Microsoft Customer Service and Support to obtain the hotfix.

Note If additional issues occur or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft Web site:
http://support.microsoft.com/contactus/?ws=support
Note The "Hotfix download available" form displays the languages for which the hotfix is available. If you do not see your language, it is because a hotfix is not available for that language.

Prerequisites

You must have Visual Studio .NET 2003 SP1 installed to apply this hotfix.

Restart requirement

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

Hotfix replacement information

This hotfix does not replace any other 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.
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Atl71.dll7.10.6088.090,11205-Aug- 200823:13x86
Atl71.dll7.10.6088.0106,49605-Aug- 200823:13x86
atl.libNot applicable14,54605-Aug- 200823:13Not applicable
atldload.libNot applicable51,93605-Aug- 200823:36Not applicable
atlmincrt.libNot applicable61,93005-Aug- 200823:13Not applicable
atls.libNot applicable1,282,96405-Aug- 200823:13Not applicable
atlsd.libNot applicable1,326,97605-Aug- 200823:13Not applicable
dbcore.cppNot applicable118,48120-May- 200811:33Not applicable
eafxis.libNot applicable329,60205-Aug- 200823:37Not applicable
eafxisd.libNot applicable320,96805-Aug- 200823:37Not applicable
mfc71.libNot applicable2,580,01005-Aug- 200823:39Not applicable
mfc71d.libNot applicable3,361,06205-Aug- 200823:38Not applicable
mfc71d.mapNot applicable2,187,48605-Aug- 200823:38Not applicable
mfc71u.libNot applicable3,348,14005-Aug- 200823:41Not applicable
mfc71u.mapNot applicable1,192,80005-Aug- 200823:54Not applicable
mfc71ud.libNot applicable4,287,96005-Aug- 200823:40Not applicable
mfc71ud.mapNot applicable2,235,78005-Aug- 200823:39Not applicable
mfcdloadNot applicable96,24405-Aug- 200823:36Not applicable
mfcs71.libNot applicable565,98605-Aug- 200823:39Not applicable
mfcs71d.libNot applicable586,40805-Aug- 200823:38Not applicable
mfcs71u.libNot applicable491,98405-Aug- 200823:46Not applicable
mfcs71ud.libNot applicable509,50605-Aug- 200823:40Not applicable
nafxcw.libNot applicable17,308,18205-Aug- 200823:37Not applicable
nafxcwd.libNot applicable17,391,77005-Aug- 200823:37Not applicable
nafxis.libNot applicable143,59805-Aug- 200823:37Not applicable
nafxisd.libNot applicable147,53605-Aug- 200823:37Not applicable
uafxcw.libNot applicable17,599,21005-Aug- 200823:38Not applicable
uafxcwd.libNot applicable17,789,03205-Aug- 200823:38Not applicable
VC_User_ATL71_RTL_X86_---.msmNot applicable102,40006-Aug-200816:17Not applicable
VC_User_MFC71_Loc_RTL_X86_-- -.msmNot applicable100,86406-Aug-200816:17Not applicable
VC_User_MFC71_RTL_X86_---.msmNot applicable893,95206-Aug- 200816:17Not applicable
Mfc71.dll7.10.6088.01,060,86405-Aug- 200823:39x86
Mfc71chs.dll7.10.6088.040,96005-Aug- 200823:43x86
Mfc71cht.dll7.10.6088.045,05605-Aug- 200823:43x86
Mfc71d.dll7.10.6088.02,191,36005-Aug- 200823:38x86
Mfc71deu.dll7.10.6088.065,53605-Aug- 200823:43x86
Mfc71enu.dll7.10.6088.057,34405-Aug- 200823:43x86
Mfc71esp.dll7.10.6088.061,44005-Aug- 200823:43x86
Mfc71fra.dll7.10.6088.061,44005-Aug- 200823:43x86
Mfc71ita.dll7.10.6088.061,44005-Aug- 200823:43x86
Mfc71jpn.dll7.10.6088.049,15205-Aug- 200823:43x86
Mfc71kor.dll7.10.6088.049,15205-Aug- 200823:43x86
Mfc71u.dll7.10.6088.01,054,20805-Aug- 200823:54x86
Mfc71ud.dll7.10.6088.02,184,70405-Aug- 200823:39x86

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 about the CDatabase class, visit the following Microsoft Web site:
http://msdn.microsoft.com/de-de/library/2dhc1abk.aspx
For more information about the CRecordset class, visit the following Microsoft Web site:
http://msdn.microsoft.com/de-de/library/92bcy0kw.aspx
For more information about Microsoft SQL Server Native Client, visit the following Microsoft Web site:
http://msdn.microsoft.com/en-us/data/aa937733.aspx

Properties

Article ID: 954885 - Last Review: December 18, 2008 - Revision: 1.0
APPLIES TO
  • Microsoft Visual Studio .NET 2003 Service Pack 1
Keywords: 
kbsurveynew kbhotfixserver kbexpertiseadvanced kbqfe KB954885

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com