DB2 and Server Explorer

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

R. J. Dunnill - 01 Feb 2006 19:24 GMT

Is it possible to use DB2 with the Visual Studio 2005 Server Explorer to
execute queries and such?

Thanks, RD

Reply to this Message

Jan DHondt - 03 Feb 2006 15:07 GMT

Yes it is possible , but itmileage may vary on depending on your version of
DB2.

Right now I'm working with V5R2 of DB2. IN the VS2005 server explorer I can
make a new connection through odbc to the DB2 server and library.
Then I can see the tables, views and stored procedures.
and look at the data (tables and vies), but not design.
I do not see the user functions I created with iSeries Navigator.
Maybe this has to do with the fact that it is V5R2 and only ODBC is supported.

It gets worse when you try to use the dataset designer: update, insert
statements are only generating code on the primary key not on other fields

Signature

Jan D''Hondt
Jade bvba
Belgium
Database and .NET development

<Toto, I''ve got a feeling we''re not in Kansas anymore.>

> Is it possible to use DB2 with the Visual Studio 2005 Server Explorer to
> execute queries and such?
>
> Thanks, RD

Reply to this Message

R. J. Dunnill - 03 Feb 2006 19:39 GMT

Supposedly there's a DB2 .NET managed provider available, but I can't find
it anywhere.

Do you (or anyone else) know where it can be downloaded from?

Thanks, RD

> Yes it is possible , but itmileage may vary on depending on your version
> of
[quoted text clipped - 16 lines]
>>
>> Thanks, RD

Reply to this Message

Jan DHondt - 10 Feb 2006 08:44 GMT

I cannot use it myself because no support for V5R2.
Redbook that contains links to download sites (at last pages of the books)
http://www.redbooks.ibm.com/abstracts/sg246440.html?Open

Signature

Jan D''Hondt
Jade bvba
Belgium
Database and .NET development

<Toto, I''ve got a feeling we''re not in Kansas anymore.>

> Supposedly there's a DB2 .NET managed provider available, but I can't find
> it anywhere.
[quoted text clipped - 23 lines]
> >>
> >> Thanks, RD

Reply to this Message

R. J. Dunnill - 22 Feb 2006 00:54 GMT

Mystery solved; the DB2 managed provider for .NET is installed at the time
DB2 itself is installed, but only if the .NET Framework is already present.
The solution in this case was to catalog all the databases, uninstall DB2,
reinstall it, and then add back all the databases. Afterwards, the DB2
Add-In worked fine.

Now, if only I could find a way to have dot-SQL files treated as DB2 files
instead of SQL Server ones.

Regards, RD

>I cannot use it myself because no support for V5R2.
> Redbook that contains links to download sites (at last pages of the books)
[quoted text clipped - 31 lines]
>> >>
>> >> Thanks, RD

Reply to this Message

Rate this thread:

DB2 and Server Explorer

Free Magazines