Is any Familiar with Connecting a .Net App to a AS400 database? I have installed the latest version client access but and can't create the OLE DB connection.
Any Help would be greatly appreciated.

Hi Nix,

I had a project a few years ago working with an AS400 db....and I had all sorts of problems with the data connection.

There is a AS400 ODBC connection for windows, but it does not work.

I ended up using a Microsoft program called Host Intergration Server (or service can remember) and this has the connectivity to as400. Not sure about the difference with ASP.net but in theory should be no different as you are still in a windows environment.

Regards
Vince

DMX Talkzone Manager

Visit my home: www.chez-vince.com
(Now completely CSS based and bye bye to all tables!)

VBScript | ASP | HTML | CSS | SQL | Oracle | Hosting

I have gotten the ODBC drivers to work, but the way they access the AS400 has big slow downs. With Host Transformation server were you able to increase the speed?

To give you an example: If I have a page that goes through a table in the database, the table has over 80,000 records in it, It's extremely fast on a sql server, now if I set up the same thing on the as400 the same query takes upwards of 30 to 40 seconds.