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? 5 3102
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
Serge,
Thanks for the great info.
Doug
On Mar 9, 6:03 am, Serge Rielau <srie...@ca.ibm .comwrote:
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
On 8 Mar 2007 12:54:37 -0800, "dougdoc"
<do**********@u nitedtrustgroup .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?fo rum=467&cat=19> .
HTH,
B.
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
On Mar 8, 1:54 pm, "dougdoc" <doug.dock...@u nitedtrustgroup .com>
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Martin Bless |
last post by:
The good news:
Along with Python-2.4 comes really good news to Windows users. Yes,
you now CAN build extension modules yourself using the SAME C++
compiler and linker Python is built with itself. Everything you need
is available at no costs (except download hassle and installation
time). Once your system is set up properly its just a matter of
running 'python setup.py build'. No longer waiting for someone else to
build binaries and a...
|
by: Tom Lee |
last post by:
Hi,
I'm new to .NET 2003 compiler. When I tried to compile my
program using DEBUG mode, I got the following errors in the
C:\Program Files\Microsoft Visual Studio .NET 2003\Vc7
\include\xdebug file as folows. I need help to resolve
them ASAP:
cl /c /nologo /MDd /W3 /Od /GR /GM /Zi /GX /D "_DEBUG" /D "
WIN32" /D "_W
INDOWS" /D "_WINDLL" /D "_AFXDLL" /D "_MBCS" /D "_USRDLL" /
|
by: Craig Skrabacz |
last post by:
I originally had VB.Net standard installed on my
computer. I have subsequently installed Visual
Studio .Net 2002 on my computer. I have not uninstalled
VB.Net.
When I look in my Add/Remove programs - there are two
entries - one for VB.Net and the other for Visual
Studio .Net. Both entries are over 1 GB in size.
My question is whether the VB.Net is redundant information
|
by: Greg B |
last post by:
Created a simple Win32 application (using Visual Studio wizard)...
Am using Visual Studio (Enterprise Edition) 6.0, as well as Service
Pack 5.
At the start of 'WinMain' function, added the following two lines:
char* ptr = NULL;
*ptr = 'b';
Built the crashTestApp.exe in both Release and Debug configurations.
|
by: Microsoft |
last post by:
Hi,
I have Visual Basic .net 2003 (Standard Edition) & SQL Server 2000 Developer Edition. When trying to create a connection in the server explorer from the .net IDE I get a number of problems;
a.. Under the "Connection" tab, under "1. Select or enter a server name:" when I either select the drop down box or click the refresh button I get an error dialog saying "Error enumerating data servers. Enumerator reports Unspecified error'". The...
| |
by: michael.lang |
last post by:
I am using PostBuild events in a C# project to run some tasks, but only
when in release configuration mode. The build events run perfectly as
expected when run. The problem comes when I save the project, close
VS, and reopen VS and the project.
When I build again, i get a post-build event error. So I open the
event to look at it. Guess what, it is not the post-build event i
saved. Instead all the carriage returns are replaced with...
|
by: JFMarsella |
last post by:
Hello,
I am new to Visual Studio and VB and am stumbling along but have hit a roadblock. I am attempting to build a very basic database application that needs to 1) allow input & manipulation of data into a table via a small interface and 2) output data to a report and allow for printing. My goal is to help with uniform ordering for the kitchen staff at the restaurant at which I work.
Thusfar I have created Uniform_Order_App.vb, which...
|
by: marathoner |
last post by:
I am currently migrating my Visual C++ 6.0 applications to Visual Studio
2005. I am getting compiler errors involving the VS2005's platform SDK.
When I removed directory references to that SDK, and started using the
Microsoft Platform SDK for XP SP2, the errors disappeared, but I am now
getting numerous warnings (macro redefinitions) as follows:
StdAfx.cpp
WINVER not defined. Defaulting to 0x0502 (Windows Server 2003)
C:\Program...
|
by: jwwicks |
last post by:
Introduction
This tutorial describes how to use Visual Studio to create a new C++ program, compile/run a program, resume work on an existing program and debug a program. It is aimed at the beginning CIS student who is struggling to get their programs working. I work in the computer lab at the college I'm attending and I see many students who don't know how to use the IDE for best results.
Visual Studio automatically creates a number of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |