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
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
These Forums are dedicated to the discussion of DNN Platform.
For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:
Awesome! Simply post in the forums using the link below and we'll get you started.