Have you tried "localhost" or "127.0.0.1"? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tim Donovan Sent: Thursday, 2 December 2004 4:25 PM To: CFAussie Mailing List Subject: [cfaussie] Re: Connection verification failed for data source
Hi Tom, Thanks for your suggestion....ReefStateDB is just my CF datasource name I am using IP address for my DSN. I tried reefstatedb in lowercase but no still no luck...I wish the error would tell me more....I can connect fire with the same details using ODBC or Enterprise Manager...that whats got me so beat! :( Thanks again Tim "Tom MacKean" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] I'm probably on the wrong track but I remember having a ton of trouble getting my web site up and running on a host and though I can't remember exactly, this error message looks very familiar. Turned out that in my code my DSN was in upper case and the server wouldn't recognise it. Changing the dsn to lowercase fixed it. The server also wanted lower case table names in my database. Maybe you could try reefstatedb... Tom MacKean -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tim Donovan Sent: Thursday, 2 December 2004 4:07 PM To: CFAussie Mailing List Subject: [cfaussie] Re: Connection verification failed for data source nah...no luck I reinstalled from scratch (with the patch this time) and its still the same error. Connection verification failed for data source: ReefStateDB []java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect I'll beers at MXDU for whoever can solve it :) "Robin Hilliard" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > Tim Donovan wrote: > > > > > Connection verification failed for data source: ReefStateDB > > []java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error > > establishing socket. Connection refused: connect The root cause was > > that: java.sql.SQLException: [Macromedia][SQLServer JDBC > > Driver]Error establishing socket. Connection refused: connect > > Hi Tim, > > Glad to hear you guys are still operating :-) If you have access to > JRun you could add -verbose to the jvm.config, start the server from > the command line and see if there was any more exception info in the trace. > There were also a few SQL server specific patches to CFMX 6.1, > assume they're installed? > > Cheers, > Robin > http://www.rocketboots.com.au > > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
