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,
I have a database on Go Daddy and my VS2008 app can not access it via web.config connection string. Of course runs great locally in development. I copy/pasted the connection string information from Go Daddy exactly into my web.config file. Web site runs fine on the web but when I try to Login at my login page, i get :The SSE Provider did not find the database file specified in the connection string. At the configured trust level (below High trust level), the SSE provider can not automatically create the database file.
I used VS2008 to create the .sql script files and uploaded them to Go Daddy and the Go Daddy people say everything works as they and I can both Login to the database from within GoDaddy.The database i am trying to access consists of the a ASPNETDB.mdf and another Database.mdf together as one in the Go Daddy database.
here is what i used: <connectionStrings><add
name="superskin"
connectionString="Data
[code]...
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.
I am using this connection string to query some .DBF .
[Code]....
How can i make it work?
I have this in the web config file <connectionstrings> section. Why is there an add and then remove and then again an add...what is it trying to accomplish here? and in the second code section, I use that string in a sqldatasource control. Second question: Can I just use the name attribute value "localsqlserver" form web config file, in place of the connection string in the data source? is it why that attribute is for?
[Code]....
What will change in connection string after upload database to hosting?
View 1 RepliesMy requirement is to save the connection string of database that will be provided to be me by user on form, which can be modified lator.
i need to know how and where i should store the connection string permanently which will be used lator to connect to database.
I have written the web.config for same server without username and server and its working.
but not been able to provide the username and password in web.config file.
Following is my web.config for Server:
[Code]....
I have to write another web.config for client application with username and passoword. how could i use it.
server name is "BM", User is "Sa" and Password is "abc"
I am developing an application in which I can connect to the ASPNETDB.MDF if it is on my machine, however, when I want to put it on another machine and try to remote connect it, I get the error:
An error occurred while attempting to initialize a System.Data.SqlClient.SqlConnection object. The value that was provided for the connection string may be wrong, or it may contain an invalid syntax.
Parameter name: connectionString and my connection string is as follows:
<add name ="NewRemoteSqlServer" connectionString="Data Source=P1M1_2-HPSQLEXPRESS; AttachDBFilename=C:ASPNETDB.MDF; Integrated Security=SSPI; Username=P1M1_2-HP; Password=plus1minus1; " providerName="System.Data.SqlClient"/>
I'm totally stuck. I've tried many ways. I have a webapplication deployed on Win2003 with IIS 6.0. The website needs to access:
D:data on another PC.
I've sucessfully created a virtual directory (using local credentials to the data PC) in IIS and I am fully able to browse and view all the files. So now the webserver is: WebserverData.
In my behind code, I call filestream f = (Server.MapPath("WebserverDatasomedata.txt")));
and it tells me access to that location: \webserverdatasomedata.txt is DENIED. BUT I am able to browse on the Win2k3 IIS server.
I've set impersonation to true and used local username and password of the data PC. I've configured IIS to use the same username password.
I am trying to deploy my C# based ASP.Net 3.5 webapp
The hosting service provider said "Access 2003 (.mdb) file has to be put in 'access_db' folder in root folder"
I am currently using
OleDbConnection myConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("~/access_db/filename.mdb"));
The folder structure is like
ParentFolder/access_db/filename.mdb
ParentFolder/ProjectFolder/<Project files> (App_Data, bin, *.aspx, web.config)
1) I am using a GridView on another page that doesn't allow to connect to a database outside the project folder. What should I do?
2) How do I modify the programmatic connection string ( shown above) ?
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 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?
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 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 RepliesI 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 RepliesI 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 RepliesI 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?
I finished my first asp mvc project and want to post it to a iis7/sql2008 server.I published the site just fine and migrated the sqlexpress database to sql2008 with no problems.However, when I run the program it still connects tp sqlexpress and opens a user instance.For the life of me I cannot get the connection string correct:
The current sring is:
<add name="AlertEntities" connectionString="metadata=res://*/Models.Alert.csdl|res://*/Models.Alert.ssdl|res://*/Models.Alert.msl;provider=System.Data.SqlClient;provider connection string="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Alert.mdf;Integrated
Security=True;User Instance=True;MultipleActiveResultSets=True"" providerName="System.Data.EntityClient" />
</connectionStrings>
How do I change this to make it see the sql2008 database?
I have create a masterpage and add content page include user (firsname,lastname,password,new password,confirm new password adn etc..)detail update field. i try to give a client side validation all the function work,but in confirm password its not hide wen give a correct password.. anybody give correct solution..code are below..
[Code]....
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]....
I have 3 Databases that I am pulling data from for my web site. 2 of the databases are in the same SQL instance, however the 3rd one is in a different SQL instance. Both of the SQL instances are installed on the same server, one of them is a Named instance and the other is installed under the default instance. So my connection strings look something like this:
<add name="ABCConnectionString" connectionString="Data Source=BobDataDB;Initial Catalog=Bob;User ID=*******;Password=*********;" ProviderName="System.Data.SqlClient"/>
<add name="BCDConnectionString" connectionString="Data Source=BobDataDB;Initial Catalog=Sue;User ID=*******;Password=*********;" ProviderName="System.Data.SqlClient"/>
<add name="EFGConnectionString" connectionString="Data Source=Bob;Initial Catalog=Sue;User ID=*******;Password=*********;" ProviderName="System.Data.SqlClient"/>
I'm in the process of moving this application from the Development Server to the Production Server when I noticed this issue. Previously the ABC and BCD connectionStrings where pointing to a different server and instance. So my question is how do I get this wo work with the server names being the same but the instances being different?
Some databases that my application has to access have their name according to the current year because the ERP we work with creates a new database every year, so, now it's working with the 2010db database. There are two options (as far as I know) for the ConnectionString property of a SqlDataSource: 1) hard-code it or 2) pick it up from the web.config file.
I don't want to change manually the connection string every year, so, how can I solve this? I would need to take the value of Now.Year either in the hard-coded ConnectionString or for the Web.Config ConnectionString, but I don't know how to do that.
I have created a web site in Visual Web Developer 2008 Express Edition. I have created database using SQL Server Express. The web site works good. I have hosted the web site, then getting error in connecting to database.
The connection string is
<
add
name="QkINDUSConnectionString"
connectionString="Data
Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|QkINDUS.mdf;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient"/>
know what is the correction i need to make in ConnectionString ?
