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
CODE PROJECT For Those Who Code
  • Home
  • Articles
  • FAQ
Community
  1. Home
  2. General Programming
  3. C#
  4. joining the server with my application

joining the server with my application

Scheduled Pinned Locked Moved C#
csharpdatabasesql-serversysadminlearning
12 Posts 4 Posters 1 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.
  • C Colin Angus Mackay

    If you want to embed the database in your setup program then SQL Server isn't going to work for you. As the name suggests it is a server product. There is MSDE which can be distributed with your application but I think it is still a separate install. You might want to consider something more along the lines of Vista DB[^] ColinMackay.net "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius "If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

    E Offline
    E Offline
    emran834
    wrote on last edited by
    #3

    [Message Deleted]

    C 1 Reply Last reply
    0
    • E emran834

      [Message Deleted]

      C Offline
      C Offline
      Colin Angus Mackay
      wrote on last edited by
      #4

      emran834 wrote:

      Is that you meant My application will be running stand alone in the user's computer or The user must have SQL server installed !!

      The latter, SQL Server must be installed.

      emran834 wrote:

      Whenever i build my solution, the RELEASE Folder is Stand Alone and My .mdf file is inside the RELEASE Folder which made sense to me that it will run stand alone. Ain't I right ?

      No, that isn't right. The database file is useless without SQL Server to open it and server data from it and allow changes to it. In your application you never access the file directly. SQL Server is the only thing that accesses the file. Your application accesses SQL Server not the file. ColinMackay.net "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius "If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

      M E 2 Replies Last reply
      0
      • C Colin Angus Mackay

        emran834 wrote:

        Is that you meant My application will be running stand alone in the user's computer or The user must have SQL server installed !!

        The latter, SQL Server must be installed.

        emran834 wrote:

        Whenever i build my solution, the RELEASE Folder is Stand Alone and My .mdf file is inside the RELEASE Folder which made sense to me that it will run stand alone. Ain't I right ?

        No, that isn't right. The database file is useless without SQL Server to open it and server data from it and allow changes to it. In your application you never access the file directly. SQL Server is the only thing that accesses the file. Your application accesses SQL Server not the file. ColinMackay.net "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius "If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

        M Offline
        M Offline
        moonangel_bio
        wrote on last edited by
        #5

        i don't think that user must have SQL in his PC. i need a way to let the project stand alone without SQL am i obvious !!!? thanx

        C D 2 Replies Last reply
        0
        • M moonangel_bio

          i don't think that user must have SQL in his PC. i need a way to let the project stand alone without SQL am i obvious !!!? thanx

          C Offline
          C Offline
          Colin Angus Mackay
          wrote on last edited by
          #6

          moonangel_bio wrote:

          i don't think that user must have SQL in his PC.

          Why do you think that? If you are deploying SQL Server files to a PC then you musr have SQL Server installed on that PC in order to use the files. You cannot have SQL Server running on another PC accessing its files across the network. The files MUST be local to the installation of SQL Server.

          moonangel_bio wrote:

          i need a way to let the project stand alone without SQL

          Then don't use SQL Server.

          moonangel_bio wrote:

          am i obvious !!!?

          :confused: That doesn't make sense. ColinMackay.net "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius "If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

          1 Reply Last reply
          0
          • M moonangel_bio

            i don't think that user must have SQL in his PC. i need a way to let the project stand alone without SQL am i obvious !!!? thanx

            D Offline
            D Offline
            Dave Kreskowiak
            wrote on last edited by
            #7

            No matter what you use, you can't embed the database in the .EXE. A running .EXE cannot be modified. At the very least, you'll need the .EXE and a database file. To get a working database that doesn't need a server, you'll have to use a file-based DB like Access (Yuk!). Your SQL Server implementation is useless without an installed SQL Server that the customer can use. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

            1 Reply Last reply
            0
            • C Colin Angus Mackay

              emran834 wrote:

              Is that you meant My application will be running stand alone in the user's computer or The user must have SQL server installed !!

              The latter, SQL Server must be installed.

              emran834 wrote:

              Whenever i build my solution, the RELEASE Folder is Stand Alone and My .mdf file is inside the RELEASE Folder which made sense to me that it will run stand alone. Ain't I right ?

              No, that isn't right. The database file is useless without SQL Server to open it and server data from it and allow changes to it. In your application you never access the file directly. SQL Server is the only thing that accesses the file. Your application accesses SQL Server not the file. ColinMackay.net "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius "If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

              E Offline
              E Offline
              emran834
              wrote on last edited by
              #8

              O my god ! I am developing my Application with SQL Database, thinking that it will be stand alone distributable. Now If I change my Datbase to OLEDB ( Microsoft Access ) ? then will it be stand alone ? I read your previous posting where you said that if I use Access then it will be ok. I am thinking If I just change the database file and Connection String, will be all code be working ? And I hope the SAME SQL will will be working just Parameters sign ( @ or ? )is different, right ? -- modified at 16:35 Sunday 5th February, 2006

              C 1 Reply Last reply
              0
              • E emran834

                O my god ! I am developing my Application with SQL Database, thinking that it will be stand alone distributable. Now If I change my Datbase to OLEDB ( Microsoft Access ) ? then will it be stand alone ? I read your previous posting where you said that if I use Access then it will be ok. I am thinking If I just change the database file and Connection String, will be all code be working ? And I hope the SAME SQL will will be working just Parameters sign ( @ or ? )is different, right ? -- modified at 16:35 Sunday 5th February, 2006

                C Offline
                C Offline
                Colin Angus Mackay
                wrote on last edited by
                #9

                I don't know much about Access. It used to be (and this is getting on for 10 years ago) that you'd need some additional files installed to use the Access database through ODBC, but I really don't know about .NET. It may be possible. The SQL is similar but there are differences. You've already spotted the parameter one. Access doesn't support Stored Procedures, so if you have any of them they will have to be re-written. ColinMackay.net "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius "If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

                E 2 Replies Last reply
                0
                • C Colin Angus Mackay

                  I don't know much about Access. It used to be (and this is getting on for 10 years ago) that you'd need some additional files installed to use the Access database through ODBC, but I really don't know about .NET. It may be possible. The SQL is similar but there are differences. You've already spotted the parameter one. Access doesn't support Stored Procedures, so if you have any of them they will have to be re-written. ColinMackay.net "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius "If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

                  E Offline
                  E Offline
                  emran834
                  wrote on last edited by
                  #10

                  Hi colin, thanks for your time. yes, ADO .NET supports Access and C# Express can help me to use the Access same as SQL. But I have done some research on google and Realized that, If I started with Access, that was a different story, but at the middle of this time of my application development, it will be very hard to go through all Conversion. I was thinking how can i manage SQL database to make Stand Alone. One thing I can do, I can put the SQL Express executable in my installer file so that whenver user install my software, my installer will install SQL server from CD. Or I can learn about MSDE, I got a nice article about MSDE from Code Project, http://www.codeproject.com/cs/database/msdeinstaller.asp[^] Can you tell me which one is efficient solution !! Regards, Emran

                  1 Reply Last reply
                  0
                  • C Colin Angus Mackay

                    I don't know much about Access. It used to be (and this is getting on for 10 years ago) that you'd need some additional files installed to use the Access database through ODBC, but I really don't know about .NET. It may be possible. The SQL is similar but there are differences. You've already spotted the parameter one. Access doesn't support Stored Procedures, so if you have any of them they will have to be re-written. ColinMackay.net "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius "If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

                    E Offline
                    E Offline
                    emran834
                    wrote on last edited by
                    #11

                    Hi, I have checked the link VISTA DB that you provided in the last posting. Excellent Solution exactly what I wanted. thanks for the information. Have you used that ?

                    C 1 Reply Last reply
                    0
                    • E emran834

                      Hi, I have checked the link VISTA DB that you provided in the last posting. Excellent Solution exactly what I wanted. thanks for the information. Have you used that ?

                      C Offline
                      C Offline
                      Colin Angus Mackay
                      wrote on last edited by
                      #12

                      I'vw played with it a little, but I've not found a project that I'd use it on - I work mostly with large enterprise applications where the database is arround a Terrabyte in size. ColinMackay.net "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius "If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

                      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