Susan Harkins
ssharkins at setel.com
Mon May 28 11:56:13 CDT 2007
EXEC sp_addlinkedserver @server='DB2', @srvproduct='Microsoft OLE DB Provider for DB2', @catalog='DB2', @provider='DB2OLEDB', @provstr='Initial Catalog=databasename; Data Source=DB2; HostCCSID=1252; Network Address=XYZ; Network Port=50000; Package Collection=admin; Default Schema=admin;' ======I don't know a thing about DB2 -- can someone tell me if the HostCCSID value is a literal value or a variable, which in this case just happens to be 1252? Susan H.