Web Development

General discussion

SQL Server Linked Server to AS/400 DB2

I'm setting up a SQL Server 2000 linked server to communicate with a DB2 Database on a AS/400 Server. I'm using the Microsoft OLE DB Provider for DB2. There are options for provider string and catalog that I am not sure what are valid options. Can someone give me a working example of the fields "Product Name", "Data Source", "Provider String", and "Catalog"?

All Comments

SQL Server Linked Server to AS/400 DB2

If you defined DSN to be able to access AS400, you will need to specify in the connection string only Data Source, which must name your DSN. In this case neither catalog, neither prov. string and other parms are required (all will be taken from DSN).

SQL Server Linked Server to AS/400 DB2

Better than using DSN use provider string. If you use Client access express driver to connect to AS/400 then the connection string in VB would be like this.

public Con400 as new ADODB.ConnectionCon400.open "Provider=IBMDA400;Data Source=AS400ServerNameAsinOperationNavigator;"and that is it. if you want to prompt for AS/400 security login screen everytime use Con400.BeginTrans property.

To get extended connection string data follow the below procedure.

1) Use the above string to connect.2) Execute the code in step by step in VB.3) After executing the connection string's Open statement, go to immediate window and print the connection string like this ?Con400.ConnectionStringThis will give the full connection string parameters. Then you can copy that string to the actual connection string in your code and change the parameters like Timeout, Userid, Password, etc etc.

Start or search

Create a new discussion

If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

Post type

Subject title

Topic Tags

Select up to 3 tags (1 tag required)

Cloud

Piracy

Security

Apple

Microsoft

IT Employment

Google

Open Source

Mobility

Social Enterprise

Community

Smartphones

Operating Systems

Windows

Mac

Malware

Tablets

Networking

Browser

Hardware

Software

Web Developerment

Linux

Off Topic

Message Body

Track this discussion and email me when there are updates

Please note: Do not post advertisements, offensive material, profanity, or personal attacks. Please remember to be considerate of other members. If you're new to the TechRepublic Forums, please read our TechRepublic Forums FAQ. All submitted content is subject to our Terms Of Use.