Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

Database News

Posted May 6, 2004

Temporarily Using an Instance Other Than the Default DB2 Instance in Microsoft� Visual Studio .NET

By DatabaseJournal.com Staff

[From dbazine.com ]

You are a developer hooked on the IBM® DB2® Universal Database™ (DB2 UDB) system. You love the integration of DB2 UDB with .NET in the Microsoft Visual Studio .NET environment. You like to play around with code and databases so you have an instance that you use for development, and an instance that you use for experimentation. You have one problem: the IBM Explorer in Visual Studio .NET only shows the default instance (typically DB2) when it starts up on a typical workstation.

In this article, I'll show you the simplest, yet most often overlooked, way to quickly work with a test database that resides in another instance when using the Visual Studio .NET tool set to develop DB2 UDB applications. This method gets a whole lot easier in the up-and-coming Stinger release in which cataloging remote databases (even ones that reside in remote instances) can be performed within the tooling. For now, the only other way to accomplish what I am going to show you is by cataloging the database and performing an instance attach. This requires working with the database catalogs, and that is just something that we don't feel like learning, right?

The article continues at http://www.dbazine.com/zikopoulos10.shtml

Database News Archives

Latest Forum Threads
Database News Forum
Topic By Replies Updated
Efficient SQL Server Indexing by Design lcole 0 April 30th, 12:38 PM
Mine Oracle Database, SQL Server and Other Databases with Monarch Data Pump Pro V10.5 lcole 0 April 30th, 12:37 PM
Oracle Database and Oracle Fusion Middleware for Private Social Network Application lcole 0 April 30th, 12:31 PM
Oracle Database Maintains a Stronghold in the DBMS Market lcole 0 April 30th, 12:30 PM