Make sure that you that you have input your SQL Server username and
Password in the ColdFusion Login section under CF Settings. Unless you do
this, ColdFusion does not know how to log into the server and you will have
to pass the username and password as part of the attributes of CFQUERY.
----- Original Message -----
From: "Eron Cohen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 11, 2000 5:12 PM
Subject: Remote SQL server as datasource
> Hi Folks,
>
> I am trying to set a remote MS SQL server (via the internet) as an ODBC
> datasource in ColdFusion 4.x.
> I can get the connection going fine in the ODBC control panel. But in the
> ColdFusion administrator the datasource verification fails. Does anyone
> have any ideas of what could be wrong?
>
> Thanks,
>
> Eron
>
>
>
>
> --------------------------------------------------------------------------
----
> 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.
