Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

AS400 Database Connection...

Status
Not open for further replies.

mitch77

Programmer
Nov 16, 2000
42
0
0
PT
Hi,
How can i connect to an AS400 database using ASP?

Thanks Mitch
 
If you have the latest version of IBM's ClientAccess (usualy free with your OS/400 license), it should give you an ADO driver to connect. Otherwise, look at HiT Software's driver.

Once you have a driver, you set up an ODBC DSN like any other ADO datasource. Be aware that the SQL for use with DB2/400 is a bit different -- you have to specifiy a library as well as tables and columns.

Chip H.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top