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#
  4. C# Multiple connectionstring

C# Multiple connectionstring

Scheduled Pinned Locked Moved C#
csharpdatabasehelp
12 Posts 6 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.
  • U User3490

    can i have 2 connection string and two connections in 2 different databases because i have an error that say no database specified or IN clause

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

    zebra88 wrote:

    can i have 2 connection string and two connections

    Yes, yes you can

    U 1 Reply Last reply
    0
    • L Lost User

      zebra88 wrote:

      can i have 2 connection string and two connections

      Yes, yes you can

      U Offline
      U Offline
      User3490
      wrote on last edited by
      #3

      why i have the error no database specified in connection string or in clause i make the same steps that i make with my previous connection with access db and connection string

      L 1 Reply Last reply
      0
      • U User3490

        why i have the error no database specified in connection string or in clause i make the same steps that i make with my previous connection with access db and connection string

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

        zebra88 wrote:

        why i have the error

        I would have no idea why you are getting that error. Through some strange circumstance, I cannot see your code, your project or read your mind and you have not provided any relevant information that would allow anyone to know what it is that you are trying to do and what you have done.

        L 1 Reply Last reply
        0
        • L Lost User

          zebra88 wrote:

          why i have the error

          I would have no idea why you are getting that error. Through some strange circumstance, I cannot see your code, your project or read your mind and you have not provided any relevant information that would allow anyone to know what it is that you are trying to do and what you have done.

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

          It's a guessing game[^].

          Use the best guess

          L 1 Reply Last reply
          0
          • U User3490

            can i have 2 connection string and two connections in 2 different databases because i have an error that say no database specified or IN clause

            M Offline
            M Offline
            Manish Kumar123456
            wrote on last edited by
            #6

            no we can not use multiple string conection to connect multiple database in .net if we try to do this we have find a problem cross connection problem

            U M D 3 Replies Last reply
            0
            • M Manish Kumar123456

              no we can not use multiple string conection to connect multiple database in .net if we try to do this we have find a problem cross connection problem

              U Offline
              U Offline
              User3490
              wrote on last edited by
              #7

              so how can i get data from access databases that has the same fields but with different content and i want to get data that have the same reference year from them every time i make import a file to a c# program without locally connect the database so with this way i have always updated data because i see what i want without have in mind the old data that has every access file that i use. i want only the records with the same reference year e.x with year 2013 how i manage this? one solution i find now is to make restore the access db file so i have always updates data :)

              1 Reply Last reply
              0
              • L Lost User

                It's a guessing game[^].

                Use the best guess

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

                Richard MacCutchan wrote:

                It's a guessing game

                Ah, thanks.... I guess I will stop feeding him.

                K 1 Reply Last reply
                0
                • M Manish Kumar123456

                  no we can not use multiple string conection to connect multiple database in .net if we try to do this we have find a problem cross connection problem

                  M Offline
                  M Offline
                  Mycroft Holmes
                  wrote on last edited by
                  #9

                  Wat, you are wrong. You can have as many connection to as many databases as you need. Downvote required!

                  Never underestimate the power of human stupidity RAH

                  1 Reply Last reply
                  0
                  • M Manish Kumar123456

                    no we can not use multiple string conection to connect multiple database in .net if we try to do this we have find a problem cross connection problem

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

                    Maybe YOU have a problem with doing this, but the rest of use professional developers don't. YES, you can have multiple connection strings in a .NET app and use them all at the same time. What you said was completely wrong on every level.

                    A guide to posting questions on CodeProject[^]
                    Dave Kreskowiak

                    1 Reply Last reply
                    0
                    • L Lost User

                      Richard MacCutchan wrote:

                      It's a guessing game

                      Ah, thanks.... I guess I will stop feeding him.

                      K Offline
                      K Offline
                      karthiksruby 123
                      wrote on last edited by
                      #11

                      Surely its possible to connect multiple database in same project/Single database in multiple projects and multiple databases in multiple projects. Your issue is some thing else. I googled it and i got a page like this. http://office.microsoft.com/en-in/access-help/HV080760652.aspx

                      L 1 Reply Last reply
                      0
                      • K karthiksruby 123

                        Surely its possible to connect multiple database in same project/Single database in multiple projects and multiple databases in multiple projects. Your issue is some thing else. I googled it and i got a page like this. http://office.microsoft.com/en-in/access-help/HV080760652.aspx

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

                        karthiksruby@123 wrote:

                        Your issue

                        What issue is it that you are referring to? I am not having any issues connecting to any database.

                        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