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
