SQL2008 LINK to Remote SQL Server

EXEC master.dbo.sp_addlinkedserver @server = N’YourLinkName’, @srvproduct=N’MS SQL’, @datasrc=N’YourIP’, @provider = ‘SQLNCLI’

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N’YourLinkName’, @locallogin = NULL , @useself = N’False’, @rmtuser = N’YourUserInRemote’, @rmtpassword = N’YourPasswordInRemote’

How to solve “TLS definition in /lib/libc.so.6 section .tbss mismatches"


Bob Mitchel 2005/12/13 08:45
If you get an error such as this:
/usr/bin/ld: errno: TLS definition in /lib/libc.so.6 section .tbss mismatches
non-TLS reference in […]

What you need to do is this: open the appropriate makefile (i.e. in TKIGES), find the line DEFAULT_INCLUDES, and add -include /usr/include/errno.h to the end.

This applies to gcc-3.3.6, at least.