Help connecting to db2 from SQLEXPLORER

I'm trying to find an interactive admin/development environment for db2 on Windows.  I downloaded SQL Explorer, but cannot seen to connect to db2 on my home server.  My db2 instace is named as the default 'DB2COPY1' (but just shows up as DB2 in Control Center).  I have tried setting up a new SQL Explorer connection to my DB@ server as:

SQL Explorer Default driver:     'JDBC ODBC Bridge'
URL:     jdbc:odbc://localhost/db2copy1 (also tried just db2)
user:     mitch (A W2k3 domain user that I use to log into the server and I seem to gain full access to db2 without further authentication)

Keep getting error:

"Could not connect to your database alias; the excat message was:

Cannot connect to MyLocalConnectionProfile/mitch.  Check your URL [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Do you want to try again?"

I'd really like to try this app out.  Bouncing back and forth from tab to tab in IBM's tools is slowing me way down.  I'm used to typing ad hoc queries and getting imidiate feedback in the same window.  Also would be nice to be able to explore schema/table structures and names without switcing windows too.
SQLMitchAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kent OlsenDBACommented:
Hi Mitch,

I've never used SQLEXPLORER, but it certainly looks like a fine tool.

The driver/URL looks suspicious.  Try this one:

  jdbc:db2://localhost/db2copy1



Good Luck,
Kent
0
Brian ChanDBACommented:
It is certainly you have problem with driver. I have used two different SQL clients and so far I always have to use the IBM's java jdbc driver. Do you have access to IBM's download website? For drivers and client, I think you just need to registered an IBM ID and you will be able to download it.

The connection string should be then:

jdbc:db2://[hostname]:[port#]/[database name]

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
SQLMitchAuthor Commented:
Indeed I did have to download the jdbc driver for DB2 from IBM's website.  Then had to configure SQLEXPLORER to use this driver (the only driver that comes preconfigured with the download is the ODBC-JDBC bridge, which aparently requires an ODBC DSN set up on local machine in order to connect).  Once the db2 jdbc driver was instaleed and configured on SQLEXPLORER, the connection strings you recomended worked perfectly, thanks.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB2

From novice to tech pro — start learning today.