RE: Accessing the AS/400 thru .NET

["Walden H. Leverich III" <WaldenL@xxxxxxxxxxxxxxx>]

Sure. Why are you using the OLE/DB driver for ODBC to then use ODBC to talk
to the iSeries? Either use the OLE/DB driver for iSeries (might not be
installed), or use the iSeries ODBC driver as an ODBC driver. Don't cross
the two. You seem to be overly focused on the ODBC admin, I'd submit that
you should use the native OLEDB drivers for iSeries and forget about ODBC
completely.

You could also try the native .NET drivers IBM has for the iSeries, but they
are in beta, so buyer beware.

Finally, make sure you're running the latest patches for CA Express. They
(IBM) "fixed" some things w/regard to .NET.

Or, you could read my article on accessing iSeries data w/.NET in the most
recent iSeries Experts Journal. <G> 

-Walden

------------
Walden H Leverich III
President & CEO
Tech Software
(516) 627-3800 x11
(208) 692-3308 eFax
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com 

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)
 
-----Original Message-----
From: Angela Wawrzaszek [mailto:awawrzaszek@xxxxxxxxxxxxxxx] 
Sent: Wednesday, January 21, 2004 2:21 PM
To: Midrange Mail List
Subject: Accessing the AS/400 thru .NET

     I have a user trying to access a file on our AS400 thru Microsoft
.NET    When connecting they enter the name of an ODBC  DSN,  and select
the connection type as OLE DB provider for ODBC drivers.      All the
tables from this library the ODBC goes over  show up.   However when she
goes to select the file and drag it onto the form the following error
message appears:    You cannot use an OLE DB provider for ODBC drivers.
Which confused me since this is a valid selection.   We tried
downloading the ODBC .Net driver however we cannot get that to show as a
valid driver name in the ODBC administration.  We have *ddm running on
our server.  
 
Has anyone connected to the as/400 thru .Net?   Can you steer me in the
right direction
 
Thanks!!!
 
Angela Wawrzaszek 
Programmer/Analyst 
Nucor Steel Auburn 
wawrzaszek@xxxxxxxxxxxxxxx 
(315) 258-4205 
 
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.