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. But Microsoft's sql server 2005 JDBC driver would work. Now the problem is, after looking at the cfadminapi's datasource.cfc documentation, I don't see any argument for a JDBC URL, e.g. jdbc:sqlserver://{serverName}\{instanceName}:{portNumber}...
Any way to get it to work or a viable alternative for creating ds for such db platform on the fly? TIA. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:313788 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4