Can't create Datasource - Timed Out

Report · Sep 23, 2009

Hi,

i want to create a datasource, but it wouldn't work correctly...

In the past i create datasources without any problems... now i install Windows7 and it will not work...

The Error:

Connection verification failed for data source: mySOurce
java.sql.SQLException: Timed out trying to establish connection
The root cause was that: java.sql.SQLException: Timed out trying to establish connection

I turned off my firewall - without any other result.

Any ideas ?

greetings from germany, nico

Report · Sep 23, 2009

Can you reach the DB from your CF server machine at all, eg: ping it, connect to it via some other client software?

--

Adam

Report · Sep 23, 2009

Hi,

Can you reach the DB from your CF server machine at all, eg: ping it, connect to it via some other client software?

how i can test that?

I can reach the Database with "phpmyadmin", so the DB exists.

Greets,

Nico

Report · Sep 23, 2009

How can you test if you can ping it? By pinging it! Drop down to a command prompt and type "ping [address of DB server here]". http://en.wikipedia.org/wiki/Ping

Is your PHP install on the same server as the CF install? You're not testing if the DB exists, you're testing if the CF server can communicate with the DB server. At network level, not application level.

If PHP is indeed installed on the same server as CF, and you can connect to the DB via it, then that's fine: question answered... it's not a network problem.

--

Adam