Linked Server Problem

• rspadar

  SSC Veteran

  Points: 227

  More actions

  January 10, 2011 at 4:42 am

  #233109

  Hi,

  I've an SQL SERVER 2008R2 on Windows Server 2008 R2.

  I've installed iSeries Client Access 6.1 with last patch.

  When i try to connect to AS400 from a linked server the server:

  1) SSMS hung (i attend many minutes)

  2) have an error:

  Messaggio 7399, livello 16, stato 1, riga 1

  Il provider OLE DB "MSDASQL" per il server collegato "AS400" ha segnalato un errore. Il provider ha segnalato un errore irreversibile imprevisto.

  Messaggio 7330, livello 16, stato 2, riga 1

  Impossibile recuperare una riga dal provider OLE DB "MSDASQL" per il server collegato "AS400".

  Can you help me?

  Raf

• Lowell

  SSC Guru

  Points: 323547

  More actions

  January 10, 2011 at 6:04 am

  #1271340

  Msg 7399, Level 16, State 1, Line 1

  The OLE DB provider "MSDASQL" for linked server "AS400" reported an error. The provider reported an unexpected fatal error.

  Message 7330, Level 16, State 2, Line 1

  Unable to retrieve a row from OLE DB provider "MSDASQL" for linked server "AS400".

  was the linked server working before? If this is a new install, I wonder if it's the classic issue where SQL 64 bit can't use 32 bit drivers for linked servers....you might need to look for a 64 bit AS400 driver?

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

• rspadar

  SSC Veteran

  Points: 227

  More actions

  January 10, 2011 at 8:10 am

  #1271420

  was the linked server working before? If this is a new install, I wonder if it's the classic issue where SQL 64 bit can't use 32 bit drivers for linked servers....you might need to look for a 64 bit AS400 driver?

  From server with SQL 2000 SP4 or SQL 2008 work fine both 32bit.

  The new Server 64 bit, and i've try to use driver 64 and 32 bit but same problem.

  Raffaele