TestStand database logging problem: only the first character is put in the table.

[JunCan]

Scott Richardson,

I can not install the new SQL Native Client SQL Provider. It asked  a newer service pack (my system is win2000 sp4 already).

I have a connection string in TestStand like this: "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=pubs;Data Source=BDC2".

Right now I do not have other computers to test. But I have two win2000 computers having this problem still. I may try another XP or win2000 computer later when I have a chance.

Jaso

[Scott_Richardson]

Jaso -
I would like to contact you directly to try to speed up our communication. Can you contact our support and give them your contact information and ask them to send it to me in the TestStand group. I do not like to ask customers to post their contact information directly to the forums.

[Scott_Richardson]

Turns out that there is a known Microsoft bug where applications will be unable to read character data when the language of the server and the client are different. In this case they had a Chinese client and an English server. The Microsoft bug report describes how characters appear as "????" instead of the actual strings when read, http://support.microsoft.com/default.aspx?scid=kb;en-us;331999 . This was the result of an improper translation of single byte characters to two byte characters. It appears that the reverse can also happen in that the data sent to the server is translated from single byte to two byte characters but the extra bytes are zero, thus NULL terminated.

The suggested workaround is to add the bold text shown below to the connection string which tells the SQL OLEDB Provider to not autotranslate character data:

Provider=SQLOLEDB.1;Persist Security Info=False;Auto Translate=False

This fixed the reported problem.

[JohnnyR]

Scott,

Found this forum while searching for a solution to the same error message only I'm using Windows XP. Funny thing, database logging has been working fine for the past (4) months or so and this happened with no apparent change to any windows regional settings. I have not tried your work around as of yet. I will keep you posted.

John

[Scott_Richardson]

John -
I would be interested in what you find. I would be interested in knowing if any updates from Microsoft were installed and what the regional settings for the local and server system.