• Login
  • Register

DNN Forums

Ask questions about your website to get help learning DNN and help resolve issues.

PostGre Database is not being accessed from sql pad

You are not authorized to post a reply.
Sort:


New Member


Posts:7
New Member

    I have added connection string to connect PostGre SQL Database it is working in module but not able to connect in SQL Pad (DNN Query)

    Following is the connection string which i have used to connect Post Gre SQL:-

    Please let me know if any correction required and do needful



    Veteran Member


    Posts:1164
    Veteran Member

      I'm not sure what you mean by SQL Pad.

      If you are referring the the SQL Console (Host/SQL in earlier versions of DNN), I don't think that is set up to use an external database.

      There may be other modules that can, including the DNN Reports module, https://github.com/DNNCommunity/DNN.Reports
      Joe Craig
      DNN MVP
      Patapsco Research Group


      Veteran Member


      Posts:466
      Veteran Member

        Please note: these forums are about DNN Platform software only, this is not a general forum about Microsoft SQL Server or other SQL products.


        Veteran Member


        Posts:357
        Veteran Member

          I think that "SQL Pad" is the SQL Console extension in the Persona Bar.

          I haven't recently tried to use any non-SQL Server databases in the console. In theory, they should work though, if the connection string and underlying data access components are installed. For example, if you have a custom extension successfully displaying data from your PostGre database, then the SQL Console should work as well.
          Will Strohl

          Upendo Ventures DNN experts since 2003
          Official provider of the DNN-based E-Commerce w/ Hotcakes Commerce Cloud and SLA support


          Veteran Member


          Posts:466
          Veteran Member

            I am pretty sure that PersonaBar > Settings > SQL does not Support SQL dialects for other databases, even if you are using proper database Driver and Connection string - the built in Syntax checker is specific for SQL Server AFAIK.


            New Member


            Posts:7
            New Member

              Yes, I meant, the Host -> SQL page from where you can run the queries. 

              When I add a connection string in web.config, I do find it in the dropdown box to select. that works well with exernal databased too, as long as the external database id MS SQL, but if the external database is non-MS-SQL then it does not work. My guess is that it does not recognise the provider attribute of connection string and uses sqlclient only.

              If I use the same external database via code (that is create a connection object manually) then it works.

              I think this may be considered as a bug, and shall be taken care in next version



              Veteran Member


              Posts:466
              Veteran Member

                DNN is using internally .Net methods, which are MS SQL specific, i.e. the only simple fix would be checking the connection string to contain a supported provider.


                New Member


                Posts:7
                New Member

                  We are providing the provider name in the connection string, have a var the SQL console overrides that and uses only the SQL client
                  You are not authorized to post a reply.

                  These Forums are dedicated to discussion of DNN Platform.

                  For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

                  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
                  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
                  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
                  4. No Flaming or Trolling.
                  5. No Profanity, Racism, or Prejudice.
                  6. Site Moderators have the final word on approving / removing a thread or post or comment.
                  7. English language posting only, please.

                  Would you like to help us?

                  Awesome! Simply post in the forums using the link below and we'll get you started.

                  Get Involved