So, if this is a new installation (no datasources set up in CFMX Admin), the only way to do it is to use a Query Analyzer (or similar tool) and run the db creation script?
Thanks Dave Victor On 5/1/06, Dave Watts <[EMAIL PROTECTED]> wrote: > > > I am trying to create a MS-SQL 2000 database through a cfm > > script (CFMX 7.01if it makes any difference). > > > > I think it can be done using the dbtype="dynamic" in a > > cfquery, but I need to pass a connection string. > > So. will it work and if yes how can I get the connection string? > > That attribute value ("DBTYPE='DYNAMIC') is not available within CFMX 7.x. > You will need an existing connection to a SQL Server database with a login > that has permission to create a database. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239204 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