Hello,

i wanted to ask if somebody can give me a small guide on how to create 2 ConnectionStrings. Must i only edit the web.config or must i also edit something in the constructor of the sqldataprovider class ???

all i changed in my web.config was:

<add name="SiteSqlServer"
       connectionString="Server=MYCOMPUTER\SQLEXPRESS;   Database=MYDBone;   uid=MYUSERone;   pwd=MYPWone;"
      providerName="System.Data.SqlClient"/>
   
    <add name="SiteSqlServer2"
       connectionString="Server=MYCOMPUTER\SQLEXPRESS;   Database=MYDBtwo;   uid=MYUSERtwo;   pwd=MYPWtwo;"
      providerName="System.Data.SqlClient"/>

and

<add key="SiteSqlServer" value="Server=MYCOMPUTER\SQLEXPRESS;    Database=MYDBone;   uid=MYUSERone;   pwd=MYPWone;"/>
    <add key="SiteSqlServer2" value="Server=MYCOMPUTER\SQLEXPRESS;    Database=MYDBtwo;   uid=MYUSERtwo;   pwd=MYPWtwo;"/>

how exactly can i get now the 2nd connection string in my CODE

my function is f.e.

 Public Overrides Function EplanShowAllBU() As System.Data.IDataReader
            Return CType(SqlHelper.ExecuteReader(ConnectionString, "EPlanShowAllBU"), IDataReader)
        End Function

i have no clue how the strings from web.config come down to the code ...

You should be able to do it that way, but you could also do it with

GetConnectionString(GetDefaultProvider("data").Attributes("connectionStringName"))

And supply the name of your second ConnectionString. If you open the source solution for DNN you can find the Library\components\Shared\.Config.VB file, in which DNN pulls the standard Connection string out.