completely ignorant

Hello, I admit I am completely ignorant of MSDE and SQL in general. Ive
developed many things with php / mysql and a few with access but MS SQL is a
completly new beast for me. Ive been told i need to develop it locally with
MSDE then upload the finished project to the SQL server and just change the
connection string.
Ive installed MSDE (i think) with the SAPWD switch, the installed completed.
Now how do I get access to it? Is there a GUI I can download (like
mysqlAdmin) or does access act as a front end?
Im not even sure that I have it installed right or that it is running. If
there is anyone that would be as kind as to help me though this I would be
most greatful.
hi,
eramus wrote:
> Hello, I admit I am completely ignorant of MSDE and SQL in general.
> Ive developed many things with php / mysql and a few with access but
> MS SQL is a completly new beast for me. Ive been told i need to
> develop it locally with MSDE then upload the finished project to the
> SQL server and just change the connection string.
> Ive installed MSDE (i think) with the SAPWD switch, the installed
> completed. Now how do I get access to it? Is there a GUI I can
> download (like mysqlAdmin) or does access act as a front end?
> Im not even sure that I have it installed right or that it is
> running. If there is anyone that would be as kind as to help me
> though this I would be most greatful.
wow... this deserves a book :D
anyway, you can use Access as front end for MSDE, or you can have a look at
other free and/or commercial tools listed at
http://www.microsoft.com/sql/msde/partners and/or
http://www.aspfaq.com/show.asp?id=2442...
please download and install the SQL Server Books On Line from
http://www.microsoft.com/downloads/d...displaylang=en ,
the best guide ever you need to run and reference for your activity
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||"Andrea Montanari" wrote

> wow... this deserves a book :D
;-)

> anyway, you can use Access as front end for MSDE, or you can have a look
> at other free and/or commercial tools
Or use the commandline tool osql.exe (which is included with MSDE)
This gives you the option of a nice crash course in T-SQL
With BOL (Books OnLine) it is possible :-)
http://www.microsoft.com/downloads/d...displaylang=en ,
- Peter
|||Hi,

> Hello, I admit I am completely ignorant of MSDE and SQL in general. Ive
> developed many things with php / mysql and a few with access but MS SQL is
a
> completly new beast for me. Ive been told i need to develop it locally
with
> MSDE then upload the finished project to the SQL server and just change
the
> connection string.
> Ive installed MSDE (i think) with the SAPWD switch, the installed
completed.
> Now how do I get access to it? Is there a GUI I can download (like
> mysqlAdmin) or does access act as a front end?
Try our tool, it works fine with MSDE and its called Database Workbench
www.upscene.com
It also includes MySQL connectivity and schema migration tools.

> Im not even sure that I have it installed right or that it is running. If
> there is anyone that would be as kind as to help me though this I would be
> most greatful.
>
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com