Re: [Squirrel-sql-users] "Unable to create connection" to an Oracle Lite DB with JDBC

[Robert M. <rob...@gm...>]

On 8/17/06, Robert Manning <rob...@gm...> wrote:
> On 8/8/06, GONZE Michel-Henri (TREN-EXT)
> <Mic...@ex...> wrote:
<snip>
> > In the Aliases Window (New), I've :
> > - entered for Name: CAPE-DBs_LITEv302_0725
> > - selected for Driver: Oracle Thin Driver
> > - and modifed the proposed URL "jdbc:oracle:thin:@<server>[:<1521>]:<database_name>" with:
> > "jdbc:oracle:thin:@localhost:1521:D:\CAPE2006_APP-DB\DBs\LITEv302_0725\lite\capedb.odb"
> >
> > When I click on Test (no user name or password needed), I get a message "CAPE-DBs_LITEv302_0725: Unable to create connection. Check your URL."
> >
>
> Hello,
>
> You are using the "thin" driver form of the jdbc URL which for the Oracle lite
> jdbc driver doesn't appear to be correct. When you installed Oracle lite, I
> am assuming it asked you for a DSN (data source name) to install an ODBC
> data source that you could use to reference your database.  For example,
> assuming that the data source name that you chose was "capedb", then the
> following jdbc url is what I would expect it to work:
>
> jdbc:polite:capedb
>
>
> Rob

Also, here is a link to a page that has a nice description of various
ways to connect
to an Oracle Lite database:

http://gyan.fragnel.ac.in/docs/oracle-lite/B13811/html/jdgjdbc.htm

Rob