Help connecting to db2 from SQLEXPLORER
Posted on 2009-07-11
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.