Re: Trouble connecting with JTDS

From: Dave Brown (dave_at_REMOVETHISFROMADDRESSdbws.net)
Date: 02/28/05 

Date: Mon, 28 Feb 2005 11:44:12 +0000

Hi, the error returned is...

Unable o add connection, cannot establish a connection to
jdbc:jtds:sqlserver://INSP9100/Test;instance=SQLEXPRESS using
net.sourceforge.jtds.jdbc.Driver (Unable to get information from SQL
Server: INSP9100)

I'm wondering if the JTDS is even installed correctly...

TheDave Brown wrote:
> Hi All, I'm a total newbie to Java Databases and am having trouble
> getting a successful connection to an existing SQLEXPRESS database I
> have residing on my machine. In the past I've always been using .NET
> and using the IDE to connect to my datasources but now I am trying to
> learn JAVA, I have installed the JTDS connector to access the SQLEXPRESS
> database but am haing a difficult time getting it working..
>
> My computer name is INSP9100 and the SqlServer instance is called
> SQLEXPRESS, the database is called Test so the URL i'm using is..
>
> jdbc:jtds:sqlserver://INSP9100/Test;instance=SQLEXPRESS
>
> I've also tried
> jdbc:jtds:sqlserver://INSP9100/SQLEXPRESS.Test
>
> but never get any successful result.
> The Driver I'm using is.. net.sourceforge.jtds.jdbc.Driver
>
> and these parameters I am feeding into the Database connection dialog in
> NetBeans IDE 4.0
>
> Any thoughts advice appreciated.
>
> Thanks,
>
>

Relevant Pages

  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... When the first test is run, the results are stored in the central database. ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... much rather write stored procedures and use server side cursors. ... local database, it is vital that I get the information to a central server. ... Once the connection is restored, ...
    (microsoft.public.data.ado)
  • Re: ESQL/C documentation nightmare
    ... documentation about explicit and implicit connections. ... CONNECTION connection statements for new applications of Version 6.0 ... the SQL database statements (such as ...
    (comp.databases.informix)