Have you tried using an IP Address instead of a server name in the CF
administrator?
One more thing to check is the login permissions...
Try connecting as "sa"
>That was also already done, still no go (although from ODBC control panel
>the source tests out fine--its just ColdFusion that can't seem to get to
>this SQL Server datasource...weird.)
>
>Thanks for your help...
>
>Eron
>
>----- Original Message -----
>From: "Frank Priest" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Friday, August 11, 2000 8:01 PM
>Subject: Re: Remote SQL server as datasource
>
>
> > Go into the Windows NT "Control Panel", "ODBC"
> >
> > Select your data source, click configure, click "Nex", "Client
>Configuration"
> > Make sure that you have TCPIP selected under Client Libraries.
> >
> > Hopefully that will do the job.... :-)
> >
> >
> > At 06:05 PM 8/11/2000 -0400, you wrote:
> > >Thanks for your help, unfortuantely, I have done that, but still
>no-go...It
> > >still comes back with a "FAILED" status for the connection in the
>ColdFusion
> > >Admin ODBC settings.
> >
> > --------------------------------------------------------------------------
>----
> > Archives: http://www.mail-archive.com/[email protected]/
> > To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
> >
>
>------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
