Thanks, I actually tried to use MS Access by creating an Access project file (I was using the project wizard) and it didn't find the server.
I'll keep playing around with it. I'll try to find osql.exe, thank you very much!! Yves Arsenault ----- Original Message ----- From: "Dave Watts" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, August 14, 2002 11:11 PM Subject: RE: Office XP SQL server > > I remember seeing some discussion about a lite version of SQL > > server that came with office xp (and 2000) pro. > > > > I installed it and so far cannot do anything with it..... > > How do I create a db with it, and then the DNS ? > > There's no GUI for MSDE, so you have to do everything from an ODBC (or > other) client. First, make sure the MSSQLSERVER service is running. Then, > you can connect via osql.exe (which could be in various places, depending on > which MSDE version you installed - just search the drive on which you > installed MSDE). From osql, you can type whatever SQL commands you like, to > create databases, and to create tables and other objects within those > databases. > > Alternatively, you can use MS Access 2000/XP as a front-end to MSDE, by > creating an Access Project. > > 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
