I need help with changing this DSN to a DSN less var connection .whenever i use the dsnless connection i get an error since the String connTaftPrjPic is reused in the code.The Objective is to change to a DSN Less connection without affecting the connTaftPrjPic.
<%
// FileName="Connection_odbc_conn_dsn.htm"
// Type="ADO"
// DesigntimeType="ADO" [code]....
just for my testing purpose i know i can define both the connection's outside in a single web config file by different name's and access them in my front end according to it but what if i want to have seprate for both connection's web.config situation is like this see image so i want to access my connections from second web config file how i can do that.
[Code]...
i tired this but its giving error
[Code]....
I have got a small website with MS Access Database. I have used access membership provide with it. i bought hosting with Discountasp.net when i uplaoded my web to the server it gives me following error. It works perfect on my local machine.
i have contacted the support guys they say there is somthing worng with my web config there is nothing pointing to sql server in my web config. here is my error message. I have a hosting with iis 6 it does work on that but it does not with with iis7.
Server Error in '/' Application.
Configuration Error
Description:
An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: The connection name 'LocalSqlServer' was not found in the applications configuration or the connection string is empty.
Source Error:
[Code]....
Line 158: <roleManager>Line 159: <providers>Line 160: <add name="AspNetSqlRoleProvider" connectionStringName="LocalSqlServer" applicationName="/" type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>Line 161: <add name="AspNetWindowsTokenRoleProvider" applicationName="/" type="System.Web.Security.WindowsTokenRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>Line 162: </providers>
Source File: C:WindowsMicrosoft.NETFrameworkv2.0.50727Configmachine.config Line:
160
Version Information: Microsoft .NET Framework Version:2.0.50727.4016; ASP.NET Version:2.0.50727.4016
I'm having a terrible time being able to connect my access database to my website. I'm using 1and1.com as my host. The database resides in my App_Data folder. I checked everything I could think of on the host side. I cannot query from the database through VWD Express nor create a typed dataset .xsd that will allow quering the database.p.s. - I don't need any sophisticated security on the database, just a homegrown sign in I put together that works fine for my site which is mostly xml file data.
View 10 RepliesI have a entity data model generated from a database schema. Now that database is no more physically available, I want to generate a new database with the same schema model. I'm able to generate the tables from the script that the Entity Frame work generates for me.
I have two problems. I'm not able to generate the stored procedures from EDM. Second, I'm not able to change the connection string to the new database. Do I have to re-generate the edm from the new database that I'm trying to create?
i have create users and rolls and all thing work very good on my computer but after upload view exception
Code:
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. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) how can i change connection string for mdf database
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....
how can I change ASP.NET Configuration tool-s connection string name? (Which connection string will ASP.NET Configuration tool will use)
I'm learning ASP.NET and everywhere and in book that I'm reading now theres connection string named: LocalSqlServer.
I want to use my local sql server database instead of sql express to store Roles, Membership and other data.
I have used aspnet_regsql.exe to create needed data structures in my database. after that I changed my web.config to look like:
[code]....
What is your opinion on allowing administrators to update the SQL Server Connection string dynamically from the application versus just showing them the connection details in the application? Because the database connection is so important and on a heavily used system the abrupt change to the connection seems like it could cause problems. However I would think displaying the server and catalog and whether the connection is using SSPI or SQL Auth could be helpful for administrators who don't like playing with .NET config files.
View 4 RepliesI have a page in asp.net (web forms) that up until now only had one database for data.
So all the controls that require something from the database use a datasource and the same connection string.
<asp:SqlDataSource id="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:DefaultConnectionString %>"
ProviderName="System.Data.SqlClient"
SelectCommand="SELECT ... ">
</asp:SqlDataSource>
Up until now I only needed one connection string since I had only one database but this has changed since I want some users to connect to database A and others to database B What would be the correct way to go about it?
How can I make the code string connStr = ConfigurationManager.ConnectionStrings "staceys_cakesConnectionString"].ConnectionString;
work generically and not need the staceys_cakesConnectionString? Or how can I set it somewhere else so I only have to change it one place when I change it?
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
[Code]....
I have a solution which uses Linq to SQL Data Classes to acced the db. I have a project for my domain objects in my solution, which is a class library and has the dbml file. When I set up the dmbl using the wizard, Visual Studio created anapp.config file on that project with the connection string. It also creatting asettings file with the same info. I've noticed that if I change the connection string in the settings file, the app.config gets updated, which is the expected behaviour.
However, I'm having a problem when I deploy my web site to the production server. I already set the app.config file's Build Action to "Content", and also set Copy to ouput directory to "Always". Nevertheless, when I install the web site and change the connection string in the app.config file, it still takes the old connection string, so obviously I get an error. I've found that it only works if I change it with in Visual Studio and then compile, but of course that's not an optimal solution, because any change in the production db server would mean I have to change my project's assembly, thus generating a new version.
What do I have to configure so that the assembly takes the connection string form my app.config file directly after I deploy?
i have 2 ASP pages in first page the user choose the database name and in other page take the database name and change the connection string to other databasehow i can pass a variable from one page to other by button click and how i receive this variable in other page and how to change the connection stringthe connection string is in web.config like this:
<connectionStrings>
<add name="Northwind" connectionString="Provider=sqloledb;Data Source=.;Initial Catalog=Northwind;User Id=sa;Password=sa; Connect Timeout=10"/>
</connectionStrings>
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
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
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.
how can I change my database connection name in appconfig file....what is the tag name to it?
View 2 RepliesDoes anyone has an idea on how to change the connection string of the webparts at runtime. i have a multitenant app, and would like to store each accounts users settings in their respective DB's i tried changing the connstring in the webpartsmanager init, and the page load event
Dim myConfiguration As System.Configuration.Configuration = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("~")
I am sysadmin user on a database server for SQL Server 2005.
I need to change the connection string that use 'sa' to another account. But I don't know how to change the data manager connection for the package 'XYZ'.
I developed MVC application. Then successfully import my local database which was stored in App_Data folder to the hosting provider (thanks
ScottGu). But now I don't realize how can I painlessly change my Entity models which was using local database in order they use database which was imported.Here is some of the connection strings
[Code]....
i have a code which has the connection string as driver. dim s as string = "Driver={SQL Server}; Server=xxxSQLEXPRESS; Database=dbRegister; Trusted_Connection=yes"
i need to change that to -
"data source=1.2.3.4;user id=xx;password=xxxxx;initial catalog=xxxxx;Connect Timeout=30"
when i just change the text it gives this error -
"[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" how do i declare the datasource?
I have serveral databases with same tables. I created a crystal report to show the report for respective logins from the database. I have a problem in it. In crystal report when i changing the database it should not change the respective table. It loads only the table what we give in the connection string first time.
View 1 RepliesI 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.
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$appSettings:ConnString%>"Â SelectCommand="sql query ............."
This is in design and with the above I have
 SqlDataSource1.SelectCommand = "sql query ............. " in code behind
but if i have the connection in code behind. How do I execute
SqlDataSource1.SelectCommand == "sql query ............. "
It without any reader or dataset...
I am using a AccessDatasource for getting values from a accessdatabase for a Dropdown list. After i load the page and close it, a .ldb file is created. After wards i am not able to open the database manually. How to close the connection. I have given Network service Modify access [URL] to share permission, still no go.
View 3 Replies