Hi Dave, It's all fine now. Using the DNS-less connection I was able to create the db and using the Admin API to create the datasource programmaticaly.
Two things that I have found: after the db is created the script throws an error saying that no result set was return. I had to put in in a try/catch block. Some info in the CFMX docs are wrong: setStringParameterAsUnicode should be sendStringParametersAsUnicode. I still have an issue that I can't figure out, regarding how I set the timeout and interval it creates it with timeout = 1 and interval = 0. I'm not sure if this is a bug or just some obvious mistake on my end. Thanks to all that helped. Very good list... Victor On 5/2/06, Dave Watts <[EMAIL PROTECTED]> wrote: > > > yes, I know about the Admin API, but I need to physically > > create the database and then create the datasource using the > > Admin API. > > If you have a database login with the appropriate permissions, you could > create a datasource pointing to the SQL Server master database, run your > creation script, then modify the datasource to point to the new 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:239316 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
