Other Remote Database Connector (RDC)

[Costas Michael]

When trying to access the server from the browser i'm getting the following error!

java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.

This is my config file:

#Lines starting with '#' are comments.
#Backslash character at the end of line means that the command continues in the next line.

#DriverClass=com.mysql.jdbc.Driver
#JdbcUrl=jdbc:mysql://localhost/test?characterEncoding=utf8

#SQL Server
DriverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver
JdbcUrl=jdbc:sqlserver://MYPC-PC\SQLEXPRESS2008/SoftechDemo
User=sa
Password=sql
ServerPort=17178
#If Debug is true then this file will be reloaded on every query.
#This is useful if you need to modify the queries.
Debug=true

#commands
#sql.create_table=CREATE TABLE animals (\
# id INT NOT NULL AUTO_INCREMENT,\
# name CHAR(30) NOT NULL,\
# image BLOB,\
# PRIMARY KEY (id))
#sql.insert_animal=INSERT INTO animals VALUES (null, ?,?)
#sql.select_animal=SELECT name, image FROM animals WHERE name = ?

firewall and antivirus deactivated.

 

[Erel]

There is no good reason to use RDC instead of jRDC2.

See if it works when you run RDC on the same computer that runs the database server. Maybe the server is not configured to allow remote access or the server firewall blocks the connection.

 

[Costas Michael]

Hi
Firewall is turn off and the database its on the same computer!

 

[Costas Michael]

Hi
Found the problem!
I have change the config file as follows and works!

#Lines starting with '#' are comments.
#Backslash character at the end of line means that the command continues in the next line.

#DriverClass=com.mysql.jdbc.Driver
#JdbcUrl=jdbc:mysql://localhost/test?characterEncoding=utf8

#SQL Server
DriverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver
JdbcUrl=jdbc:jtds:sqlserver://127.0.0.1:1433/SoftechDemo;instance=SQLEXPRESS2008;user=sa;password=sql
User=sa
Password=sql
ServerPort=17178
#If Debug is true then this file will be reloaded on every query.
#This is useful if you need to modify the queries.
Debug=true

#commands
#sql.create_table=CREATE TABLE animals (\
# id INT NOT NULL AUTO_INCREMENT,\
# name CHAR(30) NOT NULL,\
# image BLOB,\
# PRIMARY KEY (id))
#sql.insert_animal=INSERT INTO animals VALUES (null, ?,?)
#sql.select_animal=SELECT name, image FROM animals WHERE name = ?

 

[tigrot]

Probably the other address, good for filesystem, didn't resolve to a IP address.