|
From: Robert M. <rob...@gm...> - 2011-05-14 01:54:36
|
Srinivas, By all means, choose the Oracle Thin Driver. The ODBC-JDBC bridge which is implemented out-of-the-box in Java has many limitations that will adversely affect your user experience with SQuirreL. Also, for troubleshooting purposes, it would be great if you were able to verify your SQuirreL alias/driver configuration without using the VPN first (firewalls sometimes cause mysterious trouble with network services). Rob On Fri, May 13, 2011 at 1:30 PM, Andreas Oswald <cpt...@gm...>wrote: > Hi Srinivas, > > have you tried if the ODBC alias works when being on VPN? You can test the > ODBC link from the control panel. What kind of driver or client do you use > for the ODBC connection? > > Maybe you should rather use a JDBC driver e.g the "Oracle Thin Driver" > available from the OTN download > > For Oracle 10.2 you can use > http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-10201-088211.html > For Oracle 11.2 you can use > http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html > > You can then copy the JDBC jar file e.g. ojdbc6.jar to your SQuirreL lib > directory. You can then setup an alias with a jdbc url of the following > format > > jdbc:oracle:thin:@servername:portnumber of the listener:servicename > > so if you have a Oracle service called "myservice" on a server called > "myserver" with a standard listener configuration then the JDBC URL would be > > jdbc:oracle:thin:@myserver:1521:myservice > > Hope that helps. If you have further questions do not hesitate to ask. > > Take care > > Andreas > > Am 13.05.2011 15:41, schrieb Srinivas Paruchuri: > > Hi , > Please find my response > > On Fri, May 13, 2011 at 9:28 AM, CptBlaubaer <cpt...@gm...>wrote: > >> Hi Srini, >> >> do you have the Oracle driver properly installed in SQuirreL? > > Yes I do have installed and working on SQuirrel, when i am on the network. > >> Can you >> ping the Oracle Server from your machine? > > Yes > >> What JDBC URL and driver do >> you use? > > Here are my driver details: > Drive Name:JDBC ODBC Bridge > Example URL:jdbc:odbc:<alias> > Website URL: > http://java.sun.com/j2se/1.3/docs/guide/jdbc/getstart/bridge.doc.html > > Class Name:sun.jdbc.odbc.JdbcOdbcDriver > > >> Do you have a local oracle client installation and a >> tns-entry for your server? > > No > >> Have you tried tnsping with the tns-name of >> the installation? > > No > >> Can you connect to the server with sqlplus? >> I dont have SQLPlus >> You see there are quite a few questions that need to be answered. If >> you provide some further information maybe one can help you. >> >> Take care >> >> Andreas >> >> >> 2011/5/13 Srinivas Paruchuri <par...@gm...>: >> > Hi, >> > I am trying to connect to oracle DB through Squirrel on VPN. >> > >> > But its failing with network error. Can you please let me know if there >> is >> > any method to resolve that. >> > >> > -- >> > Srini >> > >> > >> ------------------------------------------------------------------------------ >> > Achieve unprecedented app performance and reliability >> > What every C/C++ and Fortran developer should know. >> > Learn how Intel has extended the reach of its next-generation tools >> > to help boost performance applications - inlcuding clusters. >> > http://p.sf.net/sfu/intel-dev2devmay >> > _______________________________________________ >> > Squirrel-sql-users mailing list >> > Squ...@li... >> > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >> > >> > >> > > > > -- > Srinivas Paruchuri > > > > > ------------------------------------------------------------------------------ > Achieve unprecedented app performance and reliability > What every C/C++ and Fortran developer should know. > Learn how Intel has extended the reach of its next-generation tools > to help boost performance applications - inlcuding clusters. > http://p.sf.net/sfu/intel-dev2devmay > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > |
