Re: Data Link Properties Question from VB.NET

Walden,

You're correct.  More is needed to use the OLE/DB provider and connect
to the iSeries/AS/400.   I use .ASP and IBMDA400 as I don't have .NET
nor V5R3 yet.    I agree .NET is a better way to go if one can.

Take care,

Dave Odom
Arizona


>>> WaldenL@xxxxxxxxxxxxxxx 2/23/2006 10:57:02 >>>
Thomas,

I don't believe "conn.Open("Provider = IBMDA400; Data Source =
144.162.90.48")" can be a complete connection string. 

IBMDA400 is the IBM OLE/DB provider, that's fine. Data Source is the
address of your 400, again fine. However, what user and password would
you like it to use? You're not supplying one. I suppose it's possible
the provider will use the defaults (if any) from OpsNav, but I've
never
tried. 

Since you're using .NET I would strongly recommend abandoning the
OLE/DB
driver and using the native .NET provider instead. Here's a connection
string I know will work for the .NET provider (it's from code I'm
working on now).

"DataSource=<Youri5>;UserID=<YourUser>;Password=<YourPassword>;Naming=Sy
stem;LibraryList=<LibraryList>;ConnectionTimeout=5;CheckConnectionOnOpen
=true;SortSequence=SharedWeight;SortLanguageID=ENU;DataCompression=true"

-Walden


------------
Walden H Leverich III
Tech Software
(516) 627-3800 x3051
WaldenL@xxxxxxxxxxxxxxx 
http://www.TechSoftInc.com 

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)