Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. General Programming
  3. C / C++ / MFC
  4. MSDE ???

MSDE ???

Scheduled Pinned Locked Moved C / C++ / MFC
databasecsharpc++sql-servervisual-studio
9 Posts 5 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • L Offline
    L Offline
    Lost User
    wrote on last edited by
    #1

    Created an application that uses SQL Server 7.0 to store data. I now want to place it on a clean machine for testing purposes, therefore SQL Server 7.0 will not be on this machine. I believe that what I need to install is MSDE to allow the application to interact with the database files. Is this correct? Where can I download MSDE from? Searches keep pointing me to MSDE for VC++ or Visual Studio, not exactly what I want. Michael Martin Pegasystems Pty Ltd Australia martm@pegasystems.com +61 413-004-018

    C B S N 4 Replies Last reply
    0
    • L Lost User

      Created an application that uses SQL Server 7.0 to store data. I now want to place it on a clean machine for testing purposes, therefore SQL Server 7.0 will not be on this machine. I believe that what I need to install is MSDE to allow the application to interact with the database files. Is this correct? Where can I download MSDE from? Searches keep pointing me to MSDE for VC++ or Visual Studio, not exactly what I want. Michael Martin Pegasystems Pty Ltd Australia martm@pegasystems.com +61 413-004-018

      C Offline
      C Offline
      Christian Graus
      wrote on last edited by
      #2

      What is MSDE ? I thought you'd need MDAC ? Christian Secrets of a happy marriage #27: Never go to bed if you are mad at each other. It's more fun to stay up and fight.

      L 1 Reply Last reply
      0
      • C Christian Graus

        What is MSDE ? I thought you'd need MDAC ? Christian Secrets of a happy marriage #27: Never go to bed if you are mad at each other. It's more fun to stay up and fight.

        L Offline
        L Offline
        Lost User
        wrote on last edited by
        #3

        MDAC - Microsoft Data Access Components MSDE - Microsoft Data Engine MDAC gives you ODBC and other database drivers while MSDE is more of an application to access the database files. I don't believe that the drivers provided by MDAC and ODBC alone can access an SQL Server database. All of this could be completely wrong and am hoping someone with the correct information would give me a shove in the right direction as to what I need (if not MSDE) and where to get it. Michael Martin Pegasystems Pty Ltd Australia martm@pegasystems.com +61 413-004-018

        C 1 Reply Last reply
        0
        • L Lost User

          MDAC - Microsoft Data Access Components MSDE - Microsoft Data Engine MDAC gives you ODBC and other database drivers while MSDE is more of an application to access the database files. I don't believe that the drivers provided by MDAC and ODBC alone can access an SQL Server database. All of this could be completely wrong and am hoping someone with the correct information would give me a shove in the right direction as to what I need (if not MSDE) and where to get it. Michael Martin Pegasystems Pty Ltd Australia martm@pegasystems.com +61 413-004-018

          C Offline
          C Offline
          Christian Graus
          wrote on last edited by
          #4

          My understanding given that I am learning ADO is that ADO can access an SQL Server database, and you need to install MDAC for the latest version of ADO. I'm not sure this is right, and if it is how if affects your situation. I'm using boring old Jet myself, until I figure out how to use ADOX to create a database file. Christian Secrets of a happy marriage #27: Never go to bed if you are mad at each other. It's more fun to stay up and fight.

          L 1 Reply Last reply
          0
          • C Christian Graus

            My understanding given that I am learning ADO is that ADO can access an SQL Server database, and you need to install MDAC for the latest version of ADO. I'm not sure this is right, and if it is how if affects your situation. I'm using boring old Jet myself, until I figure out how to use ADOX to create a database file. Christian Secrets of a happy marriage #27: Never go to bed if you are mad at each other. It's more fun to stay up and fight.

            L Offline
            L Offline
            Lost User
            wrote on last edited by
            #5

            Utilising Dave Merner's SQLDirect (ODBC wrapper class I think) myself, as I have used it a couple of years ago and this is a side project that was not meant to take much time I stuck with what I knew instead of looking for the best option. Will have to test this, maybe I don't need MSDE, ODBC DSN is used by SQLDirect so maybe MDAC is enough, will test over the weekend. Michael Martin Pegasystems Pty Ltd Australia martm@pegasystems.com +61 413-004-018

            L 1 Reply Last reply
            0
            • L Lost User

              Created an application that uses SQL Server 7.0 to store data. I now want to place it on a clean machine for testing purposes, therefore SQL Server 7.0 will not be on this machine. I believe that what I need to install is MSDE to allow the application to interact with the database files. Is this correct? Where can I download MSDE from? Searches keep pointing me to MSDE for VC++ or Visual Studio, not exactly what I want. Michael Martin Pegasystems Pty Ltd Australia martm@pegasystems.com +61 413-004-018

              B Offline
              B Offline
              Bob Groves
              wrote on last edited by
              #6

              I think that is exactly what you want. The CD comes with VStudio 6 or you can download at http://msdn.microsoft.com/vstudio/msde/default.asp. You will not get any of the tools, i.e. Query Analyser or Emterprise manager, just the DB engine. Cheers, Bob.

              1 Reply Last reply
              0
              • L Lost User

                Utilising Dave Merner's SQLDirect (ODBC wrapper class I think) myself, as I have used it a couple of years ago and this is a side project that was not meant to take much time I stuck with what I knew instead of looking for the best option. Will have to test this, maybe I don't need MSDE, ODBC DSN is used by SQLDirect so maybe MDAC is enough, will test over the weekend. Michael Martin Pegasystems Pty Ltd Australia martm@pegasystems.com +61 413-004-018

                L Offline
                L Offline
                Lost User
                wrote on last edited by
                #7

                MSDE ist the SQL Server ENGINE for free distribution. With MDAC or ODBC you can't access the SQL Server database files directly, you always need an SQL Server engine. This can be the MSDE or the full product "SQL Server 7" / "SQL Server 2000". The engine runs as NT service on the database server. Volker

                1 Reply Last reply
                0
                • L Lost User

                  Created an application that uses SQL Server 7.0 to store data. I now want to place it on a clean machine for testing purposes, therefore SQL Server 7.0 will not be on this machine. I believe that what I need to install is MSDE to allow the application to interact with the database files. Is this correct? Where can I download MSDE from? Searches keep pointing me to MSDE for VC++ or Visual Studio, not exactly what I want. Michael Martin Pegasystems Pty Ltd Australia martm@pegasystems.com +61 413-004-018

                  S Offline
                  S Offline
                  Steen Krogsgaard
                  wrote on last edited by
                  #8

                  What did you create your appliation with? If you did it with MS Office Developer edition or VS pro/enterprise ed. you can freely distribute MSDE (or MSDE 2000). Download MSDE from MS site at http://msdn.microsoft.com/vstudio/msde/download.asp (this is MSDE 1.0, I'm not sure about MSDE2000. But if you developed for SS 7.0 then MSDE 1.0 should do just fine. Be sure to apply the service packs (SQL Server 7.0 sps) For more info on integration into app and licensing, see http://www.microsoft.com/sql/techinfo/development/2000/MSDEintegration.asp or http://www.microsoft.com/SQL/techinfo/development/2000/MSDE2000.asp hope this helps Steen

                  1 Reply Last reply
                  0
                  • L Lost User

                    Created an application that uses SQL Server 7.0 to store data. I now want to place it on a clean machine for testing purposes, therefore SQL Server 7.0 will not be on this machine. I believe that what I need to install is MSDE to allow the application to interact with the database files. Is this correct? Where can I download MSDE from? Searches keep pointing me to MSDE for VC++ or Visual Studio, not exactly what I want. Michael Martin Pegasystems Pty Ltd Australia martm@pegasystems.com +61 413-004-018

                    N Offline
                    N Offline
                    Not Active
                    wrote on last edited by
                    #9

                    That is what you need.

                    1 Reply Last reply
                    0
                    Reply
                    • Reply as topic
                    Log in to reply
                    • Oldest to Newest
                    • Newest to Oldest
                    • Most Votes


                    • Login

                    • Don't have an account? Register

                    • Login or register to search.
                    • First post
                      Last post
                    0
                    • Categories
                    • Recent
                    • Tags
                    • Popular
                    • World
                    • Users
                    • Groups