Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
msrnivas
Starting Member
4 Posts |
 Posted - 2004-11-24 : 01:07:20
|
| Hi I am working on SQL Server 2000.I created one linked server from my local db like belowEXEC 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 errorOLE 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 belowselect * from test.Sales.dbo.testTablei 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 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-11-24 : 13:08:15
|
| EXEC sp_addlinkedserver 'test', '', 'MSDASQL',NULL,NULL,'DRIVER={SQL Server};Server=Sr1; Initial Catalog=sales;Integrated Security=SSPI;'==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-11-25 : 01:41:37
|
| hey nigel, how about throwing in some settings on informix 7.3?--------------------keeping it simple... |
|
|
|
|
|
|
|
|
Linked Servers