Windows Server

BSHEIKH · Joined: 12 Oct 2005 Posts: 2

Hi There,

I am trying to fetch tables from AS400 DB2 . through SQL 2000 linked server.

following is the Provider string

" PRODUCT NAME : Microsoft OLE DB Provider for DB2
DATASOURCE : S101

NetLib=TCPIP;NetAddr=10.10.10.1;NetPort=446;Initial Catalog=S101;Data Source=S101;HostCCSID=1252;Package Collection=QGPL;Default Schema=RMSPROD;UserID =bs;Password=yn

CATALOG : S101

"
here is my scenario.

running Win2k, SP4, SQL2000 SP2, Host Intigration server 2000, SP2

created linked server, but every time got errors # 7303, 7339

" Error 7399 : OLEDB PROVIDER 'DB2OLEDB ' REPORTED AN ERRROR.
The provider reported an unexpected catastrophic failure.

OLEDB Error Trace [ole/db provider 'DB2OLEDB' IDBinitialize :: Initialize returned 0X8000ffff: Provider reported an unexpected catastrophic failure.

I made an other server with same configuration and updates , there i got error

" Error 7399: OLEDB provider 'UNKNOWN' reported an error . The provider reported an unexpected catasstrophic failure.

sqlDumpExceptionHandler: Process 53 generated fatal exception c0000005
EXCEPTION_ACCES_VIOLATION: SQL Server is terminating this process.

please help me as this is time critical .

Neil Pike · Guest

Does the connection work ok outside of SQL? i.e. have you tested an OLEDB
connection using the supplied HIS tools?

I'm tempted to suggest upgrading to MDAC 2.7.

If the connection works ok outside of SQL, but fails from inside, then turn on
trace flags 7300 and 3604. That will return OLEDB messages back to your SQL
session and you may see a more meaningful message.

[quote]I am trying to fetch tables from AS400 DB2 . through SQL 2000 linked
server.

following is the Provider string

" PRODUCT NAME : Microsoft OLE DB Provider for DB2
DATASOURCE : S101

NetLib=TCPIP;NetAddr=10.10.10.1;NetPort=446;Initial Catalog=S101;Data
Source=S101;HostCCSID=1252;Package Collection=QGPL;Default
Schema=RMSPROD;UserID =bs;Password=yn
[/quote]
Neil Pike. Protech Computing Ltd
Microsoft SNA/HIS MVP

BSHEIKH · Joined: 12 Oct 2005 Posts: 2

Hi There,

i have enabled the traceon for 7300 and 3604
mdac 2.8 is installed.

how to check from HIS tools u mean OLEDB data Sources .

any further suggestions.

i have screen shots of that errors as well as config screen
but we cant upload here

regards
bilal

Neil Pike · Guest

Bilal,

The 7300 traceflag gives you no more information within your ISQLW session
then?

Yes, on HIS tools I mean the OLEDB data sources. I'm using HIS2004 on
everything now that has a very nice data config wizard and data access tool -
better than HIS2000, but I guess you're not in an immediateb position to
upgrade? (There are plenty of fixes and new features in HIS2004, so it is
possible your problem would go away with that - no guarantees though).

The main problem is that newsgroups aren't very good time-wise for getting to
the bottom of a problem like this quickly - plus I don't often have access to
an AS/400 to repro such issues.

Your best bet to get it resolved quickly will be to open a fault case with MS
PSS and they'll stay on the phone with you, if needed, running through
everything step by step.

	Windows Server Forum Index -> Host Integration Server	All times are GMT
Page 1 of 1