TestPartner: Unexpected Error: String data, length mismatch

TestPartner: Unexpected Error: String data, length mismatch

Problem:

How to resolve TestPartner 6.3.1 throwing the following error message; when trying to create a new Script or any other Test Asset:

Resolution:

This error message has previously been reported by customer's running TestPartner 6.3.1 on Windows 7(x64); while using the 'SQL Server Native Client 10.0' driver to connect to SQL Server 2005.

The solution is to recreate the DSN and instead use the 'SQL Native Client' driver; which can be downloaded from Microsoft at the following location, if it does not appear in the 'Create New Data Source' dialog:

> http://www.microsoft.com/en-us/download/details.aspx?id=11988

* Note: If TestPartner 6.3.1 is running on a 64 bit OS - you must install 'sqlncli_x64.msi'.

Once the Driver installation is complete; configure a new 32 bit TestPartner DSN (C:\Windows\SysWOW64\odbcad32.exe), choosing the 'SQL Native Client' Driver as shown in the image below:


The final steps are to reconfigure TestPartner to use this DSN to connect to the Database; by clicking 'Configure' on the login dialog, and selecting the new DSN in the 'Select Data Source' drop down list:



DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Version history
Revision #:
1 of 1
Last update:
‎2013-04-18 06:54
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.