Friday, March 23, 2012

MSDE 2000 help please

Hi,
I downloaded MSDE 2000 but it's my first time using it and I dont know what
i'm doing. I'm using coldfusion for database driven websites. I can make
databases by using osql in a command prompt but is there an easier way? also
where does the server save the databases that i create? I cant find anything
on my system after i created a basic db.
Any help would be appreciated,
Thanks> I can make
> databases by using osql in a command prompt but is there an easier way?
http://www.aspfaq.com/2442

> also where does the server save the databases that i create?
The data and objects are stored in MDF files on your hard drive. They don't
really have any meaning independently (e.g. you can't open them in notepad
or Excel and look at them like you would in Access or other desktop
applications).

> I cant find anything
> on my system after i created a basic db.
Well, what did you do to "create a basic db"? What are you looking for on
your system?
A|||> Well, what did you do to "create a basic db"? What are you looking for on
> your system?
to start i did osql -E in a command prompt, then I did CREATE DATABASE
Study. Now I cant find the database in my hard drive. I'm "looking" for it s
o
i can use it in coldfusion server. I need to point to a physical file to
register that db so I can manipulate it in my web pages.The documentation on
how to do such things arent very available on the ms knowledge base. At leas
t
IMO
Phil|||It does not work this way. You can't point an application at a data file
for SQL Server and expect to "manipulate it in your web pages."
However, go ahead, look for the file, it will be called study_data.mdf, most
likely.
Let us know when you run out of ideas trying to point ColdFusion at that
file and banging your head against the wall.
You might consider checking ColdFusion documentation; there's plenty of
information available about SQL Server and MSDE in the knowledge base
(perhaps you just aren't sure what to look for).
http://www.aspfaq.com/
(Reverse address to reply.)
"Skinman" <Skinman@.discussions.microsoft.com> wrote in message
news:730E0313-4155-47E0-A309-B43AB5A10660@.microsoft.com...
on[vbcol=seagreen]
> to start i did osql -E in a command prompt, then I did CREATE DATABASE
> Study. Now I cant find the database in my hard drive. I'm "looking" for it
so
> i can use it in coldfusion server. I need to point to a physical file to
> register that db so I can manipulate it in my web pages.The documentation
on
> how to do such things arent very available on the ms knowledge base. At
least
> IMO
> Phil

No comments:

Post a Comment