I'm getting an "Unknown connection option: user" error when trying to
The connection string block in the dataConfiguration.config file looks like:
<instances>
<instance name="Instance1" type="Sql Server"
connectionString="Connect_String1" />
</instances>
<connectionStrings>
<connectionString name="Connect_String1">
<parameters>
<parameter name="database" value="databasename"
isSensitive="false" />
<parameter name="user" value="xxx" isSensitive="false" />
<parameter name="password" value="yyy" isSensitive="false" />
<parameter name="server" value="server.domain.com"
isSensitive="false" />
</parameters>
</connectionString>
</connectionStrings>
The code that causes the error is:
db = DatabaseFactory.CreateDatabase("Instance1");
A weird thing is that this (code and config file) appear to work fine from
my development machine, but fails on the server hosting the webservice. If
I point my consuming application to the server, it fails with the same
error, but I can't debug it there. Any pointers on debugging this would be
appreciated.
--
Clint