> > When you create a database, it's up to you to specify where > > the data and log files will be created. Depending on how you > > created the database ... > > Well, now I'm doubly mystified. I ran the MSDE install off > my Office XP CD. Of course there was no enterprise manager, > so my next step was to install a datasource in Win's ODBC > applet. The wizard gave no file paths to specify... just a > server name. > > After securing the sa acct and making a tweak in CF Admin (to > use a trusted connection as its a dev box) I was able to > create tables and insert/update/delete in them via CF. > > Tried searching for .mdf's, and only got the defaults I > mentioned earlier, whose file times are stuck at my install > time. Same with a dir *.mdf /s in a cmd window.
Well, in that case, you didn't create a database at all - you just created tables in the default database. Usually, the default database is "master". This is not a good place to create user tables. What you'll need to do is create a new database. You can do this while connected to the master database. Then, you'll need to create the tables in the new database, and copy the data from the tables in master to the tables in your new database, and finally, you'll want to drop the tables you created in master and never touch it again. I'd recommend getting a copy of the SQL Server Books Online (available at http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com/ support/SQL/default.asp - scroll down to the appropriate version) and using the OSQL command-line client to run your SQL batches. When you create ODBC datasources for your SQL databases, you'll need to specify the database name on the step of the wizard after you select the server. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
