Connecting to an IBM AS/400 with Visual Basic.NET

[ben_chicago]

I JUST INSTALLED Visual Basic.NET BUT, CANNOT CONNECT TO MY
AS/400
(OS400 5.1). WHEN I TRY TO CONNECT I GET A SERVER EXPLORER MSG:

"UNABLE TO CONNNECT TO DATABASE.
IT IS ONLY POSSIBLE TO CONNECT TO SQL SERVER DESKTOP ENGINE DATABASES
AND MICROSOFT ACCESS DATABASES WTIH THIS VERSION OF VISUAL STUDIO."

-What Version Of Visual Studio do I need?

(The AS/400 runs its own version of DB2)

PROVIDER:
IBM DB2 UDB FOR ISERIES OLE DB PROVIDER

I AM USING "IBM ACCESS FOR WINDOWS" (C/A) VERSION 5 RELEASE 2 SERVICE
LEVEL: SI08894

 

[Jay B. Harlow [MVP - Outlook]]

Ben,
Unfortunately you cannot use the AS/400 from Server Explorer.

You can however access the AS/400 with code only.

The following sites I found useful when using the AS/400 from .NET:

http://www-1.ibm.com/servers/eserver/iseries/access/oledb/index.html

http://www-912.ibm.com/n_dir/nas4ap...6be4003c8957?OpenDocument&Highlight=2,ii13341

The above links are from June 3rd, not sure if there are more current
versions with better support...

Hope this helps
Jay