Choosing database between MSDE and Access

hi,

I need to choose a database based on the following criteria (using .NET app):
1) a light but fully functional database, preferably with the support of store proc and constraints, less than 8000 transaction a day.
2) portable or the database can be export/import very easily
3) reliable and stable
4) least maintenance

I have two db in my mind, Access and MSDE?
Does anyone have some hand-ons experience on the above two? Or any other better suggestions?

Any advice is appreciated.

thanks,
bryanUsing MSDE will generally be more trouble-free. A file-based database on a Web server is not ideal.

Choosing correct database

Hello,
So far, I've been programming distributed multiuser applications using MSDE
as my choice of db.
I got another project that requires client (local) application.
Which database would you suggest?
I don't want to use MSDE as I'm having fear about it running as service,
they might disable it + it will put additional cpu load on client.
Is Access or plain XML solution to my problem ?
Of course, I'm trying to stay as cheap as possible, if not free.
Thank you
VladoVlado,
Jet might work depending on the number of users and the size.
HTH
Jerry
"Vlado Jasovic (excelleinc.com)" <vjasovicATexcelleincDOTcom> wrote in
message news:OkTNX0n1FHA.612@.TK2MSFTNGP10.phx.gbl...
> Hello,
> So far, I've been programming distributed multiuser applications using
> MSDE as my choice of db.
> I got another project that requires client (local) application.
> Which database would you suggest?
> I don't want to use MSDE as I'm having fear about it running as service,
> they might disable it + it will put additional cpu load on client.
> Is Access or plain XML solution to my problem ?
> Of course, I'm trying to stay as cheap as possible, if not free.
>
> Thank you
> Vlado
>

Choose MSDE install location?

I'm trying to install MSDE at c:\Program Files\Microsoft\SQL Server\ (as
opposed to ...\Microsoft SQL Server\).
I tried using the DATADIR= and TARGETDIR= options, but they don't seem to
affect the COM and Tools folders (which always get installed at
...\Microsoft SQL Server\80\). I don't see any other options to set the
location for those two folders.
Am i missing something, or am i stuck with keeping the COM and Tools
directories where they are?
/
hi,
I HATE PDAs wrote:
> I'm trying to install MSDE at c:\Program Files\Microsoft\SQL Server\ (as
> opposed to ...\Microsoft SQL Server\).
> I tried using the DATADIR= and TARGETDIR= options, but they don't
> seem to affect the COM and Tools folders (which always get installed
> at ...\Microsoft SQL Server\80\). I don't see any other options to
> set the location for those two folders.
> Am i missing something, or am i stuck with keeping the COM and Tools
> directories where they are?
you do not have control over a "little" part of the installations... this
with regard to all binaries that will be shared among all available SQL
Server / MSDE 2000 instances... these shared binaries will always be
installed there, and present at the higher service pack level..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Checksum problem on system database

Hey there,
we're having an issue with the SQL (MSDE) database that sharepoint uses.
The service starts and immediately stops. In the logs (in dutch) there's
an error: "Het checksumbestand van de systeemdatabase heeft een
ongeldige ondertekening." freely translated it says "The checksumfile
from the system database has a invalid signature".
Anyone know how to solve this or where start searching? Does SQL have
something like eseutil I might try to repair the database?
TIA
hi,
Freaky wrote:
> Hey there,
> we're having an issue with the SQL (MSDE) database that sharepoint
> uses. The service starts and immediately stops. In the logs (in
> dutch) there's an error: "Het checksumbestand van de systeemdatabase
> heeft een ongeldige ondertekening." freely translated it says "The
> checksumfile from the system database has a invalid signature".
> Anyone know how to solve this or where start searching? Does SQL have
> something like eseutil I might try to repair the database?
if you have a valid master database backup, you can restore it as indicated
in http://msdn2.microsoft.com/en-us/library/Aa173557(SQL.80).aspx and
http://msdn2.microsoft.com/en-us/library/Aa176749(SQL.80).aspx ... if you
don't, you are in trouble, as MSDE does not provide the Rebuild utility
(rebuildm.exe) and the scripts to re-generate it.. if this is the case, you
have to uninstall and reinstall the MSDE instance.. you can or course keep
your user's databases files an re-attach them once re-installed..
regards
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
-- remove DMO to reply
|||Hey Andrea,
thx for the re. I was already afraid I would have to reinstall. It's the
instance from sharepoint. We do maintenance at a lot of customers and
some have full SQL versions so perhaps I could use the rebuildm tool
there. But reinstalling sharepoint and replacing the database STS and
STS_Config might be faster as I think those are the only ones that matter.
Anyways thanks again
Andrea Montanari wrote:
> hi,
> Freaky wrote:
> if you have a valid master database backup, you can restore it as indicated
> in http://msdn2.microsoft.com/en-us/library/Aa173557(SQL.80).aspx and
> http://msdn2.microsoft.com/en-us/library/Aa176749(SQL.80).aspx ... if you
> don't, you are in trouble, as MSDE does not provide the Rebuild utility
> (rebuildm.exe) and the scripts to re-generate it.. if this is the case, you
> have to uninstall and reinstall the MSDE instance.. you can or course keep
> your user's databases files an re-attach them once re-installed..
> regards

Check TCP port

I have establlished a MSDE server.
I know how to check the TCP port at the server.
But, I also want to know if it is possible to check the
TCP port from other workstation?
Please advise.
Thanks.
hi,
A4apple wrote:
> I have establlished a MSDE server.
> I know how to check the TCP port at the server.
> But, I also want to know if it is possible to check the
> TCP port from other workstation?
> Please advise.
> Thanks.
in order to check connectivity, you can perhaps ping the server, or telnet
it, like
c:\..\>telnet servername port_num ;
if the screen becomes black you are connected to the SQL Server instance
(type quit to exit)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply