Thread: [BUGS] aspnet postgresql connection setting
Dear Support Team,
Our website is produced by using aspnet + mssql, and then we would like to move database from mssql to postgresql. But about the database connection setting in web.config, we are not sure how to modify the setting as listed as below:
<add key="CconString" value="Server='7a0642076\SQLEXPRESS';uid='sa';pwd='water';database='DB14017'"/>
<add key="VBconString" value="Server=7a0642076\SQLEXPRESS;uid=sa;pwd=water;database=DB14017"/>
<add key="SMTPServer" value="mail.ehosting.com.tw"/>
<add key="SMTPSend" value="zenki@creatop.com.tw"/>
<add key="SystemName" value="SmartAdmin"/>
<add key="AbsPath" value="/"/>
<add key="TrackSaveTime" value="/3/"/>
<add key="EditUploadPath" value="\\nas2\webhost\17\14017\upfiles\EditUpload\"/>
<add key="UploadPath" value="\\nas2\webhost\17\14017\upfiles\ADUpload\"/>
<add key="CopyRight" value="http://www.creatop.com.tw/"/>
<add key="sKey" value="qJzGEh6hESZDVJeCnFPGuxz3"/>
<add key="sIV" value="qcD="/>
<add key="MainWeb" value="http://www.fengtay.com/"/>
Would it be possible to guidance the information which how to modify postgresql in web.config? Thanks a lot.
Best Regards, Anderson Hsu
On 3/15/2017 10:18 PM, anderson.hsu@fengtay.com wrote:
Our website is produced by using aspnet + mssql, and then we would like to move database from mssql to postgresql. But about the database connection setting in web.config, we are not sure how to modify the setting as listed as below:<add key="CconString" value="Server='7a0642076\SQLEXPRESS';uid='sa';pwd='water';database='DB14017'"/><add key="VBconString" value="Server=7a0642076\SQLEXPRESS;uid=sa;pwd=water;database=DB14017"/>
.....
that is all Microsoft SQL Server specific, somewhere else you must be connecting to the mssql ado driver.
you need to install and use NPGSQL, which implements a .NET data provider for Postgresql. I don't program in that world, but here's home page for it...
http://www.npgsql.org/doc/index.html
-- john r pierce, recycling bits in santa cruz