From the IBM Support site:
http://www-01.ibm.com/support/docview.wss?uid=nas1d7cd7e4509cc894c86257280005c65dc
"The OLE DB provider must be configured to allow inprocess. Under server
Objects -> Linked Servers -> Providers right click on the provider being
used (IBMDASQL, IBMDA400, or IBMDARLA) and select properties. Make sure
"Allow Inprocess" is checked.
If the user is getting "Msg 7399, Level 16, State 1, Line 1" type errors
when attempting to run the sample select statement, this is a problem with
the SQL Server service and the rights the user it is running under has.
There are two things that can affect this. Note that this is all Microsoft
code-related and is as-is at best. Assistance with this should be directed
to Microsoft service and support."
If that does not give you a clue, then could you provide a script of your
linked server, linked server logins, and the udl file? (You can get the
linked server and linked server logins by right clicking on the linked
server definition and choosing Script Linked Server As \ Create.) That
might help someone understand a little better.
You mentioned you do not have the Microsoft OLE DB Driver, but it is freely
downloadable here:
http://blogs.msdn.com/dotnetinterop/archive/2006/01/19/oledb-provider-for-db2.aspx
It is part of the Feature Packs for SQL Server, all freely downloadable at
these locations:
http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en
-- SQL Server 2005
http://www.microsoft.com/downloads/details.aspx?familyid=228de03f-3b5a-428a-923f-58a033d316e1&displaylang=en&tm#QuickInfoContainer -
- SQL Server 2008
Another resource still focused on using the Microsoft OLE DB driver:
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1326266,00.html
Then there are some other links that may hold some interest for you:
http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=65&threadid=47240&enterthread=y
Hope that something helps.
RLF
Post by Cismail via SQLMonster.comHi Russell,
Thank you so much for the reply.
The link was helpful, unfortunately I do not have Microsoft OLE DB Provider
for ODBC Drivers installed on the server.
I created a test.udl file using IBM OLE DB Provider for DB2(driver installed
by DB2 connect) intsead of the above mentioned driver.
There was no option where I could specify the initial cataog(database) in the
udl configuration window.
Result was that I was able to create the linked server using the provider
string generated by the udl file.
I tested the connection(right clicked on linked server that I created and
selected Test Connection) and that was successful, however, when I click on
tables to see the files on the AS400 I get the following
The OLE DB provider "SQL Server" for linked server "(null)" reported an error.
Authentication failed.
Cannot obtain the schema rowset "DBSCHEMA_TABLES" for OLE DB provider "SQL
Server" for linked server "(null)". The provider supports the interface, but
returns a failure code when it is used. (Microsoft SQL Server, Error: 7399)
Any help would really be appreciated....I really need to get this working.
Once again, thanks for any replies!
Post by Russell FieldsThe response in the following thread from 2005 offers a detailed set of
steps.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49610
RLF
[quoted text clipped - 10 lines]
Post by Cismail via SQLMonster.comThank you in advance for any feedback!
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-connectivity/200902/1