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.
  • 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