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]]

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

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/nas4apar.nsf/c79815e083182fec862564c00079d117/7c67fddab257288d86256be4003c8957?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


"ben_chicag o" <ben@neweraopt. com> wrote in message
news:28304e9d.0 401121048.30620 5cc@posting.goo gle.com...[color=blue]
> 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[/color]