Configure web config - Administration and Configuration

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

Home All Forums

1
2
3
4
5

1/1/2008 8:54 PM

Rasta

Joined: 5/25/2007

Posts: 2

Configure web config

Hi

I have been given all this information from my web host. Where does this information go within the web config?

Example ASP Code using SQL OLE DB:

' SQL OLE DB connection string using DBO login
strConnString = "Provider=sqloledb; Network Library=DBMSSOCN; Data Source=wic009q.server-sql.com\SQL4,4659; Initial

Catalog=xxxxx_1; User ID=xxxxxxx_dbo; Password=xxxxxxxx;"
' SQL OLE DB connection string using Normal login
strConnString = "Provider=sqloledb; Network Library=DBMSSOCN; Data Source=wic009q.server-sql.com\SQL4,4659; Initial

Catalog=xxxxx_1; User ID=xxxxxxx_1; Password=xxxxxx;"

Set DbConn = Server.CreateObject("ADODB.Connection")
DbConn.open(strConnString)
' Insert Query/Output code here
DbConn.close
set DbConn = nothing

Thanks in advance

1/2/2008 4:21 AM

Sebastian Leupold

www.dnnwerk.de
Joined: 3/8/2004

Posts: 46212

Re: Configure web config

which sql server are you using, default DotNetNuke support Microsoft SQL Server (2000, 2005 or Express) only.

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

1/3/2008 5:00 AM

Rasta

Joined: 5/25/2007

Posts: 2

Re: Configure web config

sql 2000

1/3/2008 6:07 AM

Sebastian Leupold

www.dnnwerk.de
Joined: 3/8/2004

Posts: 46212

Re: Configure web config

line 21 ff should look like this:

< connectionStrings >
< add name ="SiteSqlServer" connectionString="Data Source=wic009q.server-sql.com\SQL4,4659; Initial Catalog=xxxxx_1; User ID=xxxxxxx_1; Password=xxxxxx" ProviderName="System.Data.SqlClient" / >
< /connection Strings >
< appSettings >
< add key="SiteSqlServer" value="Data Source=wic009q.server-sql.com\SQL4,4659; Initial Catalog=xxxxx_1; User ID=xxxxxxx_1; Password=xxxxxx" / >
< add key="InstallTemplate" ....

Omit spaces after < inserted for the editor here.

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

Page 1 of 1

These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Site Moderators have the final word on approving / removing a thread or post or comment.
English language posting only, please.

Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

DNN Corp. (DotNetNuke)