Hi,

I have installed .NET sdk and along with it, SQL

server 2000. Now I want to create my own database on

the server but I cannot find the tool to do so. SQL

server 7 enterprise manager does not seem to work.



Can I use Access 2000? How?



Kapil

You installed SQL Server 2000 and are trying to configure it using the

SQL Server 7 Enterprise Manager?



There are several tutorials on the web on how to use Access as your

primary database. Check http://dotnetjunkies.com or http://123aspx.net

for more details.



-----Original Message-----

From: Kapil [mailto:subscribaa@y...]

Sent: Tuesday, June 26, 2001 1:42 AM

To: ASP+

Subject: [aspx] creating a new database



Hi,

I have installed .NET sdk and along with it, SQL

server 2000. Now I want to create my own database on

the server but I cannot find the tool to do so. SQL

server 7 enterprise manager does not seem to work.



Can I use Access 2000? How?



Kapil

Hello!



If you install .NET Samples and in time of installing you do not have 

SQL

server on machine, then

MDSE2000 (Microsoft Database Engine ) was installed.

This is core component of MS SQL Server with some restriction. MSDE can 

use

only up to five concurent threads,

and there is no admin tools such as EnterpriseManager.

But regarding functionality it is full SQL2000 server with all 

functions

available (including DMO for example).

Some info is at http://msdn.microsoft.com/vstudio/msde/ (this is about 

older

version MSDE 7.0, anyone know about web page for MSDE2000?).



So, when you wants to create your own DB, then you can use other client 

tool

which can connect and manipulate with SQL2000 server

(such as other SQL7/2000 Enterprise Manager on your network, or 

Embarcadero

DB Artisan, or say MS Access (I do not use Access so I don't know

how-to but it is certainly possible).



Other way is write SQL script to create DB and execute it via osql

utility.Or you can write SQL-DMO script (say in VBScript) to create DB 

and

execute it via WSH.



Or you can write your own app (in C# or in VB.NET possibly leveraging

ADO.NET) leveraging ADO to create this.



hth,

Slavo.



-----Original Message-----

From: Kapil [mailto:subscribaa@y...]

Sent: Tuesday, June 26, 2001 10:42 AM

To: ASP+

Subject: [aspx] creating a new database





Hi,

I have installed .NET sdk and along with it, SQL

server 2000. Now I want to create my own database on

the server but I cannot find the tool to do so. SQL

server 7 enterprise manager does not seem to work.



Can I use Access 2000? How?



Kapil

Here's how to create a new database or open an existing database from MSDE

using Access2000:

1) Start Access and then hit cancel to get to the blank main Access window

without any databases open.

2) Go to File > New.  A dialog will appear with both Project (Existing

Database) and Project (New Database). 

3) Choose Project (New Database) to create a new .adp access project file. 

4) A wizard will open and you can choose:

  the SQLServer to create the database in (Use "(Local)" for the local

machine.), 

  the username password to use (Try username:sa and password:{blank})

  the name of the new SQLServer database

5) Click OK and you are done.



Going back to step 2), you can also open an existing database by selecting

Project (Existing Database)

3) Choose Project (Exisitng Database) to create a new .adp access project

file. 

4) A wizard will open and you can choose:

  the existing SQLServer where the database is located, 

  the username/password to use,

  the database on the selected instance of SQL server.

5) Test the connection to make sure everything works.

6) Click OK.





Also, MSDE comes with Office2000 (I know it comes on professional, but it

may be on standard also).  On the Office2000 CD it is located at:

[CDDRIVE]:\SQL\X86\SETUP\SETUPSQL.EXE



Hope this helps,

-Jeff





-----Original Message-----

From: slavomir.furman@s... [mailto:slavomir.furman@s...]

Sent: Tuesday, June 26, 2001 5:54 AM

To: ASP+

Subject: [aspx] RE: creating a new database





Hello!



If you install .NET Samples and in time of installing you do not have SQL

server on machine, then 

MDSE2000 (Microsoft Database Engine ) was installed.

This is core component of MS SQL Server with some restriction. MSDE can use

only up to five concurent threads,

and there is no admin tools such as EnterpriseManager. 

But regarding functionality it is full SQL2000 server with all functions

available (including DMO for example).

Some info is at http://msdn.microsoft.com/vstudio/msde/ (this is about older

version MSDE 7.0, anyone know about web page for MSDE2000?). 



So, when you wants to create your own DB, then you can use other client tool

which can connect and manipulate with SQL2000 server

(such as other SQL7/2000 Enterprise Manager on your network, or Embarcadero

DB Artisan, or say MS Access (I do not use Access so I don't know

how-to but it is certainly possible).



Other way is write SQL script to create DB and execute it via osql

utility.Or you can write SQL-DMO script (say in VBScript) to create DB and

execute it via WSH.



Or you can write your own app (in C# or in VB.NET possibly leveraging

ADO.NET) leveraging ADO to create this.



hth,

Slavo.



-----Original Message-----

From: Kapil [mailto:subscribaa@y...]

Sent: Tuesday, June 26, 2001 10:42 AM

To: ASP+

Subject: [aspx] creating a new database





Hi,

I have installed .NET sdk and along with it, SQL

server 2000. Now I want to create my own database on

the server but I cannot find the tool to do so. SQL

server 7 enterprise manager does not seem to work.



Can I use Access 2000? How?



Kapil

Yeah,

I have this problem and others - like starting an new application in VB.net

and changing the startup form -. Microsoft forgets to tell us the simplest

things. Uses a crypt language in its definitions without any example or

correlation of identifiers or real stuff. Never explain -why, when, and for

what you should do that...

we should find a way to plead our dissatisfaction to the powerfulMS.

If you get your answer, please let me know.

Thanks.





Lindbergh Cupello

Engineer Software Developer

(xxx) xxx-xxxx

www.lindy.vbexplorer.com



----- Original Message -----

From: "Kapil" <subscribaa@y...>

To: "ASP+" <aspx@p...>

Sent: Tuesday, June 26, 2001 4:41 AM

Subject: [aspx] creating a new database





> Hi,

> I have installed .NET sdk and along with it, SQL

> server 2000. Now I want to create my own database on

> the server but I cannot find the tool to do so. SQL

> server 7 enterprise manager does not seem to work.

>

> Can I use Access 2000? How?

>

> Kapil

Hi,

Thanks for the reply. I tried that but it gives an

"overflow" error when I try creating the database.

Any idea on why this is happening?



Kapil



--- Jeff Widmer <jwidmer@L...> wrote:

> Here's how to create a new database or open an

> existing database from MSDE

> using Access2000:

> 1) Start Access and then hit cancel to get to the

> blank main Access window

> without any databases open.

> 2) Go to File > New.  A dialog will appear with both

> Project (Existing

> Database) and Project (New Database). 

> 3) Choose Project (New Database) to create a new

> .adp access project file. 

> 4) A wizard will open and you can choose:

>   the SQLServer to create the database in (Use

> "(Local)" for the local

> machine.), 

>   the username password to use (Try username:sa and

> password:{blank})

>   the name of the new SQLServer database

> 5) Click OK and you are done.

> 

> Going back to step 2), you can also open an existing

> database by selecting

> Project (Existing Database)

> 3) Choose Project (Exisitng Database) to create a

> new .adp access project

> file. 

> 4) A wizard will open and you can choose:

>   the existing SQLServer where the database is

> located, 

>   the username/password to use,

>   the database on the selected instance of SQL

> server.

> 5) Test the connection to make sure everything

> works.

> 6) Click OK.

> 

> 

> Also, MSDE comes with Office2000 (I know it comes on

> professional, but it

> may be on standard also).  On the Office2000 CD it

> is located at:

> [CDDRIVE]:\SQL\X86\SETUP\SETUPSQL.EXE

> 

> Hope this helps,

> -Jeff

> 

> 

> -----Original Message-----

> From: slavomir.furman@s...

> [mailto:slavomir.furman@s...]

> Sent: Tuesday, June 26, 2001 5:54 AM

> To: ASP+

> Subject: [aspx] RE: creating a new database

> 

> 

> Hello!

> 

> If you install .NET Samples and in time of

> installing you do not have SQL

> server on machine, then 

> MDSE2000 (Microsoft Database Engine ) was installed.

> This is core component of MS SQL Server with some

> restriction. MSDE can use

> only up to five concurent threads,

> and there is no admin tools such as

> EnterpriseManager. 

> But regarding functionality it is full SQL2000

> server with all functions

> available (including DMO for example).

> Some info is at

> http://msdn.microsoft.com/vstudio/msde/ (this is

> about older

> version MSDE 7.0, anyone know about web page for

> MSDE2000?). 

> 

> So, when you wants to create your own DB, then you

> can use other client tool

> which can connect and manipulate with SQL2000 server

> (such as other SQL7/2000 Enterprise Manager on your

> network, or Embarcadero

> DB Artisan, or say MS Access (I do not use Access so

> I don't know

> how-to but it is certainly possible).

> 

> Other way is write SQL script to create DB and

> execute it via osql

> utility.Or you can write SQL-DMO script (say in

> VBScript) to create DB and

> execute it via WSH.

> 

> Or you can write your own app (in C# or in VB.NET

> possibly leveraging

> ADO.NET) leveraging ADO to create this.

> 

> hth,

> Slavo.

> 

> -----Original Message-----

> From: Kapil [mailto:subscribaa@y...]

> Sent: Tuesday, June 26, 2001 10:42 AM

> To: ASP+

> Subject: [aspx] creating a new database

> 

> 

> Hi,

> I have installed .NET sdk and along with it, SQL

> server 2000. Now I want to create my own database on

> the server but I cannot find the tool to do so. SQL

> server 7 enterprise manager does not seem to work.

> 

> Can I use Access 2000? How?

> 

> Kapil

> 

>

Kapil,

Can you give us some more information about when you got the overflow error?



Are you using Access2000?

Did you install MSDE from your Office2000 CD?

Were you trying to open an existing MSDE database or were you trying to

create a new one?

What is the name of the MSDE database you were working on?



-Jeff





-----Original Message-----

From: Kapil

To: ASP+

Sent: 6/26/01 12:59 PM

Subject: [aspx] RE: creating a new database



Hi,

Thanks for the reply. I tried that but it gives an

"overflow" error when I try creating the database.

Any idea on why this is happening?



Kapil