Skip to main content
Known Participant
September 23, 2009
Question

Can't create Datasource - Timed Out

  • September 23, 2009
  • 1 reply
  • 961 views

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

This topic has been closed for replies.

1 reply

Inspiring
September 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

maeldanusAuthor
Known Participant
September 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

Inspiring
September 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