|
From: Gerd W. <bir...@t-...> - 2006-01-27 06:05:26
|
Hi Mateus, if the JDBC-ODBC bridge is working all right for you then maybe there is no need to care any more. But the bridge usually has some limitations compared to regular JDBC drivers. I know DB2 only on Linux. On Linux you have to run db2jstrt to make the database listen to the JDBC port. Perhaps there is something similar on your mainframe. Gerd Mateus F. Ribeiro wrote: > Hi Rob, > > I've configured SQuirreL successfully to access the > DB2 database in a mainframe. I had to do the > following: > > - Make the database available for use via ODBC (this > was done via DB2 Client Assistent); > - Get a JDBC-ODBC Bridge driver (instead of the > default JDBC driver) for DB2; > - Configure SQuirreL to use DB2 ODBC Bridge; > > It works, at least via JDBC-ODBC. I don't know why it > doesn't work via simple JDBC. > > Thank you, > > Mateus Ribeiro > > --- Rob Manning <Rob...@co...> > wrote: > >> Mateus F. Ribeiro wrote: >> >>> Rob, >>> >>> It didn't work out :-(. I got the same error >> message: >>> Are you really sure that it's possible to connect >> to a >>> database in a mainframe? >>> >>> >> I don't have one to try it out. I'll take your word >> for it ;) >> >>> I'm thinking of trying to access the database via >>> JDBC-ODBC bridge... Do you know where can I get a >>> JDBC-ODBC bridge driver? >>> >>> >> The JDK comes with a JDBC-ODBC bridge according to >> this document: >> >> > http://java.sun.com/j2se/1.4.2/docs/guide/jdbc/getstart/bridge.doc.html#996747 >> It also says you'll need an ODBC driver from the >> vendor of the database >> (IBM in this case) >> >> Rob >> >> >> > ------------------------------------------------------- >> This SF.net email is sponsored by: Splunk Inc. Do >> you grep through log files >> for problems? Stop! Download the new AJAX search >> engine that makes >> searching your log files as easy as surfing the >> web. DOWNLOAD SPLUNK! >> > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 >> _______________________________________________ >> Squirrel-sql-users mailing list >> Squ...@li... >> > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > > ------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. Do you grep through log files > for problems? Stop! Download the new AJAX search engine that makes > searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
