.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Sharad
Manish
Post New Web Links

[SOLVED] .Net 2 Service unable to access Connection String in Machine.config

Posted By:      Posted Date: November 16, 2010    Points: 0   Category :.NET Framework
 
I have a Windows Service I have developed in Visual Studio 2005 (C#).

It accesses a database using a connection string in machine.config.

On my Windows XP Pro 32bit (SP3) machine, it works correctly.

On my new Windows 7 Pro 64bit machine, it throws "object not set to an instance of an object" when it gets to the line where it's trying use the connection string.
This is the 'object' which is not set in Windows 7:
ConfigurationManager.ConnectionStrings["MyDatabase"].ConnectionString

 

The machine.config has the same connection string set up on both machines.

A .Net 2 website transferred to the Windows 7 machine has no problem accessing the same connection string.

I have tried a bunch of different permissions on the machine.config and its containing folders, and setting the service to log in as Admin, but I don't know exactly what permissions are required.

Does anyone know what's going on here? Many thanks.




View Complete Post


More Related Resource Links

Modifying connection String in Web config using Install Wizard

  

Hey,

Im trying to create a Web Deployment Project, the built in setup and deployment is very good in Visual Studio, i need to able to add an additional step in the setup to change the connection string in the Web config file. Ive seen a lot of articles on how to do this and in particular this http://weblogs.asp.net/scottgu/archive/2007/06/15/tip-trick-creating-packaged-asp-net-setup-programs-with-vs-2005.aspx#7162670 I am however stuck on the final part of this tutorial, im using the code Scott provided but have two errors,  heres part of my code where the errors are



using System;
using System.Configuration;
using System.Configuration.Install;
using System.ComponentModel;
using System.Diagnostics;
using System.IO;
using System.DirectoryServices;

 void ConfigureDatabase(string targetSite, string targetVDir, string connectionString)
        {
            // Retrieve "Friendly Site Name" from IIS for TargetSite
            DirectoryEntry entry = new DirectoryEntry("IIS://LocalHost/" + targetSit

WCF Service Unable to Access Personal Certificate Store Unless Service Account is Logged In

  
I created a WCF service that has a method which makes a call to a SOAP web service over the internet. In order to make a call to the SOAP web service, it requires that an X.509 certificate be sent with the HttpWebRequest. The X.509 certificates are loaded in the Personal and Trusted Certificate store of the account which the service is running under. When the service account is logged into the server, everything works just fine. However, when the service account is not physically logged onto the server, it has problems loading up the X.509 certificate and fails authentication when trying to make the HttpWebRequest. I am new to WCF services so I don't even know where to start looking. Can anyone please help? Thanks in advance.

Writing connection string in web.config file by code or dynamically

  
I want to write connection string in web.config file of my application by code. If anyone know the way or code just help me..NET,C#,SQL SERVER

Unable to build connection string using Package Level variables from the AcquireConnection fonction

  
Hi all! In SSIS 2008, within a script component trying to refer to a package level variables that was added to the ReadOnlyVariables collection of the component, the following fails within the AcquireConnnection function and I get this error: Error 1 Validation error. Test1: Test1: Microsoft.SqlServer.Dts.Pipeline.ReadOnlyVariablesNotAvailableException: The collection of variables locked for read access is not available at this point.     à Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.HandleUserException(Exception e)     à Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.AcquireConnections(Object transaction)     à Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper100 wrapper, Object transaction)   string connectionString = "DSN=" + this.Variables.MYDSN; Conn = new OdbcConnection(connectionString); Conn.Open();     If I move the previous code in the PreExecute function, it runs fine though.   Then, if I move the connectionString variable to the class definition, and populate it from within the PreExecute function and leave the last 2 lines in the AcquireConnection function, I get the following error: Error 1 Validation error. Test1: Test1: System.InvalidOperationException: The ConnectionString property

Unable to access Configure Service Accounts using the Farm acount

  
hi all, I am new to SharePoint and have started working directly on SP2010,   I installed SP 2010 using the Domain\spadmin account. I have also added mine domain account as the administrator in the central admin(farm administrator) now m trying to start the SharePoint Server Search 14 service from "services.msc" for which the log in as user is mine domain account, for which i am getting the following error: The SharePoint Server Search 14 service failed to start due to the following error: The service did not start due to a logon failure. if I check for all the services which are running in SharePoint I get that SharePoint Search service is active. also when i try to access Central Admin --> Security --> Configure Service accounts then I get the error message as access denied signin as different user.   Please help me out as i need to configure search for my application and m not having the access.   Thanks for the help Arun Kumar

Unable to obtain password in the connection string

  

I am reading a connection string for SQL Authenicated user from the SSIS Package Configuration file which looks like

Data Source="ServerName";Initial Catalog="DB";User Id="UID";pwd="PWD";Integrated Security= false;Persist Security Info=True;

 

I am accessing the above connection string in the script task. But the conection string comes without the password and it says login failed for the user. I am unable to get the password. 

 

Any help is much appreciated. Thanks in advance.

 

Niranjan.N


Web Service Unable to access Directory (Temporary ASP.NET Files) CS0016

  
QuestionMoving web service to a production level server. This is not a new server, but is new to running an ASP.NET 2.0 web service. No other websites or services existed on this server.

Installed .Net 2 and specified that ASP is registered for 2.0 using aspnet_regiis. Installed missing components such as Front page extensions. When I try to browse to the services asmx page I get the error saying that the process has a compilation error and cannot access the asp.net temp directory under the 2.0 Framework. I looked at the directory and it appears that the asp.net process and others have correct access.

Note a basic asp.net page will come up as well as a basic html page.

All comments are welcome.

Platform
  • .Net 2
  • ASP.NET aspnet_regiis specifies .Net 2 as root
  • C#
  • IIS6
  • Windows Server 2003 SP1

Encrypting config file's connection string and keys

  

 Is aspnet_regiis.exe secure? If i encrypt using aspnet_regiis.exe, will it automatically decrypt the string and wont give any error? Need an insight into this stuff....any suggestions? Is Rsa the best option or wat? Wat's the best way to encrypt/decrypt programmatically?


web.config connection string problem within VisualStudio 2010 to point to SQL Server 2008 R2 Develop

  

Hello All, I would appreciate any help with this.

I believe my problem exists within the web.config which already had code in it to connect to SQL Server Express 2008.

I uninstalled the SQL Server Express that came with Visual Studio 2010.

I installed SQL Server 2010 R2 Developer, and I'm able to connect via Management Studio and through Visual Studio's Server Explorer's Data Connections I am connected.

I did run aspnet_regsql.exe within the 4.0 folder in order to create the database with Microsoft Service Providers.

Here is the ServerName: USER-5529234649 

Here is the name of the DataBase:  StepByStepChapter9

Here is the name of the Connection within Visual Studio's Server Explorer's Data Connections:  user-5529234649.StepByStepChapter9.dbo

Here is the code I changed in the web.config:

<connectionstrings>
<add name="ApplicationServices" c

Web config connection string error: a field initializer can not reference the nonstatic field

  

Hello:

I am try to get connection string from web config, but I got error" a field initializer can not reference the nonstatic field, method, or property '_default.connStr'. I search a lot. It says that I need constructor, but I am not sure how to write the constructor at class: public partial class _Default : System.Web.UI.Page


Here is my code:

{public partial class _Default : System.Web.UI.Page

    string txt;
    string username;
    OleDbCommand myCommand = null;
    OleDbDataReader myDataReader = null;
 

//retrieve the connection string from the ConnectionString Key in Web.Config
    string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

    //create a new OleDB connection
    OleDbConnection myConnection = new OleDbConnection(connStr);

protected void Page_Load(object sender, EventArgs e)
    {

            string strOledb = @"select * from tableone";
     
            OleDbCommand myCommand = new OleDbCommand(strOledb);

Service Broker Queue message activates stored Proc as SA but the stored proc is unable to access oth

  

I have a queue whose activation I defined as below

ALTER QUEUE SomeInitiatorQueue
WITH ACTIVATION
( STATUS = ON,
PROCEDURE_NAME = usp_SomeProc,
MAX_QUEUE_READERS = 30,
EXECUTE AS OWNER)

Now I am trying to access another database in usp_SomeProc as below

Select SomeColumn SomeOtherDb.dbo.SomeTable

Here I am getting this error "The server principal "sa" is not able to access the database "SomeOtherDb" under the current security context."

It never allows unless I grant all permissions on the database to all.

what is the solution?


How to access the connection string in ASP.NET 4.0

  

Hi

The following code use to work in ASP.NET 2.0:

System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings("AquilaConnectionString").ConnectionString);

But in version 4.0, it doesn't like the use of ConfigurationManager.

Any thought?

Much appreciated
Richard 


Reporting Service Integration, Unable to access Reporting Services Site Settings

  

I am attempting to get reporting services running in integrated mode with sharepoint 2010. I have everything installed and features turned on. In the site collection, when I click on  Site Settings > Reporting Services Site Settings, I am presented with:

Error: The request failed with HTTP status 401: Unauthorized.

 

I get virtually zero hits when searching for this. Any help is appreciated.

 


cannot access sharepoint site through Internet Explorer 8 on a machine running Win XP Service Pack 3

  

The Sharepoint portal can be accessed fine through Firefox. Opera allows me to access it, but I cannot sign out, check out a shared document or do anything which opens a small window on clicking an option.

I can stay with Firefox, but when I try to edit a shared Word document in Word I get the message "Edit document requires a Windows Sharepoint Services compatible application and Microsoft Internet Explorer 6.0 or greater" We need to edit a shared document/calendar which is uploaded. All I know is we are using Sharepoint 2007 and the version of our site is 12.0.0.6421. Does that mean we have Windows Sharepoint Services SP2 on our Sharepoint server?

When I try Internet Explorer, I cannot log on at all. I get a window which asks for my credentials which I enter, it fails to authenticate me, then shows me the You are not authorized to view this page message. I tried with different computers, but cannot get in using Internet explorer.

What could be the issue?

Our Sharepoint admin does not have time to look into such matters so I am on my own.

Any suggestions would be appreciated.

SQL Connection String

  
We can learn or know how can we connect the database from our .net. This will help for freshers or .NET beginners!

abstract away the source of the connection string using a class with a static property.

  
ASP.NET provides a configuration system we can use to keep our applications flexible at runtime. In this article we will examine some tips and best practices for using the configuration system for the best results.

The element of a web.config file is a place to store connection strings, server names, file paths, and other miscellaneous settings needed by an application to perform work. The items inside appSettings are items that need to be configurable depending upon the environment, for instance, any database connection strings will change as you move your application from a testing and staging server into production.

Encapsulation
Let's abstract away the source of the connection string using a class with a static property.

connection string question from a newbie

  

when publishing  in the webmatrix dialogue it asks for "destination connection string" for my "database.mdf"

I was not sure what it was so I pasted this from my web.config file :

Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\database.mdf;Integrated Security=True;User Instance=True

it all published ok, but wont run, so I guess it has somthing to do with this connection string or some kind of configuration issue.

My question is this, What should go in the field for "Destination connection string"


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend