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 ?