Enterprise Library- Data configuration Block

Patrick

I am using the Microsoft enterprise Library (June 2005) with .NET Framework
1.1 on a Windows 2003 IIS6 web server.

with an ASP.NET 1.1 application, I have a dataConfigurati on.config as listed
at the end of this post(configured with the Enterprise Library Configuration
Tool)

I have this file in a "production " environment and what I found is that if I
use the SQL Server 2000's Enterprise Manager's Current Activity viewer under
the Management node on the DEV and PRDO SQL Server, I could detect connection
from .Net SqlClient Data Provider from the IIS Host. What is going on?

I want to leave the 2 settings there (if possible) and change 1 setting for
Prod IIS to point to prod DB.

Help!

<?xml version="1.0" encoding="utf-8"?>
<dataConfigurat ion>
<xmlSerializerS ection
type="Microsoft .Practices.Ente rpriseLibrary.D ata.Configurati on.DatabaseSett ings,
Microsoft.Pract ices.Enterprise Library.Data, Version=1.1.0.0 , Culture=neutral ,
PublicKeyToken= null">
<enterpriseLibr ary.databaseSet tings
xmlns:xsd="http ://www.w3.org/2001/XMLSchema"
xmlns:xsi="http ://www.w3.org/2001/XMLSchema-instance"
defaultInstance ="appDev"
xmlns="http://www.microsoft.c om/practices/enterpriselibra ry/08-31-2004/data">
<databaseType s>
<databaseType name="Sql Server"
type="Microsoft .Practices.Ente rpriseLibrary.D ata.Sql.SqlData base,
Microsoft.Pract ices.Enterprise Library.Data, Version=1.0.0.0 , Culture=neutral ,
PublicKeyToken= null" />
</databaseTypes>
<instances>
<instance name="appDev" type="Sql Server" connectionStrin g="DEV" />
<instance name="appProd" type="Sql Server" connectionStrin g="PROD" />
</instances>
<connectionStri ngs>
<connectionStri ng name="DEV">
<parameters>
<parameter name="database" value="appDB" isSensitive="fa lse" />
<parameter name="password" value="pppasswo rd" isSensitive="tr ue"
/>
<parameter name="server" value="ProdServ er" isSensitive="fa lse" />
<parameter name="uid" value="uid" isSensitive="fa lse" />
</parameters>
</connectionStrin g>
<connectionStri ng name="PROD">
<parameters>
<parameter name="database" value="appDB" isSensitive="fa lse" />
<parameter name="password" value="pppasswo rd" isSensitive="tr ue"
/>
<parameter name="server" value="prodServ er" isSensitive="fa lse" />
<parameter name="uid" value="uid" isSensitive="fa lse" />
</parameters>
</connectionStrin g>
</connectionStrin gs>
</enterpriseLibra ry.databaseSett ings>
</xmlSerializerSe ction>
</dataConfigurati on>

May 10 '06 #1

Subscribe Reply

4797

Altaf Al-Amin Najwani

change defaultInstance ="appDev" to "appProd"

"Patrick" wrote:

I am using the Microsoft enterprise Library (June 2005) with .NET Framework
1.1 on a Windows 2003 IIS6 web server.

with an ASP.NET 1.1 application, I have a dataConfigurati on.config as listed
at the end of this post(configured with the Enterprise Library Configuration
Tool)

I have this file in a "production " environment and what I found is that if I
use the SQL Server 2000's Enterprise Manager's Current Activity viewer under
the Management node on the DEV and PRDO SQL Server, I could detect connection
from .Net SqlClient Data Provider from the IIS Host. What is going on?

I want to leave the 2 settings there (if possible) and change 1 setting for
Prod IIS to point to prod DB.

Help!

<?xml version="1.0" encoding="utf-8"?>
<dataConfigurat ion>
<xmlSerializerS ection
type="Microsoft .Practices.Ente rpriseLibrary.D ata.Configurati on.DatabaseSett ings,
Microsoft.Pract ices.Enterprise Library.Data, Version=1.1.0.0 , Culture=neutral ,
PublicKeyToken= null">
<enterpriseLibr ary.databaseSet tings
xmlns:xsd="http ://www.w3.org/2001/XMLSchema"
xmlns:xsi="http ://www.w3.org/2001/XMLSchema-instance"
defaultInstance ="appDev"
xmlns="http://www.microsoft.c om/practices/enterpriselibra ry/08-31-2004/data">
<databaseType s>
<databaseType name="Sql Server"
type="Microsoft .Practices.Ente rpriseLibrary.D ata.Sql.SqlData base,
Microsoft.Pract ices.Enterprise Library.Data, Version=1.0.0.0 , Culture=neutral ,
PublicKeyToken= null" />
</databaseTypes>
<instances>
<instance name="appDev" type="Sql Server" connectionStrin g="DEV" />
<instance name="appProd" type="Sql Server" connectionStrin g="PROD" />
</instances>
<connectionStri ngs>
<connectionStri ng name="DEV">
<parameters>
<parameter name="database" value="appDB" isSensitive="fa lse" />
<parameter name="password" value="pppasswo rd" isSensitive="tr ue"
/>
<parameter name="server" value="ProdServ er" isSensitive="fa lse" />
<parameter name="uid" value="uid" isSensitive="fa lse" />
</parameters>
</connectionStrin g>
<connectionStri ng name="PROD">
<parameters>
<parameter name="database" value="appDB" isSensitive="fa lse" />
<parameter name="password" value="pppasswo rd" isSensitive="tr ue"
/>
<parameter name="server" value="prodServ er" isSensitive="fa lse" />
<parameter name="uid" value="uid" isSensitive="fa lse" />
</parameters>
</connectionStrin g>
</connectionStrin gs>
</enterpriseLibra ry.databaseSett ings>
</xmlSerializerSe ction>
</dataConfigurati on>

May 10 '06 #2

Matt Noonan

Patrick wrote:

I am using the Microsoft enterprise Library (June 2005) with .NET
Framework
1.1 on a Windows 2003 IIS6 web server.

with an ASP.NET 1.1 application, I have a dataConfigurati on.config as
listed at the end of this post(configured with the Enterprise Library
Configuration Tool)

I have this file in a "production " environment and what I found is
that if I use the SQL Server 2000's Enterprise Manager's Current
Activity viewer under the Management node on the DEV and PRDO SQL
Server, I could detect connection from .Net SqlClient Data Provider
from the IIS Host. What is going on?

I want to leave the 2 settings there (if possible) and change 1
setting for Prod IIS to point to prod DB.

Help!

If I understand your question, I think all you need to do is change the
defaultInstance ="appDev" to "appProd". Unless you are specifying an instance
name in your CreateDatabase calls, the DAAB will use the defaultInstance .

Or did I miss something?

--
Matt Noonan
EasyObjects.NET : The O/RM for the Enterprise Library
http://www.easyobjects.net

May 12 '06 #3

Similar topics

1510

Enterprise Templates

by: Shawn Mahalati | last post by:

I am confused with Microsoft Distributed Application Enterpirse Templates (MS-DAET). The documentation says to create a solution baded on MS-DAET, make the changes, and then save as a template. First, when I try to create the solution, it prompts for the Web and WebService project virtual directory. Second, I am confused about the Source Safe integration and teh following article didnt help: ...

.NET Framework

1531

Enterprise Library - Getting Started in VB?

by: cara_little | last post by:

Good Morning, I'm trying to get started with the Enterprise Library to evaluate it and recommend to the rest of the developers in the company. However, I'm having a heck of a time getting started and must be missing something. All of our development is completed in VB. I have installed Enterprise Library on my machine - however I can't compile the project. Is the code only available in C#? which means I have to have C# installed just to...

.NET Framework

5496

Connecting to online database using local Enterprise Manager

by: John Morgan | last post by:

I have Enterprise Manager on my local machine. For the last twelve months it has been connecting without problem to my online SQL Server database provided by my ISP. Three weeks ago the ISP applied some sort of extra security arrangements to their SQL Server to allow access only through port 1433. they have told me to configure an alias using Network Client and to register this alias in the usual way using my Enterprise Manager. My...

Microsoft SQL Server

1578

VS2005 + Enterprise Library : SQL queries takes longer to execute

by: Philippe Trottier | last post by:

Hi! We developped a program with VS2003 and Enterprise Library. then we switched to VS2005B2 to check the conversion between these two. Everything works fine now except one thing! The sql queries I execute on the database take much longer to execute. We have for example a query that selects all rows from a table that contains about 6000 rows. With VS2003 and any other sql tool it takes around 150-200ms to execute. But now with...

.NET Framework

1251

Enterprise Library June 2005 - Creating Documentation

by: Mythran | last post by:

I have installed NDoc and VSHIK2003. If I install a clean Enterprise Library June 2005, how can I go about getting the exact same documentation that is installed with the release (in the <installdir>\Docs folder)? My goal is to update the documentation with the changes I made, and getting an NDoc project to output the exact same files the the documentation that comes with the Enterprise Library is becoming a pain. Once I can get this...

C# / C Sharp

1444

Build Errors in Enterprise Library Install

by: P.Kienzle | last post by:

When I try to run the Build for the Enterprise Library, I get several messages referring to the .csproj files... stating that they are not installed (see below). They are located at the directory references specified.... How to I install them? The application for project 'C:\Program Files\Microsoft Enterprise Library June 2005\src\Security\Security.csproj' is not installed. Make sure the application for the project type (.csproj) is...

.NET Framework

2437

microsoft enterprise library

by: Justin Kadima | last post by:

I'm considering porting one of my application in order to use the Microsoft enterprise library and I am contemplating the pros and cons of doing it. Are you guys using the library?

ASP.NET

1992

2 questions about Microsoft Enterprise Library

by: rockdale | last post by:

Hi, all I am using Enterprise Library for .NET Framework 2.0 - January 2006 to access my backend MS SQL database. As now we are consider migrate sql database to mySQL. What engine (ODBC or MySQL for .NET) should I use so that the code change wil be minimum? Also, as the enterprise lib using connectionstrings in web.config to access the database, is there a way to encrypt this connectionstring, do I need to change the Enterprise...

ASP.NET

1568

Enterprise Library number jumble

by: GaryDean | last post by:

I now have installed (from the same install) Enterprise Library - January 2006 and Enterprise Library - June 2005. The install for these two was called Enterprise Library for .Net 2.0. (not Enterprise Library 2.0). I then discovered that there is an Enterprise Library 3.1 - May 2007. So I want to install that because it is the latest. The instructions, however, say that if I already have Enterprise Library 3.0 installed, I must...

ASP.NET

1503

Is Enterprise Library the successor to Enterprise Services?

by: =?Utf-8?B?QmVu?= | last post by:

Hi, I was wondering whether the Enterprise Library replaces Enterprise Services as a framework for providing services for enterprise apps, or it supplements it. I know nothing of either of these technologies, but from just looking at their feature set, I noticed that they don't exactly share the same features, for example ES offers services such as just-in-time activation and object pooling that I don't see in EL. I need to know if I...

C# / C Sharp

9691

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10279

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10255

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9092

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7582

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6815

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5607

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3765

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2948

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General