What version of VS supports MS SQL and AS/400 DB2?

[Cesar Meza]

I need to write an application to transfer data from an SQL Server 2000
database and an AS/400 DB2 database. Is required to use the 1.1 framework.
What version of VS will provide the components to do this?

[John Bailo]

Cesar Meza wrote:

I need to write an application to transfer data from an SQL Server 2000
database and an AS/400 DB2 database. Is required to use the 1.1 framework.
What version of VS will provide the components to do this?

I'm doing that right now with VS.2003

There is even a VS plugin for Db2

[Cesar Meza]

Could you tell me where can I get the plug in?
Or can I use the regular ODBC-compliant, or maybe IBM's Client Access?
One last question: is it VS 2003 Professional or Enterprise version?

Thank you very much!
:)

"John Bailo" wrote:

I'm doing that right now with VS.2003

There is even a VS plugin for Db2

[John Bailo]

You can download the plug-in from IBM's site.

The other thing you'll need is the .NET provider for DB2. I think this
is the preferred way for .NET to access any DB2 database -- rather than
ODBC or OleDb.

IBM also has very extensive .pdf documents for using .NET and DB2 and
just DB2 SQL in general.

That comes with the Client Access utilities on the disk.

It's a separate checkbox during setup, but it's there.

You can use the .NET provider without installing the plug-in (which I
did for many months before I found the plug-in).

Cesar Meza wrote:

Could you tell me where can I get the plug in?
Or can I use the regular ODBC-compliant, or maybe IBM's Client Access?
One last question: is it VS 2003 Professional or Enterprise version?

Thank you very much!
:)

"John Bailo" wrote:

I'm doing that right now with VS.2003

There is even a VS plugin for Db2

[Cesar Meza]

Great info!
I really appreciate your help and fast response.
Thanks once again.
:)

"John Bailo" wrote:

You can download the plug-in from IBM's site.

The other thing you'll need is the .NET provider for DB2. I think this
is the preferred way for .NET to access any DB2 database -- rather than
ODBC or OleDb.

IBM also has very extensive .pdf documents for using .NET and DB2 and
just DB2 SQL in general.

That comes with the Client Access utilities on the disk.

It's a separate checkbox during setup, but it's there.

You can use the .NET provider without installing the plug-in (which I
did for many months before I found the plug-in).

Cesar Meza wrote:

Could you tell me where can I get the plug in?
Or can I use the regular ODBC-compliant, or maybe IBM's Client Access?
One last question: is it VS 2003 Professional or Enterprise version?

Thank you very much!
:)

"John Bailo" wrote:

I'm doing that right now with VS.2003

There is even a VS plugin for Db2