Hi community,

i created a new database from scratch called XMod (its going to be used with Xmod Pro) and i need to add a connection string to the webconfig file, i created the xmod database in the same place where the dot net nuke database is located and added the following code to the web.config file:

 <add name="SiteSqlServer2" connectionString="Data Source=.\SQLExpress;AttachDbFilename=|DataDirectory|Xmod.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />

AND

   <add key="SiteSqlServer2" value="Data Source=.\SQLExpress;AttachDbFilename=|DataDirectory|Xmod.mdf;Integrated Security=True;User Instance=True" />

Please can you help me with this? because it seems when i call the dotnetnuke database from xmod (by refering to the connection string name: SiteSqlServer) it works but when i refer to SiteSqlServer2 it does not work, any help pls?

Kind Regards,

Chris Scicluna

Hey thanks for the reply, i tried removing the second one but still giving the same error. Basically xmod pro works as follows.

You create a database and a form in xmod pro and then use the web.config to make a connection.

In the form you add the following tag:

<submitcommand connectionstring="[[ConnectionString:SiteSqlServer2]] " commandtext="INSERT INTO HWS_News_Test (FieldOne, FieldTwo, FieldThree) VALUES (@FieldOne, @FieldTwo, @FieldThree)" />
 

when i use the SiteSqlServer it works but when i use the SiteSqlServer2 it does not work, dont know why since both of the databases are in the same location :( maybe there are some permisions i need to setup for the database to communicate with other parties? Im lost..

Kind Regards,

Chris Scicluna