Link to home
Start Free TrialLog in
Avatar of superthumper
superthumper

asked on

How do I create an AS400 linked server?

I'm trying to create an AS400 linked server on SQL2005.  I have Microsoft's  DB2OLEDB provider installed.
I know how to create a linked server in SQL 2005, i just need to know what to fill in for the parameters when creating the AS400 linked server.

Product Name: ? (no idea)
Data Source: ? (the AS400 server name?)
Provider String: ? (this one I have no clue....)
Catalog: ? (the database name?)




  There's an old question on EE, but the link in the solution is dead.  Has anyone done this and can help?  Thanks.

Any help on the login portion would be very valuable as well

I'm marking this urgent as my client needs me to move 5 tables yesterday :)
Avatar of chapmandew
chapmandew
Flag of United States of America image

Avatar of superthumper
superthumper

ASKER

I need to do it without installing IBM client tools on the server.
Does the article indicate that you have to do that?  Are you able to setup an ODBC connection to the AS400 machine?
> I need to do it without installing IBM client tools on the server.

That's like saying you need to access a remote SQL Server database without installing the Microsoft tools/drivers for SQL Server.

In order to access _any_ vendor's remote database, you need to install the tool/driver that that vendor provides (or write your own; I guess I could supply some info for you to contact IBM to obtain their LIPI documentation for their database server...)

Given your circumstances, your choice seems limited to an appropriate JDBC driver. The JTOpen JDBC driver might work:

http://jt400.sourceforge.net/
and some info:
http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=/rzatz/51/admin/refjdbcdrv.htm

I have no idea how the JDBC driver might interact with the environment you're working within.

Tom
As I mentioned:  I have Microsoft's  DB2OLEDB provider installed.  I was just looking for the correct parameters to use when creating the linked server.  This is a client machine and THEY don't want to install the client access drivers on the machine.  There are numerous articles out there indicating that people had successfully used the DB2OLEDB provider to connect to an AS400, just not very much documentation on actually setting up the connection.
ASKER CERTIFIED SOLUTION
Avatar of chapmandew
chapmandew
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I never did get the DB2OLEDB provider to connect.  I ended up going a different route using the ibm provider - lame solution but needed to get the job done
superthumper:

Was it SQL 2005 Enterprise (or Developer) edition? Or was it Standard?

I have seen claims from MS engineers that MS DB2OLEDB _can_ work in Standard, but I have never seen one say how nor have I seen a comment from anyone that it did. The comments I saw for MS engineers weren't particularly useful.

I wish I had useful info to pass on. It just doesn't seem to be reasonably available.

Tom
It was Enterprise.

That was the problem I found with that provider - there were no useful instructions.