Is there an appropriate tag in updating the web.config file when PostgreSQL8.1 is used instead of SQL Server 2000? I've searched the internet and looked for tutorials/pages in configuring web.config but all are using Microsoft SQL Server.
Here's the list of steps I did.
1. Using pgAdminIII in PostgreSQL 8.1, I created a new login role namely "dnnuser" and a new database namely "dotnetnuke" - owned by dnnuser. I've updated the web.config and under the <appsettings>, the information I used is
<add key="SiteSqlServer" value="Server=127.0.0.1;Database=dotnetnuke;uid=dnnuser;pwd=password;" />
I am not really sure if there's a SitePostgreSQL as the key name but i still used the default value (SiteSqlServer). When I browsed http://localhost/dotnetnuke, I encountered an error as shown below:
Error Installing DotNetNuke
Current Assembly Version: 03.02.02
ERROR: Could not connect to database specified in connectionString for SqlDataProvider
So i did another research and verified that i needed to update the databaseOwner to <data defaultProvider="SqlDataProvider"> tag and replaced "dbo" by "dnnuser". The next error I've encountered is
DotNetNuke Upgrade Error
The Assembly Version ( [ASSEMBLYVERSION] ) does not match the Database Version ( [DATABASEVERSION] )
ERROR: Could not connect to database.
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Could you please help?