MS Visual Studio & DB2 UDB for Windows

[dougdoc]

We are exploring doing some development with MS Visual Studio 2005 to
access our DB2 UDB for Windows databases. Are there any other options
to accessing DB2 with Visual Studio that may be more robust than ODBC?

[Serge Rielau]

dougdoc wrote:

We are exploring doing some development with MS Visual Studio 2005 to
access our DB2 UDB for Windows databases. Are there any other options
to accessing DB2 with Visual Studio that may be more robust than ODBC?

Comment from backstage:
"One should never use ODBC driver or the OLE DB provider when building
DB2 applications using .NET technologies. IBM provides an IBM-developed
(not third party or Microsoft) real .NET Data Provider with support for
both .NET Framework 1.1 and 2.0. IBM also provides, at no charge, a set
of add-ins for the Visual Studio .NET 2003 and Visual Studio 2005 that
make building applications for DB2 (on any platform) a very productive
experience. It takes literally just minutes to become fully familiar
with these tools and be productive at creating both application front
ends and database back-end objects (tables, views, indexes etc. ) and
code (stored procedures functions etc.)."

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

[dougdoc]

Serge,

Thanks for the great info.

Doug

On Mar 9, 6:03 am, Serge Rielau <[e-mail]:

dougdoc wrote:

We are exploring doing some development with MS Visual Studio 2005 to
access our DB2 UDB for Windows databases. Are there any other options
to accessing DB2 with Visual Studio that may be more robust than ODBC?

Comment from backstage:
"One should never use ODBC driver or the OLE DB provider when building
DB2 applications using .NET technologies. IBM provides an IBM-developed
(not third party or Microsoft) real .NET Data Provider with support for
both .NET Framework 1.1 and 2.0. IBM also provides, at no charge, a set
of add-ins for the Visual Studio .NET 2003 and Visual Studio 2005 that
make building applications for DB2 (on any platform) a very productive
experience. It takes literally just minutes to become fully familiar
with these tools and be productive at creating both application front
ends and database back-end objects (tables, views, indexes etc. ) and
code (stored procedures functions etc.)."

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

[Brian Tkatch]

On 8 Mar 2007 12:54:37 -0800, "dougdoc"
<do**********@unitedtrustgroup.comwrote:

>We are exploring doing some development with MS Visual Studio 2005 to
access our DB2 UDB for Windows databases. Are there any other options
to accessing DB2 with Visual Studio that may be more robust than ODBC?

<URL:http://www-128.ibm.com/developerworks/db2/zones/vstudio/>. For
support,
<URL:http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=467&cat=19>.

HTH,
B.

[Michael Hoffmann]

dougdoc wrote:

Serge,

Thanks for the great info.

Doug

Hello Doug,

I'll just jump in with a few words: I am doing my master's thesis with a
..NET/DB2 project.

I started with VS2003/.NET1.1/DB2V8 and have recently moved to
VS2005/.NET2.0/DB2V9. For me the combo is made in heaven. The
environment is a joy to work with, very straight-forward, with excellent
debugging support all the way down to stored procedures on DB2 from
right within VS.

While I started with ODBC and OLE DB, because there's so much sample
code around it, I ended up dumping it pretty quickly. IBM provided
plenty of sample code for their provider which I got adapted quickly. I
found my code looks "cleaner" for it.

That's purely subjective, of course.

Just my 2 cents
Mike Hoffmann

[vasantha]

On Mar 8, 1:54 pm, "dougdoc" <[e-mail]>
wrote:

We are exploring doing some development with MS Visual Studio 2005 to
access our DB2 UDB for Windows databases. Are there any other options
to accessing DB2 with Visual Studio that may be more robust than ODBC?

Hi Doug,

Like Serge and Brian have pointed out in this email thread, DB2
provides an Add-in for Visual Studio 2005 which will allow you to
easily access several flavors of DB2 databases through an ADO.NET
provider.
The product is named "IBM Database Add-ins for Visual Studio 2005".
Check out developerWorks zone at:
<URL:http://www-128.ibm.com/developerworks/db2/zones/vstudio/>.
For support issues, you can use the support forum:
<URL:http://www-128.ibm.com/developerwork.../dw_forum.jsp?
forum=467&c...>.

As Mike Hoffman has mentioned below, the product is very straight-
forward to use so you can jump right in. You can also get a good
overview of the product and more details on specific areas from
several articles on our product published on developerWorks and here
are some links to the same...

http://www-128.ibm.com/developerwork...0605jayakumar/
http://www-128.ibm.com/developerwork...m-0512surange/
http://www-128.ibm.com/developerwork...-0512surange2/
http://www-128.ibm.com/developerwork...0611farahbod2/

I'm a developer leading several subprojects in this product and can
help you with any further questions that you may have(email:
va******@us.ibm.com).

Hope this helps.

Vasantha