I'm having problems displaying Thai characters from my Linked Server.

I'm using iSeries Access for Windows ODBC data source and MSDASQL provider

I'm getting garbage characters. CCSID from AS400 is 838, but...

LutzM (8/25/2011)

---

Please have a look at the CroosTab article referenced in my signature.

You'll need to add a row number per hostname in order to assign the address to either MacA...

How about if I have this table?

From this layout:

Hostname MACAddress

Computer1 MACAddress1

Computer1 MACAddress2

Computer2 MACAddress3

Computer3 MACAddress4

Computer4 MACAddress5

Computer4 MACAddress6

To this layout:

Hostname MACAddressA MACAddressB

Computer1 MACAddress1 MACAddress2

Computer2 MACAddress3 NULL

Computer3 MACAddress4 NULL

Computer4 MACAddress5 MACAddress6

Any...