Re: backing up using sql-dmo

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: dev_kh (devkh_at_discussions.microsoft.com)
Date: 07/07/04 

Date: Wed, 7 Jul 2004 08:06:01 -0700

oh ok, so:
1> Install MSDE on the 5th computer
2> Install my app on the individual computers
3> Create Database on the 5th computer
4> Specify the \\5thComputerName\Instancename in the connection string for the database on the 4 individual computers.

Right??

But then, in this scenario:
1> Why do I need to update the dependencies (regarding sql-dmo) on the client's machine, the clients machine literally has nothing related to MSDE in this setup. Everything is on the server.
2> Is there any good article I can read which explains all this instead of bothering you so much. I mean explains what needs to be done to make sure that the installation, database creation/updates, database access works fine on a 1 computer, MSDE on it setup AS WELL AS on 4 computers office with users sharing the database..

Thanks Andrea, I really appreciate it.

dev

"Andrea Montanari" wrote:

> hi dev,
> "dev_kh" <devkh@discussions.microsoft.com> ha scritto nel messaggio
> news:6E99B27C-EBF2-4621-AD18-538851114633@microsoft.com...
> > 1> You mean the clients which use my app.. right.
> yep
> > 2> Which are the dependent dlls' of dmo
>
> ; not licensed by redist.txt but available after installation of MDAC2.6
> ...\WINDOWS\SYSTEM\odbcbcp.dll; DestDir: WinSys ; sharedfile
> ; not licensed by redist.txt but available after installation of MDAC2.6
> ...\WINDOWS\SYSTEM\sqlwoa.dll ; DestDir: WinSys
> ; not licensed by redist.txt but available after installation of MDAC2.6
> ...\WINDOWS\SYSTEM\sqlwid.dll ; DestDir: WinSys
> ...\Programmi\Microsoft SQL Server\80\Tools\Binn\w95scm.dll; DestDir:
> DestinationFolder\Binn
> ...\WINDOWS\SYSTEM\sqlunirl.dll ; DestDir: WinSys
> ...\Programmi\Microsoft SQL Server\80\Tools\Binn\sqlresld.dll; DestDir:
> DestinationFolder\Binn
> ...\Programmi\Microsoft SQL Server\80\Tools\Binn\sqlsvc.dll; DestDir:
> DestinationFolder\Binn
> ; not licensed by redist.txt but available after installation of MDAC2.6
> ...\Programmi\Microsoft SQL Server\80\Tools\Binn\Resources\1033\sqlsvc.RLL;
> DestDir: DestinationFolder\Binn\Resources\1033
> ; not licensed by redist.txt but available after installation of MDAC2.6
> ...\Programmi\Microsoft SQL Server\80\Tools\Binn\Resources\1033\Sqldmo.rll;
> DestDir: DestinationFolder\Binn\Resources\1033
> ...\Programmi\Microsoft SQL Server\80\Tools\Binn\sqldmo.dll; DestDir:
> DestinationFolder\Binn ; file to be registered via regserver
>
> DestinationFolder can either be the installation directory of one instance
> of Microsoft SqlServer 2000, like ..\Program Files\Microsoft SQL
> Server\80\Tools, even if no istance of SQL Server has been installed, or the
> installation directory of your application. Please do respect the hierarchy
> \Binn\Resources\1033 (where 1033 specifies the language), where needed, in
> order to grant correct functionality of Ole-Automation objects.
>
> In order to install SQL-DMO components for MSDE 2000, Microsoft Internet
> Explorer 5.5 or higher is required.
>
>
> > 3> This gives me an opportunity to post about one other issue, imagine a
> small office
> >setup with 4 users who want the database on 5th machine. Will I need to
> install MSDE
> >on all five machines or just on 4 user machines (and just attach on them
> the database
> > which resides on the 5th machine).
>
> be calm =;-D
> you can install MSDE on all 4 user's pc, but DON'T attach to all of them the
> db residing on the 5th (the server)... actually you physically are not
> allowed to, as SQL Server requires a special trace flag to create a database
> on a share not residing on the physical server file system.. this for
> secuirity [=;-D] and performace...
>
> you usually install MSDE ONLY on the server (your 5th pc), and MDAC, your
> app(s) (and DMO if required) on your 4 user's pc...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> --------- remove DMO to reply
>
>

Relevant Pages

  • Re: ADO help required
    ... > creating a database in VB.Net 2003 and distributing that application and ... I found MSDE 2000 and downloaded it but cannot install it. ... > Also, if I eventually managed to install MSDE, can it be installed with ... > the application or does the user needs to install this separately? ...
    (microsoft.public.vb.database)
  • Re: backing up using sql-dmo
    ... > 2> Install my app on the individual computers ... >on the 4 individual computers. ... if your app on pc1 to pc4 uses SQL-DMO to perform backups, ... installation, database ...
    (microsoft.public.sqlserver.msde)
  • Re: Install MSDE with SP3 without User intervention
    ... Our install software is InstallShield DevStudio 9.1 and it allows you to ... conditionally install MSDE 2000. ... MSDE with a blank or known password, run the database scripts, ask for a new ... Just click on setup and it would install your app, msde, make the ...
    (microsoft.public.sqlserver.server)
  • Re: Install MSDE with SP3 without User intervention
    ... This says to have an install complete with SP3. ... Then using the scripting and such that you spoke of with OSQL to ... install the database and such. ... > conditionally install MSDE 2000. ...
    (microsoft.public.sqlserver.server)
  • How to build a VAX/VMS emulator on Fedora Core 3 Linux
    ... make install the libpcap for ethernet support on VAX emulator ... Is the OpenVMS media ready to be mounted? ... * Do you want to install the MSGHLP database? ... Message from user AUDIT$SERVER on NEWBB ...
    (alt.os.linux.redhat)