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 Offline
    U Offline
    User3490
    wrote on last edited by
    #1

    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 M 2 Replies 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

      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