Re: Testing a JDBC connection

Hello Ruud,

the actual config line is:

<url>jdbc:inetdae7:Station-123.abc.com\SQL2K5:1433?database=studiodb</
url>

station-123 the name of the computer. Station-123.abc.com is the full
domain name. On that workstation there is an SQL Server 2005 (in
compatibility mode) database called studiodb.

The correct id and password are used.

The main application is running off a vpc - it asks for the database -
it is located on Station-123 (which is also running the VPC).

I checked with the link you sent (thanks!)

* jdbc:inetpool:inetdae7:www.inetsoftware.de:1433
* jdbc:inetpool:inetdae7:localHost:1433
* jdbc:inetdae7:210.1.164.19:1433
* jdbc:inetdae7:[2002:d201:a413::d201:a413]:1433
* jdbc:inetpool:inetdae7://MyServer/pipe/sql/query
* jdbc:inetpool:jdbc:inetdae7:www.inetsoftware.de:1433
* jdbc:inetpool:jdbc:inetdae7:localHost:1433
* jdbc:inetpool:jdbc:inetdae7://MyServer/pipe/sql/query

Tried changing the slash, adding the full domain name and not - still
- no connection


Again, using a .udl - it connects using station-123\SQL2K5...

I tried pasting this on the cmd :
jdbc:inetdae7:Station-123.abc.com\SQL2K5:1433?database=studiodb of
course it error our not knowing that command

Trying to telnet to station-123 1433 on a cmd prompt says:

Connecting To station-123...Could not open connection to the host, on
port 1433: Con
nect failed.

How else can I proceed?

Thanks,

Tmuld


.

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: Communicating over the internet
    ... > That way you provide one manner in which to open the database, ... > can keep the connection open and then when someone wants to ... > server as the database and the soap dll connecting with a TCP socket. ... The name of the running program might help. ...
    (microsoft.public.vb.general.discussion)
  • 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)