Topic
No replies
Biedego
Biedego
8 Posts
ACCEPTED ANSWER

Pinned topic IBM OLE DB Provider for DB - Codepage Problem

‏2013-08-26T09:23:39Z |

Hallo

i have connect form MS SQL Server 2008 to DB2 via IBM OLE DB Provider for DB.

Provider String: IBMDADB2.IBMDBCL1;Database=SAMPLE;Hostname=xxx.xxx.xxx.xxx;Protocol=TCPIP;Port=50000;Uid=admin;Pwd=xxxxxxx;

In MS SQL Server I use the select statment and get SQL error.

I think it is a Codepage problem. In Germany i use umlauts "äöüÜÄÖß"

if i change "ä" to "ae" or "ö" to "oe" in my Table i can make the select.

It is posible to write the Codepage in the provider string ?

 

biedego