Well, you can't do it in the cfquery tag, so it's no way.
-----Original Message-----
From: Nick Baker [mailto:[EMAIL PROTECTED]
Sent: Sunday, 6 March 2005 3:13
To: CF-Talk
Subject: RE: CFQUERY accessing MS SQL DB on another CF server
CFAdmin's instructions are to provide the following ConnectionString. It is
that way or no way.
ConnectionString = "DRIVER=SQL Server;SERVER={ipaddress};UID={username};
PWD={password};APP=;DATABASE={database}"
I can't figure out where to put it?
Security is not an issue in this case. Some public information brought
together for our convenience at any given moment in time.
Nick
At 12:54 AM 3/6/2005, you wrote:
>Well, hard coding your SQL username & password is a security risk and
>IMHO bad practice.
>You should let the CFAdmin handle that for you.
>
>Warmest Regards,
>
>Phillip B. Holmes
>
>
>
>-----Original Message-----
>From: Nick Baker [mailto:[EMAIL PROTECTED]
>Sent: Sunday, March 06, 2005 12:46 AM
>To: CF-Talk
>Subject: CFQUERY accessing MS SQL DB on another CF server
>
>MX 6.1
>
>In some of the earlier versions you could query a db on other servers
>around the Internet. V 6 and later (I think) changed up <CFQUERY and I
>can't seem to get it going again.
>
>In earlier versions we had a connectString attribute which took
>something like the following.
>
>ConnectionString = "DRIVER=SQL
>Server;SERVER={ipaddress};UID={username};
>PWD={password};APP=;DATABASE={database}"
>
>
>Does anyone know how to accomplish this with V 6 and later?
>
>Thanks,
>
>Nick
>
>
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197604
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
