Damn fine question Tom.
Sounds like you are not on a Wintel server. Should not be a major issue but
stick to some of these rules:
1. Apart from Application.cfm and OnRequestEnd.cfm - keep your filenames in
lowercase, eg:
index.cfm, dsp_myprofile.cfm, act_doitnowplease.cfm
- it should be noted that CF7 (Blackstone) will introduce a whole host of
new event gateway possibilites but if they stick to Application... And not
say application... Then they should be shot. Move everything to lowercase I
say and at least be consistent.
2. Table names. Well that is definitely not a Wintel (SQL Server 2000)
issue. Find out what db server you are using as it can make a huge
difference.
I hope that helps a bit. DSN issues aside it sounds like the database server
is the problem. Even SQL Server 2000 should at least be running SP3 by now.
And (so far) apart from Application.cfm and OnRequestEnd.cfm stick to
lowercase filenames until MM decide otherwise.
Peter Tilbrook
ColdGen Internet Solutions
Manager, ACT and Region ColdFusion Users Group
4/73 Tharwa Road
Queanbeyan, NSW, 2620
AUSTRALIA
WWW 1: http://www.coldgen.com/
WWW 2: http://www.actcfug.com/
Telephone: +61-2-6284-2727
Mobile: +61-0439-401-823
E-mail: [EMAIL PROTECTED]
>>
All of my external emails are scanned for viruses using the latest
available Norton AV signatures. Also I do NOT maintain an Address book or
Contact list to minimise the risk of infecting recipients of my messages for
viruses. I also prefer "plain text" emails for speed and efficiency.
Powered by Lookout:
Lookout is lightning-fast search for your email, files, and desktop works
with Microsoft Outlook.
http://www.lookoutsoft.com/Lookout/
>>
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom MacKean
Sent: Thursday, 2 December 2004 4:17 PM
To: CFAussie Mailing List
Subject: [cfaussie] Re: Connection verification failed for data source
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/
