[dba-SQLServer] Question on DB2 provider string

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. 




More information about the dba-SQLServer mailing list