IP address for DSN? Please explain as DSN should be DSN. Database server
could be an IP address but not the DSN surely? DataSourceName should be
that. A name. Not an IP address. Eg: 127.0.0.1 or localhost for a database
address and MyNewDatasource or BoyItWasCoolTodayComparedToYesterday is a
Data Source Name.
Confused?
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 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/
