.net - ConfigurationManager.ConnectionStrings(2).ConnectionString?
May 22, 2012I am just having a hard time figuring out what does the number 2 in
ConfigurationManager.ConnectionStrings(2).ConnectionString
define? What does it mean?
I am just having a hard time figuring out what does the number 2 in
ConfigurationManager.ConnectionStrings(2).ConnectionString
define? What does it mean?
This is not working.. any ideas?
ConfigurationManager.ConnectionStrings("YourConnectionString").ConnectionString
Error
"ConfigurationManager not declared"
I have this in web.config and i need to use it from vb to pass it on a variable:
<connectionStrings>
<clear/>
<add name="SQL1" connectionString="..." providerName="System.Data.SqlClient"/>
</connectionStrings>
Quick background: I have a VB.NET application in which I was previously using ConfigurationSettings.AppSettings to read from app.config, and got an error message to change it to System.Configuration.ConfigurationManager.AppSettings (as the first way is now obsolete)I did so, and I even have a reference to System.Configuration.dll AND the Imports statement at the top, but I am getting a "Name ConfigurationManager not declared" error message. Any suggestions?
CODE:
It's pretty straightforward - I'm just checking if something exists, and if it does, I read from it:
If Not Exists(ConfigurationManager.AppSettings.Get(rep & "Email")) Then
Return False
End If
message = ReadAllText(ConfigurationManager.AppSettings.Get(rep & "Email"))
I grabbed some code from the internet to use as a base to write out a log file. When I pasted it into my project in VB.net 2003, I immediately got an error message stating:
[Code]...
This is glossed over as an easy thing, but when I try to create the reference by right clicking references and selecting add reference, then going to .net, the system.configuration.dll does not show up in the list. I then did a search for the dll on my system and found it in this location:
C:WINDOWSMicrosoft.NETFrameworkv2.0.50727System.configuration.dll
I then tried to register this DLL using "regsvr32 system.configuration.dll", but I get this error:
----
System.configuration.dll was loaded, but the DLLRegisterServer entrypoint was not found.I also attempted to browse for the file using the add reference utility and it gave me an error stating that a reference to the file could not be added. "This is not a valid assembly or COM component."
I'm really stuck at this point, I can't reinstall .net framework v2.0, the system won't let me. I can't create a reference and I can't get my program to work.
why are application settings stored in "applicationSettings" when the ConfigurationManager is looking in the old appSettings area in a config file?
View 6 Replieswhat is the meaning for this whole AssignConnString function?? It is because I am not understand what is meant by ConfigurationManager class.
[Code]...
I'm trying to connect to a database in my app, i'm using the app.config file to provide the connection string to the application.When i try to stablish de connection i get the following error msg: ConfigurationManager is not a member of Configuration. [code]
View 1 RepliesI need to finish one project in VB 2005.In C# I used IsolatedStorage.ConfigurationManager to save some my settings:
public IsolatedStorage.ConfigurationManager config
...
config.Write...
config.ReadBoolean..
...
But in VB i can't find IsolatedStorage.ConfigurationManager..
I was just wondering if someone could tell me if reading attributes is handled easily within the ConfigurationManager class since I am unable to find an easy way to do this (or a decent example via google). Basically I have a configuration section that looks like this,
<providers>
<clear/>
<add name="MySqlMembershipProvider"
[code].....
New to ASP.NET. Trying to be able to switch what text is being displayed based off a value in the Web.config file. Here is a sample of my code.
<td background="images/LoginBox_03.gif" width="350" height="151">
<table border="0" align="center" id="tblLogin" runat="server">
<tr id="trEmail" runat="server">
[code].....
I am developing a application which maintains log file. But I want to keep logfiles in Server's application folder or any place in server using app.config file. my main purpose is I will set log file path in app.config file. and as per setting in app.config my application generate and maintail logfiles.
View 2 RepliesI am creating a windows service in .Net 4.0 and testing some functions of said service with a windows forms client by referencing the service project.The service project has an App.config file and that file looks like this: [code]a null reference error is thrown because my connection string is not loaded.The only connectionStrings that are loaded are from the machine.config file located in [code]If I create an application scope setting for the service, I can get that setting by using the My.Settings.setting so it's not like the App.config file is not being read.why are my connectionStrings not being loaded from the App.config file?When referencing a project(parent) from another project(child), the child's app.config is used even if the parent's classes are being used.Thus, I can get the connectionStrings to show up if I copy them over to the child's app.config. When trying to open it manually, my currentDirectory was of the child, not the parent (strange how it did not throw an exception - it wouldn't have been able to find the config file it just silently used the machine.config.
View 4 Replies(My question is similar to this one, but the code is slightly different, and the solution doesn't work for me)I'm trying to save settings changes to the app.config:
Dim config As System.Configuration.Configuration = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None)
config.AppSettings.Settings("HistoryRootDirectoryPath").Value = p_historySavingPath
[code].....
I am using Visual Studio 2010 and referencing System.Configuration at the top "Imports System.Configuration" but I'm still getting not declared and could be inaccessible due to it's protection level. What now?
View 2 RepliesI am trying to upgrade a VB 2003 program to VB 2005.One warning I am getting is:
'Public Shared ReadOnly Property AppSettings() As System.Collections.Specialized.NameValueCollection' is obsolete: 'This method is obsolete, it has been replaced by
[code].....
I am in great trouble, I have a project on visual studio 2008 and I getting connectionstring using ConfigurationManager.ConnectionStrings("connestionstring") .ConnectionString. this project have a app.config file which contain
[code]...
I use dbf files from db2k in my application.When I try to connect, it takes a long time and I find the application exited without any error msg.The connection string I use:Return "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\agbvseng01APPLISNomenclature_Eng_Bvs;Extended Properties=dBASE IV" Data source is on a server.I dont know why this happens.
View 10 RepliesDim SQLInfo As String = "server=https://lotus.x10hosting.com:2083/frontend/x3/index.html;" _
& "uid=uid;" _
& "pwd=pwd;" _
[code].....
I designed a DAL (data access layer). This DAL mainly consists of a handfull of methods to call stored procedures. All methods are shared. So no instance generation of the DAL class occurs.
The DAL with it's single class is located in an own project. The connection string is defined in the app-config file of this project.
I want other applications to use the DAL class by referencing the dll generated by the DAL-project. For this reason, I can not any longer define the connection string in the DAL app-config as it is, because the client application determines which database needs to be used.
- Dropping the "shared" keyword of my methods. Create an instance of the DAL class. Add a property for the connection string. When application starts, create one global or multiple local instance/s of the DAL and set it's connection string property.
Comment: I don't like this, because it implies more coding work on the application code side (create instance of class, assign connection string)
- Granting the DAC class access to the connection string defined in the application code by adding a connection string property inside the application code. Thus the DAC class remains "shared".
Comment: I'd need to set a reference from the DAL to the application code during without knowing the application yet. I could try stack tracing or something like that. But it feels to convoluted for me.
I'm merging two of my projects that can share a lot of the same classes into one solution with two web applications and a shared class library.
I've literally just dumped all the classes into the class library project and as expected I've got a ton of errors to fix. My main problem at the moment is the connection string. Currently I have this (which is obviously not going to work):
''' <summary>
''' Initialise the data access layer by loading the database connection string from the Web.Config file
[Code].....
I've looked at a lot of posts on different forums where others have received the same error. Most say they were not referencing the connectionstring from the web.config file correctly, or they were trying to open the connection before setting the connectionstring. Well, if that were the case for me, then how does it work on two different systems, but not on the third? It works on my development PC and on the development server, but not in the production environment. The difference is the web and DB server are separate physical servers in my production environment and on a single server for development. My setup, error message and code will be listed below.
I can simulate the error on my PC if I rename the connection string in either section of the web.config file (appsettings, connectionstrings) to something else. You will see how I have tested both below.
[Code]...
I know below code causes an error since "Property 'AAConnectionString ' is 'ReadOnly". What other choice do I have to assign a value for a user ID or a password with a value of textbox by coding?
My.Settings.AAConnectionString = "Data Source=bb.allgood.com;Initial Catalog=aadb; Persist Security Info=True;User ID=aa123;Password=aa123"
I create project in my pc with vb.net and sql database when i tried to run this project to another pc there is error occurred that the connectionstring has not been initialized. I really troubled this from last one week to solve the problem. how to change the connectionstring on client pc at runtime or any other way to create a connectionstring that has auto detect in any pc where the program is installed.
View 5 RepliesIm writing a app using vb.net, which has multiple front ends e.g a windows service and a windows forms app. Ive got all my business logic and database stuff compiled into 1 project (producing a dll) then the different front ends as different projects calling the dll.
In the backend / dll project Im connecting to 2 databases using app.config to store the connection strings and DataSets / TableAdapters. This all works fine .... Until
When I deploy the windows app, it deploys the exe and the dll produced by the backend project. when its installed on a client PC, Im need to point the app at a different db server and therefore need to change the connectionstring, but its packaged up in the dll.
is there any way I can use a settings file within my windows app (therefore deployed with my windows app) where I can define the connectionstring, which onload gets passsed through into my dll, so the backend connects the correct database. I know how to pass standard settings through (strings etc) but the my.settings.connectionstrings seem to be readonly.
Im trying to make a query inb a dataset (to fill a report) Why it dont let me do a select (that will return rows)?
View 2 RepliesHow does a real life connectionString look like? I my sample application, I have this in the app.config file:
[Code]...
ConnectionString on real website
View 1 RepliesI have a web application that works perfectly on my local machine but not once Ive uploaded to the hosting server I get:
Server Error in '/' Application.
The ConnectionString property has not been initialized.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.InvalidOperationException: The ConnectionString property has not been initialized......
I have a web application that works perfectly on my local machine but not once Ive uploaded to the hosting server i get:Server Error in '/' Application.The ConnectionString property has not been initialized.Description: An unhandled exception occurred during the execution of the current web request.review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.InvalidOperationException: The ConnectionString property has not been initialized.Source Error:Line 423:Dim conn As New SqlConnection(connstring)
[Code]...