TestPartner: Unexpected Error: String data, length mismatch
How to resolve TestPartner 6.3.1 throwing the following error message; when trying to create a new Script or any other Test Asset:
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:
* 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: