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...edb/index.html

http://www-912.ibm.com/n_dir/nas4apa...ight=2,ii13341

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

Hope this helps
Jay
"ben_chicago" <be*@neweraopt.com> wrote in message
news:28**************************@posting.google.c om...

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