SQL Server 7 & Vb & MSDE


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: SQL Server 7 & Vb & MSDE

  1. #1
    Peter Guest

    SQL Server 7 & Vb & MSDE


    Hi,
    I have a Vb application developed for Sql Server 7. How easy will it be to
    change to MSDE. I have not used or seen MSDE yet so I'm trying to get an
    idea of how this works.

    I have looked up all the info in Microsoft but I'm looking for some advice
    from someone who has maybe done this before or has used VB and MSDE.


    Thanks for any help.

    Pete

  2. #2
    Joe \Nuke Me Xemu\ Foster Guest

    Re: SQL Server 7 & Vb & MSDE

    "Peter" <peter__maloney@hotmail.com> wrote in message <news:3c6cea39$1@10.1.10.29>...

    > I have a Vb application developed for Sql Server 7. How easy will it be to
    > change to MSDE. I have not used or seen MSDE yet so I'm trying to get an
    > idea of how this works.
    >
    > I have looked up all the info in Microsoft but I'm looking for some advice
    > from someone who has maybe done this before or has used VB and MSDE.


    MSDE and SQL Server 7.0 are pretty much one and the same, except that
    MSDE is "throttled" to handle five concurrent operations. There can
    be more than five concurrent connections, however. Think of it like
    five checkout lanes in the supermarket.

    URL:http://msdn.microsoft.com/vstudio/do...de/default.asp

    Unfortunately, MSDE won't save you from those huge SQL Server service
    packs:

    URL:http://microsoft.com/sql/downloads/sp3.asp

    URL:http://support.microsoft.com/default...id=kb;;q263968

    --
    Joe Foster <mailto:jlfoster%40znet.com> Space Cooties! <http://www.xenu.net/>
    WARNING: I cannot be held responsible for the above They're coming to
    because my cats have apparently learned to type. take me away, ha ha!



  3. #3
    Bernie Guest

    Re: SQL Server 7 & Vb & MSDE


    "Peter" <peter__maloney@hotmail.com> wrote:
    >
    >Hi,
    >I have a Vb application developed for Sql Server 7. How easy will it be

    to
    >change to MSDE. I have not used or seen MSDE yet so I'm trying to get an
    >idea of how this works.
    >
    >I have looked up all the info in Microsoft but I'm looking for some advice
    >from someone who has maybe done this before or has used VB and MSDE.
    >
    >
    >Thanks for any help.
    >
    >Pete


    Hi Pete

    MSDE is basicly SQL-Server 7.0 Desktop version without the graphical tools
    (=Enterprise Manager). So any db developed for SQL-server can be used with
    MSDE. Microsoft says it is limited to 5 concurent queries (not users as some
    people say). Max db size is also limited (don't remember exactly the number
    of Gb's, maybe it was 2). If you have a Visual Studio license you may freely
    distribute MSDE. If you don't, let your clients download it themselves(!)

    I have'nt had more problems with MSDE as with SQL-server, it just works the
    same (so far...) I access it with the Enterprise Manager shipped with the
    BackOffice Suite.

    Download it and get started. It's a bit tricky to install since you'll have
    to pass some arguments when launching Setup.exe so read the readme file first.

    In you VB app, -Treat it just as SQL server!

    Bernie

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center