I might also add that if you are on a MX 7 Ent box this is a great example of how asynchronous cfm calls can really speed up an app. You can make an async call to a cfc which would do the remote update, no delays in your actual page rendering time and no try catch needed around the call. These async calls are kick butt!
Adam H On Mon, 7 Mar 2005 16:02:43 +1100, Mike Kear <[EMAIL PROTECTED]> wrote: > 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:197674 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