Linked Server SQL Server

5/04/2012 10:19:00 AM



Thank you so much.
Finnaly I find it :D

Dalam kasus aku, aku mau coba merelasikan database di SQL Server 2000 dengan database SQL Server 2005.
Aku melaksanakan perintah di bawah di query analyzer SQL Server 2000.

Cara membuat linked server SQL Server :
EXEC sp_addlinkedserver 'server_name'
exec sp_addlinkedsrvlogin 'server_name','false',NULL,'user','password'

user : user database yang akan dilinkan
password : password database yang akan dilinkan


Contoh Query :
select * from [server_name_1].db_name_1.dbo.tb_name_1,[server_name_2].db_name_2.dbo.tb_name_2

==========================================================

Jalankan script dibawah pada codingan kita (php).

$result = mssql_query("SET ANSI_NULLS ON") or die(mssql_get_last_message());
$result2 = mssql_query("SET ANSI_WARNINGS ON") or die(mssql_get_last_message());

Source : https://bugs.php.net/bug.php?id=32278


Karena jika tidak maka akan muncul error seperti di bawah.

Warning: mssql_query() [function.mssql-query]: message: Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query. (severity 16) in C:\xampp\htdocs\correspondence3\cobaKoneksiServer.php on line 16
====================================================================
T-SQL function OpenQuery fails to execute on linked servers

 
Use Master
GO
exec sp_addlinkedserver 'ServerName'
GO
exec sp_addlinkedsrvlogin 'ServerName', false, 'sa', 'sa', 'SaPassword'
GO
SELECT * FROM OPENQUERY (ServerName, 'xp_logininfo') 
GO

Source : http://us.generation-nt.com/sp-addlinkedserver-sql-server-2000-problem-help-156800801.html

Share This Story

Tags:

0 komentar