[dba-SQLServer] Question on DB2 provider string

1252 sounds suspiciously like the US Windows CodePage number
May indicate collation sequence to use or Ascii to Unicode encoding
method..


Susan Harkins wrote:

>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. 
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada