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 |
|
chip
Starting Member
14 Posts |
 Posted - 2009-04-13 : 19:01:31
|
| Trying to link an AS400 to a SQL Server 2005 Developer SP2 so that I can access data from both systems. I have loaded the DB2OLEDB and configured it, tested the connection, created packages, and ran a sample query. All that worked. I created a linked Server in SSMS but when I click on the plus sign to open up the Tables (under Linked Servers-->linked server name-->Catalogs, I get the following messages:Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)Cannot fetch a row from OLE DB provider "SQL Server" for linked server "(null)". (Microsoft SQL Server, Error: 7330)Any ideas anyone?Thanks!!Chip DicksonTexas |
|
|
Prateekarya2011
Starting Member
1 Post |
Posted - 2014-06-30 : 04:34:58
|
| Hii chip i am facing same error, did you got any solution to above mentioned error?Kindly rply.. ASAP... |
 |
|
|
|
|
|
Linked Servers Issue (SQL to AS400)