Last I heard CF couldn't connect to SQL Server 2005 yet. But I must confess I haven't been listening too closely so I may have missed an update.
-----Original Message----- From: Jacob [mailto:[EMAIL PROTECTED] Sent: Friday, December 16, 2005 9:30 AM To: CF-Talk Subject: RE: CFMX and Sql Server 2005 (mirrored instances) We have two mirrored SQL 2000 servers (soon to be 2005). We use Legato CoStandby Server in an active/passive mode. You create a VIP address and use that in your data source setup. We have been using it for about 6 years now and have had no problems. Not sure if this helps you for your situation, but just another idea. Jacob -----Original Message----- From: Tony [mailto:[EMAIL PROTECTED] Sent: Friday, December 16, 2005 8:07 AM To: CF-Talk Subject: CFMX and Sql Server 2005 (mirrored instances) hola peeps... ok, we are thinking of bringing a new SQL Server 2005 into our application systems and one of the things we are thinking about using is two mirrored servers... both are going to be the same data and structure however they will not share an ip address, or name. ....NET can handle this in its new connection string setting "Failover" and im just wondering how/if ColdFusion MX 7 will handle this, or not handle this. Anyone doing this yet? Thanks! tony ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:227175 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
