VS 2010 NHibernate Connection Configuration?

Jun 1, 2010

Seems one have to configure your connection a bit different in NHibernate configuration. In my web.config I'll have it like this (and it work):

Quote:

<add name="ApplicationServices" providerName="System.Data.SqlClient" connectionString="Data Source=72.118.116.71,1511;Initial Catalog=xxx;User Id=xxxx;Password=xxxx;" />
The sample I'm using (Trying to figure out NHibernate) configure a local database like this:

Code:

<property name="connection.connection_string">
server=.SQLExpress;database=NHibernateSample;
Integrated Security=true;
</property>
I've been trying various variations of this and cant get it to work:

Code:

<property name="connection.connection_string">
server=72.118.116.71,1511;database=xxxx;User Id=xxxx;Password=xxxxx;
Integrated Security=true;
</property>
Keep getting this errror:

The login is from an untrusted domain and cannot be used with Windows authentication."

View 3 Replies


Similar Messages:

C# - Use The Same Connection String When Using NHibernate?

Feb 15, 2010

I have just re-implemented an ASP.NET web application that uses NHibernate to use a session per request (using an IHttpModule). The SessionFactory is created at the start of the application using a connection string from the web.config file. The SessionFactory is then stored and sessions created and released using a thread-safe, lazy singleton.

This means that if say 20 users are using the application the same user (as specified in the connection string in web.config) is used when creating any connections to the database - is this best practice? Will SQL Server Express complain about the number of connections eventually? (as connections are created and released per request this may not be a concern in practice).

In my old architecture a connection was created using the user name of the current user - is there any advantage to this (perhaps if there is are security restrictions for the logins of each different user).

When using a thread-safe, lazy singleton (like below) which contains the SessionFactory and manages sessions, I believe this is available site wide wide e.g. 2 users accessing the application from different PCs will use the same instance?

public static NHibernateSessionManager Instance
{
get
{
return Nested.NHibernateSessionManager;
}
}
private class Nested
{
static Nested() { }
internal static readonly NHibernateSessionManager NHibernateSessionManager =
new NHibernateSessionManager();
}

View 2 Replies

Visual Studio :: Connection Property Error The Connection Property In The Web.config File Is Missing Or Incorrect In VWD 2010?

Apr 18, 2010

When I open an ASP.NET 3.5 project using VWD2010, I get a prompt error message,"The connection property in the web.config file is missing or incorrect.The connection string from the .dbml file has been used in its place."however, my project works successfully.

View 1 Replies

Configuration :: Give Password In Connection String For Ms Access Database In Configuration File?

May 2, 2010

I have an ms access db file and now i want to use it in my app. i have given like

Provider=MSDASQL.1;Password=pwd123;Persist Security Info=True;User ID=swgp;Data Source=SWGP;Initial Catalog=C:swgp BJswgp

but it is giving error to me.If anybody know how to give this connection string for password enabled ms access database,

View 2 Replies

VS 2010 Verifying That Connection Is SSL?

Oct 12, 2010

I am building a user control for other programmers that I work with. It will be used to interface with our Authorize.Net accout. Is there a way in code to verify that the connection is SSL? If it isn't I'm going to disable the code to keep any of our programmers from accidentally trying to use the user control on a page that isn't SSL.

View 3 Replies

VS 2010 N-tier Approach - Saving SQL Connection

Sep 29, 2010

What is the most correct way to save your connection string when using the n-tier approach ? Right now I have two windows app and one web app using my DLL library, what I'm currently doing is to create a static
method inside my dal "GLOBALDAL"
inside I'm making this check:

Code:
if (System.Web.HttpContext.Current != null) ...
if httpContext.Current is null
That's mean that one of my windows applications doing the request, if so I get the CN from a file otherwise it's mean its the website knocking on my door so I get the CN from:
Code: System.Web.HttpContext.Current.Application["ConnectionString"]
I am thinking of changing it all and just set properly in my DA layer that expose the CN as a string. But I fear of security issues. So what is the correct way?

View 21 Replies

VWD 2010 Connection To SQL Server Express 2008

Oct 6, 2010

i have designed a simple login page in VWD(login.aspx) . I have also added the connection to database option. Now i am stuck with adding connection strings in the web config file and also adding namespace.

View 2 Replies

VS 2010 - Change Connection String For Registration Form

Jun 20, 2011

I am trying to change the connection string for the registration form in VS 2010.

This is because it links to the local database in the App_Data which I need it to link to another database. I have changed the connection string in the webconig file and this works file for other forms I have created but does not allow me to create new users.

I have used the ASP.net 4.0 template when creating this website.

View 5 Replies

Databases :: Oracle Reside In Linux Server Connection From 2010?

Nov 25, 2010

I am starting a new project where I have to use oracle and asp.net. Oracle 11 enterprise edition. Problem is oracle database reside in linux server and application server is in windows. My question is1. Is there any problem connecting oracle from asp.net?

View 1 Replies

Create A Connection String Uning Visual Studio 2010?

Sep 6, 2010

How to create a connection string using Visual Studio 2010?

View 2 Replies

ADO.NET :: VS 2010 - No Entity Framework Or LINQ Support For SQL Server 2000 SQLOLEDB Connection?

Sep 1, 2010

I'm working with Visual Studio 2010 and for Data Connections am connecting to a SQL Server 2000 production database. When I try to drag a table to a .dbml file, the Object Relational Designer says, "The selected object(s) use an unsupported data provider." If I try to create an .edmx file via Generate from database, then the alert is, "This server version is not supported. You must have Microsoft SQL Server 2005 or later."

So VS 2010 has no support for the Data Entity Framework or LINQ when connecting to a SQL Server 2000 database? If that is the case, what is the best data access strategy for this scenario?

View 4 Replies

VS 2010 - Network Related Or Instance-specific Error Occurred While Establishing Connection

Jul 16, 2013

When I load the asp.net config tool in vs2010 it loads the page up fine but as soon as I click on security I get the following error:-

Code:

There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.

The following message may diagnose the problem: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. I have tried a blank project with a login control on but get the same.

View 3 Replies

Configuration :: Access Connection In DAL?

Feb 23, 2011

How can i get ConnectionString In web.Config when you are in DAL(data access layer)Some said it should me in <appSetting> but i think this is not appropriate to do because web.config have dedicate tag for connection strings.i am creating a 3 tier each layers is a project in 1 solution

Project ://solution

|_View :WebApp // Dependence (BLL,ENTITY )
|_BLL : ClassLib // Dependence (DAL,ENTITY )
|_DAL : ClassLib // Dependence (ENTITY )
|_ENTITY : ClassLib //note this is not a layes just a central data object reference

View 3 Replies

Configuration :: MS Access Connection?

Feb 23, 2011

I have created a website (VB) on my local host. A couple of pages on this website use gridviews or detailsviews with an AccessDataSource connection to a MS Access database. This works perfectly. But now I want to move this website to a hosting provider. And on this hosting provider my website works well but not the pages with a connection to the Access database. I searched the whole internet for a solution but I didn't found it.

Folder structure on the host:

- db > Access databases (name: testdemo.mdb)
- logs
-wwwroot > website (for example, the gridview is placed on index.aspx).


I think AccessDataSource didn't work, but what kind of code may I use in the index.aspx and web.config? My hosting provider said only, use a direct link to the database and not a relative, for example: E:xxx.comdb estdemo.mdb

View 3 Replies

Configuration :: How Does IIS 7 Gets The Connection String

Jun 17, 2010

I have created a ASP.NET 4 application in VS 2010 using Silverlight and RIA Services.

After finishing the first release on my development pc, I'm starting some deployment testing in a server in my local network.

After sucessfully published the web application using the Visual Studio FTP publishing option, I notice two strange things:

1 - On the IIS properties of the website I have uploaded my files to, you can see now a connection string, named as LocalSqlServer that points to the aspnetdb.mdf database file. I had a look in the web.config file and I could not find this connection strind defined there. So, where is it located? Where did IIs got it from?

2 - As the aspnetdb.mdf file is not deployed withtin the web application and I a musing SQL express in my testing server, where can I drop the mdf and ldf files so they can be attached when the applicaiton runs? I know I can perform an attach operation using management studio,but I'm wandering where is the DataDirectory folder ASP.NET looks for to attach it at runtime?

View 4 Replies

Configuration :: App Path Connection From ASP.net?

Aug 17, 2010

i have done a project using ASP.NET and SQL database...and it's working good.but everytime i run the project in other computers i need to set connection path to database.without set connection how to run the project.using "App Path"? please let me how to set App Path in ASP.NET PROJECT.

View 2 Replies

Visual Studio :: Error Unable To Add Data Connection. ExecuteScalar Requires An Open And Available Connection. The Connection's Current State Is Closed?

Sep 13, 2010

I'm using Visual Studio 2008, and my database is SQL Server 2000.

I want to add a connection to the Server Explorer in VS. The Data source is Microsoft SQL Server (SqlClient). After entering in all my information and I click Test Connection, it is successful.

But when I click OK, I get the error:

Unable to add data connection. ExecuteScalar requires an open and available connection. The connection's current state is closed.

View 3 Replies

Configuration :: How To Change Connection Settings

Feb 8, 2011

Right now, when I am copying the website to host server, I am changing the connection string in webconfig file and at each location of a sqldatasource or a query .. thats like more than 30 places where I am doing this.

When I am done copying the website, I have to change all the connection strings back to dev server for me to keep working on the dev copy....

View 1 Replies

Configuration :: The Connection To The Server Was Lost?

Mar 15, 2010

I have an application 'A' builded by VS2005 and Framework 2.0.50727 before.And I am fixing an application 'B' builded by VS2003 with Framework 1.0, so I installed 1.0 yesterday.Everything worked fine but today when I was running 'B', it showed "Visual Studio cannot create or open the application because the Web server on this computer is not running. Start the Web serber before proceeding."Even if I reintall 1.0, VS2003 still shows this message.Then I closed VS2003 and open VS2005 to run application 'A' to see if app 'A' works fine.

But after I run app 'A', the IE says cannot display web page.So I checked my Default Web Site in IIS, it says 'The connection to the server was lost. Do you want to attempt to reconnect?'I tried solutions from internet to solve running app 'A' :1. Type C:WINDOWSMicrosoft.NETFrameworkv2.0.50727 -i or -u in command.2. Checked the World Wide Web Publishing status is startedThe running app 'A' still gave me cannot display IE picture.Does anyone know how can I do for it?

View 7 Replies

Configuration :: Connection String Visible In IIS?

Dec 9, 2010

I have decrypted my connection string in web.config file of the application programatically. But after deployment under the ASP.net tab of application virtual directory when I click edit configuration the connection strings in web.config file are visible in decrypted format i.e readable form.

View 3 Replies

Configuration :: Is Possible To Have More Then One Connection String In The Web.config

Oct 19, 2010

I have been preparing for a conversion of an old application to an ASP.NET webapplication at beginning of the year. Generally, the development version of the webapp will also be the webapp that goes into production. We here make "clones" of the database server, assign new name, etc, which is then used for development, training, and so on without any threat of changing data on the real db (sql server 2005). I know it is possible to have more then one connection string in the web.config. My question centers around if there is a simple method for allow multiple connection strings and pick the one that is to be used for dev, production, training, and so on? I originally thought about constructing some type of admin form that the connection string can be selected from.

View 2 Replies

Configuration :: Get Sql Connection String From Web.config?

Dec 15, 2010

I have an app that is a bit old and will eventiall be rewritten but until I get the time it needs to continue to be patched. THe app is desgined broken into three layers (Web, DAL, BLL) The web site uses the DAL.DLL and BLL.DLL and the Website has some dataaccess and the sonnection string is saved in the web.config. For the DAL it is stored in the app.settings. Is there a way for the DAL to use the connection string that is stored in the Web.config even thought it is in DLL for the production site?

View 2 Replies

Configuration :: Setting Up Connection To MS SQL Database?

Oct 1, 2010

I am a PHP developer trying to set up hosting for an ASP website. The site works when hosted with the original host but I need to move it.

I have uploaded the files to oneandone hosting. I have set up a datebase and chnaged the database connection details but get the following error

Inner Exception Could not find stored procedure 'uspPageHit'.

The database connection looks like this:

<add name="site" connectionString="Data Source=[hostname];Initial Catalog=[databasename];User Id=[username];Password=[password]" providerName="System.Data.SqlClient" />

and the info on the one andone host panel provides :

database name, user name, hostname, password

Have I put the correct details in the correct place?

View 3 Replies

Configuration :: Close Connection In Web.config?

Dec 17, 2010

How to close connection in web.config?

View 5 Replies

Configuration :: Connection String Encryption?

Nov 3, 2010

I was reading about how it is a good idea to encrypt the connection strings for security purposes. I came up with a solution that I think may be somewhat elegant, but there may be big flaws in my thinking. I am overworked and tired :)

Basically I have a setting in the web config EncryptConnectionString. In the Global.asax. Application_Start I am checking this in the config. If it is true, I am encrypting the connection strings. If it is false, I am decrypting the connection string.

Question #1 Is there a better way?

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved