> -----Original Message----- > From: Andrew Scott [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 10, 2006 12:19 AM > To: CF-Talk > Subject: RE: CF, jdbc, SQL2k5 problem > > Yes by server\instancename in the jdbc driver from M$, > provided you have > opened that instance up for tcp/ip.
That also works with the DataDirect drivers. I am running CFMX 7.0 and SQL 2005 Enterprise (named instance on same machine as SQL 2000 Enterprise default instance, Windows 2003 Server) as-is, no CFMX or MS JDBC updates. Not that I recommend not upgrading to CFMX 7.0.2, just haven't done it yet. Also, it is worth noting that if you don't use an instance name you must use the correct port. If you use an instance name, you can set the port to anything (as far as my testing goes). This is on a local test intranet so what I am saying might not hold true in all situations. So in the datasource config you would use either Server and Port or Server\InstanceName and any port. I found this to work whether SQL Server is set to use dynamic ports or not. Andy ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256066 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
