Hi
I am working on SQL Server 2000.
I created one linked server from my local db like below
EXEC sp_addlinkedserver
   'test',
   '',
   'MSDASQL',
   NULL,
   NULL,
   'Server=Sr1; Initial Catalog=sales;Integrated Security=SSPI;'
Here Sr1 is other Server Name .My PC and this server is on same network.

When i try to fetch the records its giving below error

OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: ].

My select statement like below

select * from test.Sales.dbo.testTable

i tried like below also but both are giving above error.

DECLARE @OPENQUERY nvarchar(4000), @TSQL nvarchar(4000), @LinkedServer nvarchar(4000)
SET @LinkedServer = 'test'
SET @OPENQUERY = 'SELECT * FROM OPENQUERY('+ @LinkedServer + ','''
SET @TSQL = 'SELECT * FROM Sales.dbo.TestTable'')'
EXEC (@OPENQUERY+@TSQL)

How to call linked server from ASP.Net can i try same thing in my ASPX page?
Pl help me

Hi
Try with SQL Enterprise Manager to link server follow these steps:
Go To Securit--->Linked Servers ---->New Linked Server:

Now on General tab put your sql server name and server type as SQL Server, at Security tab provide your login password for that server. n

Now fire that query, I think it will work.
Avanish