some quick advice if possible on MSDE

hog

hog

Well-known member
Joined
Mar 17, 2003
Messages
984
Location
UK
I currently have a trial version of an application released to users which connects to an Access2002 database backend. As I am still developing the application I have been investigating the possibility of moving it over to a SQL Server database using MSDE as I am reading that it is more efficient.

I have little knowledge of SQL Server or MSDE so was wondering could someone just clarify a few points if possible.

If I create a version of my Access2002 database as a SQL Server database using the server explorer within .NET do all I need to do is this:

1. copy the database to a machine which has MDSE running on it

2. modify my code so that it uses the SQL namespace objects rather than OLEDB

3. does the PC that will have the database and MSDE installed need to have the server service running? I am aware that there is a limit of having a maximum of ten user connecting to a PC with the server service running, to ensure Windows 2000 server is used for greater number of users. Therefore I assume the MSDE can operate without the server service running???

all help gratefully recieved...



:)
 
1. This can be done using SQL Scripts or those scripts can be run from .NET.

2. You dont have to, but it is recommended.

3. The service needs to run.
 
The "Server" service is largely unrelated to Microsoft SQL Server. It does not need to be enabled/started for SQL Server to work. The rest of your upgrade path seems right.
 
*scratches* If I dont have my service running Im not able to connect to any of my MSDE databases.. :confused:
 
I cant access msde databases without mssql service running.
I wonder if he is referring to IIS?

Im also a little unclear regarding the statement:

"create a version of my Access2002 database as a SQL Server database using the server explorer"

I can manipulate the database after its open, however, it sounds as if he intends to create the database
via server explorer after simple copying a .mdb file to the machine running his msde.

Am I confused or what.
 
need to have the server service running?
Click to expand...
The "Server" service is largely unrelated to Microsoft SQL Server.
Click to expand...

"Server" is the name of a Windows service that is involved with RPC. Thats what I am referring to. Since people are less than explicit on this board half the time I have no desire to assume hes referring to something else, if in fact he is.
 
OKey dokey :-)

Yes I mean to create the database within the Visual Studio .Net Server Explorer

Yes I intend to have the MSDE service running in order to allow access to the SQL database

I was asking do I need the Windows Server service running as well as the MSDE in order for users to connect to my database or do I just need the MSDE running?

Derek you have understood me correct. Thanks to you all for you comments :-)
 
Back
Top