> > Per another thread and based on Andy Allan's pointer and Nasir > Ghaznavi's additional > > input, creating a datasource against a sql 2000 db was successful > (did that a while ago), > > however, I think the Macromedia's JDBC does not support connection > to a sql 2005 > > express database, for I've tried both manual and automatic ds setup > to no avail. > > The SQL Server driver that comes with CF can connect to any version > of > SQL Server 2005 including Express. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/
Thanks, Dave, but it's a bit odd. Previously I've tried to use the MS SQL Server driver that comes with cf8 to no avail, but just now, it works, I think I used same setting/parameters, maybe I wasn't careful enough, possible. Now, a problem, when referencing a sql server 2005's instance, one has to use the exact machine name but not (local) nor (localhost), but I need to use a generic one -- OS = XP w/ SP3. Tring to find the computer's name may likely be blocked for security reason. Further thought? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313858 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
