Skip to main content

developerWorks >  Information Management  >  Forums  >  DB2 for Linux, UNIX, and Windows  >  developerWorks

connecting to a DB2 instance over the network    Point your RSS reader here for a feed of the latest messages in this thread


     

 
 

My developerWorks
 Welcome, Guest
Sign in or register
Permlink Replies: 18 - Pages: 2 [ Previous | 1 2 ] - Last Post: Nov 5, 2009 11:49 PM Last Post By: NormWong Threads: [ Previous | Next ]
windward

Posts: 15
Registered: Apr 20, 2007 10:49:45 AM
Re: connecting to a DB2 instance over the network
Posted: Nov 05, 2009 06:28:58 PM   in response to: windward in response to: windward's post
Click to report abuse...   Click to reply to this thread Reply
Heres the code that im calling that causes the error

ArrayList vendors = new ArrayList();
ArrayList problems = new ArrayList();
DataTable tbl = DbProviderFactories.GetFactoryClasses();
foreach (DataRow row in tbl.Rows)
{
string providerClass = (string)row[2];
try
{
DbProviderFactories.GetFactory(providerClass); // will throw exception if not configured properly
vendors.Add(CreateProvider((string)row[0], row[1] as string, providerClass));
}
catch (Exception ex)
{
problems.Add(new BadProvider(providerClass, ex));
}
}

NormWong

Posts: 62
Registered: Feb 25, 2006 04:30:23 PM
Re: connecting to a DB2 instance over the network
Posted: Nov 05, 2009 11:14:20 PM   in response to: windward in response to: windward's post
Click to report abuse...   Click to reply to this thread Reply
Did you install the Visual Studio Add-in at the end of the DB2 Client install?

http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.db2.udb.apdv.ms.doc/doc/c0010780.htm

You should be able to manage your connections to DB2 from within Visual Studio.

Norm

NormWong

Posts: 62
Registered: Feb 25, 2006 04:30:23 PM
Re: connecting to a DB2 instance over the network
Posted: Nov 05, 2009 11:16:24 PM   in response to: NormWong in response to: NormWong's post
Click to report abuse...   Click to reply to this thread Reply
This video may help:

http://www.channeldb2.com/video/beginning-db2-net-development
NormWong

Posts: 62
Registered: Feb 25, 2006 04:30:23 PM
Re: connecting to a DB2 instance over the network
Posted: Nov 05, 2009 11:49:22 PM   in response to: windward in response to: windward's post
Click to report abuse...   Click to reply to this thread Reply
At the DB2 ExpressC download page for Windows x64, this is the second download file:

DB2 9.7 Add-Ins for Microsoft Visual Studio
db2exc_vsai_970_WIN_x86.zip (29 M)

 Tags
Help

Use the search field to find all types of content in My developerWorks with that tag.

Use the slider bar to see more or fewer tags.

Popular tags shows the top tags for this particular type of content or application that you're viewing.

My tags shows your tags for this particular type of content or application that you're viewing.

 

MoreLess 


Point your RSS reader here for a feed of the latest messages in all forums