I have a couple of applications where I want to update two database servers simultaneously. I have just set up a datasource for each server on my CFserver, and run the update query twice - once with each datasource name. No need for connect strings.
It breaks if the remote server isnt available for any reason, you have to surround the CFQuery with Try/Catch blocks, and have some erro handling, but as long as both servers are accessible at the instant you execute the page, there's no problem at all. The CFServer doesn't care where the database server is, as long as it can connect to it. If I understand it right, you only need to have connect strings if the database name is dynamic. I dont know much about them because I've never needed to use them. Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Sun, 06 Mar 2005 00:46:02 -0600, Nick Baker <[EMAIL PROTECTED]> wrote: > 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:197640 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54