[cfaussie] Re: adding a dsn connectio with SQL 2005

Sun, 19 Mar 2006 21:22:48 -0800

Can't seem to find that? where would I find it in this new version?

:)

Thanks

On 3/20/06, Dale Fraser < [EMAIL PROTECTED]> wrote:

What port?

It uses a non standard also I think, other than 1433

Regards
Dale Fraser


> -----Original Message-----
> From: [email protected] [mailto:[email protected] ] On
> Behalf Of Carl Vanderpal
> Sent: Monday, 20 March 2006 15:54 PM
> To: [email protected]
> Subject: [cfaussie] Re: adding a dsn connectio with SQL 2005
>
> I have it enabled now and still not working?? :(
>
>
>
>
> On 3/20/06, Dale Fraser <[EMAIL PROTECTED]> wrote:
>
>
>       SQL 2005 doesn't have TCPIP enabled by default.
>
>       Regards
>       Dale Fraser
>
>
>       > -----Original Message-----
>       > From: [email protected] [mailto:[email protected]]
> On
>       > Behalf Of Carl Vanderpal
>       > Sent: Monday, 20 March 2006 14:35 PM
>       > To: CF Aussie - Google
>       > Subject: [cfaussie] adding a dsn connectio with SQL 2005
>       >
>       > I am receiveing an error from CFMX Admin with the following:
>       >
>       > Connection verification failed for data source: yourDatabase
>       > 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
>       >
>       >
>       > Running CFMX 7.0 with MS SQL 2005
>       >
>       > I installed SQL with the option Multimixed mode (not the Windows
>       > Authentication Only)..I have also tried to do this via the control
> panel
>       > ODBC panel but with no success, can anyone shed some light on this
> if they
>       > have had some problems as well..
>       >
>       > Thanks
>       >
>       > :)
>       >
>       > ====================================
>       > Postal: Po Box 3462 Dural, NSW 2158
>       > Email: mailto: [EMAIL PROTECTED]
>       > FireFly Internet Phone: 80011777
>       --
>       ====================================
>       Postal: Po Box 3462 Dural, NSW 2158
>       Email: mailto:


--
====================================
Postal: Po Box 3462 Dural, NSW 2158
Email: mailto:[EMAIL PROTECTED]
FireFly Internet Phone: 80011777
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "cfaussie" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~----------~----~----~----~------~----~------~--~---

Reply via email to