Showing posts with label example. Show all posts
Showing posts with label example. Show all posts

Wednesday, March 28, 2012

INSTALLING MSDE

I followed all instructions, then I got an example from microsoft on creating a database, it isjust a visual basic example, it has a button create database and it says sql server not found but i can see it on the tray that it is running and using the web interface i can see the databases so i dont know why doesnt the microsoft created example doesnt work.
Thank youShell out to a DOS prompt and type in
osql -L
This will provide you a list of the SQL servers you have access to.

Now, compare this server name to the name of the server in the connection string you are using.

Do they match?

If they match, please provide the connection string you are using and the exact error message you are getting.

Terri

Monday, March 26, 2012

installing custom master?

If I am installing MSDE with my application, is there any way to include a
customized master.mdf? For example, I'd like to ship it preconfigured with
autostart procedures, extended stored procedures, etc. Or do I have to add
these with a script after the install?
Thanks for any suggestions.
hi Neil,
"Neil W" <neilw.nospam@.netlib.com> ha scritto nel messaggio
news:eMkAq2%23MEHA.3400@.TK2MSFTNGP09.phx.gbl...
> If I am installing MSDE with my application, is there any way to include a
> customized master.mdf? For example, I'd like to ship it preconfigured
with
> autostart procedures, extended stored procedures, etc. Or do I have to
add
> these with a script after the install?
please don't ... :-|
=;-D
the master database, as long as all system database is built with references
to all user's setting at installation time...
provide your own scripts and run them in order to achieve the desired
result...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Wednesday, March 21, 2012

Installed SQLServer Express.....now what?

Hi

I've succesfully installed Visual C# and I've made a couple of example projects. I now want to try and create a database and see if I can make a C# application that talks to it.

So I've installed SQL Server Express. I was hoping I could open it up and get started with creating tables etc. Instead, my Start menu shows:

Microsoft SQL Server 2005

>>>Configuration Tools

>>>>>>SQL Server Configuration Manager

>>>>>>SQL Server Error and Usage Reporting

>>>>>>SQL Server Surface Area Configuration

Where do I go now? Is there some configuring to do before I can start making tables and storing data? Or, have I misunderstood what SQL Server is about?

Thanks


Rich

For one thing, VS provides tools that allow you to create databases and then fill them with all kinds of database goodness. (i.e. Tables, Views, Stored Procedures, you name it.) They pretty much give you everything you need.

If you want to use the SQL Tools to do this, you'll need to download SQL Management Studio Express, which you can get from the SQL Express download page. Once you install SSMSE, you'll see another item on your Start menu.

Mike