I need as/400 DB2 .net data connector

  • Thread starter Thread starter Scott Emick
  • Start date Start date
S

Scott Emick

Where can I get it? The links on the IBM site all appear to be broken. The
..net provider that comes with DB2 for windows does not allow one to connect
to as/400 either.

Anyone have any ideas?

Thanks,

Scott
 
Scott said:
Where can I get it? The links on the IBM site all appear to be broken. The
.net provider that comes with DB2 for windows does not allow one to connect
to as/400 either.

Anyone have any ideas?
Click to expand...

You could just use the OleDb provider for AS/400, which comes with any
client-access version for as400 (or download it from the website). Then
use the OleDb .NET provider to connect to the as/400.

FB
 
I use the ODBC Driver from Client Access and it seems to work fairly well.
I know, it is a pain in the A**, and I prefer to have SQL server only, but
management for some reason LOVES the AS/400. Probably for the fact that in
the 10 years it has been running here, it has crashed once.

Brad
 
I did am using the OLEDB driver with my .net but it seems slow. A
query that would execute in less than a second on mssql via the .net
provider takes 8-12 seconds to the as/400. If I log into the as/400
and run it, it takes only a few seconds, so it is something slow about
the oledb connection.

Scott
 
The problem is the as400 peeople don't have indexes on anything! Once
I added indexes (which they call logical files?! bizarre) my statements
run fine.
They insist the "files" which I call tables are "keyed" and insist
those are indexes. But they do not show up in operations navigator and
SQL performs poorly so I really dont't believe them. I have MSSQL and
mySQL database and I usually tune each table for the typical queries by
adding indexes.

They can scan the tables fast on the 400 and think that is great but
they are slow as hell externally and all they need is indexes.

Scott
 
Back
Top