Configuration :: How To Access Database File Outside The Project Folder
Apr 12, 2010
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) ?
View 11 Replies
Similar Messages:
Oct 5, 2010
I am trying to add a new database via the App_Data Folder and I receive an error described below.When I attempt to add ANY TYPE OF SQL SERVER DATABASE through the App_Data folder I receive this error "Connections to SQL Server Files (*.mdf) require SQL Server Express 2008 to function properly. Please verify the installation of the component or download
from the URl."
I can create a db via SQL Server Mgmt Studio, it connects fine, and I can see tables.
Visual Studio- Server Explorer connects fine to the Database, I can see the tables.
Im running XP SP3 w/ Visual Studio 2010 and SQL Server 2008 R2 Developer. I had previously removed SQL Server Express.
Why cant I access the database within my project, when Im able to connect to this fine within Visual Studio Server Explorer?
View 6 Replies
May 15, 2010
We store backup archives in subfolders of a folder on one of the server's external USB drive. I would like to have an ASP.NET app read the contents of this folder so the manager can view the backup files to confirm backups are working and optionally delete these backup files when an old drive is reconnected so it can be used for the next weeks backups.
This backup folder is oubviously outside the server's webroot. Is there some way I can grant authority so the ASP.Net app can access this folder for this purpose? I would be using VS Web Express, so can't create any signed packages and such.
View 3 Replies
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
Feb 17, 2010
Is there anything missing in IIS 6.0 that prevents me from (Insert into table) using MS-Access?
Explain: The application works fine under Visual Studio 2008 IDE the insert into table works fine with no error, Also I tested with hosting provider and works fine with no problem. but now I have published the same exact app in a dedicated server windows 2003 with
IIS 6.0 .NET framework 2.0 with latest service pack I gave IIS_WPG write/modify access to the folder where MS-Access database is located and database but at the time of insert an error pop-up. I need to install in the Server or settings in the IIS to recognize my MS-Access db is it some office runtime that I am missing. (BTW I am using OLEDB connection string in my C# )
Using System.Data.OleDb;
I can retrieve data off of it with no problem but when I try to insert is when it fails I thought the problem was Access Rights but I do not think is the case.
View 4 Replies
Jan 1, 2010
I am ristrcting access to the Account folder using below:
<location path="Account">
<system.web>
<authorization>
<deny users="?"/>
<allow users="*"/>
</authorization>
</system.web>
</location>
and access to the Default.aspx using
<location path="Default.aspx">
<system.web>
<authorization>
<deny users="?"/>
<allow users="*"/>
</authorization>
</system.web>
</location>
but how do i restrict access to a specific file in the Account folder rather than the entire folder?
I tried the following but did not work
<location path="AccountChangePassword.aspx">
<system.web>
<authorization>
<deny users="?"/>
<allow users="*"/>
</authorization>
</system.web>
</location>
View 1 Replies
Mar 29, 2011
I have 2 folders - 1. Data 2. Presentation which is following the 3-tier model of designing programs.
I have a slight problem. I am trying to access a class which is found in the Data folder from a web form found in the Presentation folder. How can I do this? For some odd reason my project does not have namespaces.
View 2 Replies
Mar 14, 2011
When we select pull down menu Build -> Publish .... website. The cs extension file dropped into bin folder instead of root folder.
View 2 Replies
Mar 18, 2010
I have a large folder (1.5 GB) in my ASP.NET Web Site, called Downloads, which contains media files, graphics, etc. No code that needs to be compiled or even deployed on every build.
I use Web Deployment Projects to compile and deploy. Every time I build the deployment project, the Downloads folder gets included and copied to the output location. This is taking a significant amount of time, because the folder is copied twice.
I've tried modifying the wdproj file like this:
<ItemGroup><ExcludeFromBuild
Include="$(SourceWebPhysicalPath)Download*"
/>
I've also tried not adding the * after the folder, but then I get a message that says the directory is not empty during the build process.
I've also tried this approach:
<ItemGroup>
<RemoveBeforeMerge Include="$(OutputPath)Downloads*" />
</ItemGroup>
And that still did not help. (also says: The directory is not empty.)What is the proper way to tell WDP not to consider a folder at all?
View 1 Replies
Apr 20, 2010
I have a license file that I need to access at runtime in order to create pdf-files. After I have created the in memory pdf, I need to call a method on that pdf to set the license, like this:
pdf.SetLicense("pathToLicenseFileHere");
The license file is located in the same project as the.cs-file that creates the pdf, but is in a separate folder. I cannot get this simple thing to behave correctly, which makes me a bit sad, since it really shouldn't be that hard. :(
I try to set the path like this:
string path = @"ResourcesFile.lic";
But it just isn't working out for me.
Edit:
A bit more info. I should mention that this is a web service which returns pdf:s as byte[]. The web service creates the pdf:s, and during this creation process I need to set the license file so as to remove any watermarks from the pdf document. The pdf itself is not saved to disc, and only needs to access the license file once when it is created.
View 2 Replies
Aug 22, 2010
I created a ASP.NET project under Visual Web Developer 2008. Under that project I had a Database (along with ASPNETDB.MDF) which has about 3/4 tables (I had SQL server 2008). Everything was working fine (like insert, delete, etc.). And I was able to view the tables in database explorer view.
Then I had to format my computer for some reason and I copied the whole project in a USB drive and then after formatting the computer I copied the folder and tried to open it in Visual Web Developer (now I have VWD 2010). I can see the both Database under App_Data folder (ASPNETDB.mdf and the DB I created). ASPNETDB has all the tables and data as expected. But I do not see the tables under the DB I created.
View 8 Replies
Jan 27, 2011
We have created an ASP.NET ( 3.5) application is configured to use FORM authentication and thus it has such a following items in Web.Config :
<location path="~/Admin/Default.aspx">
<system.web>
<authorization>
<allow roles="Manager,Member" />
<deny users="*" />
</authorization>
</system.web>
</location>
<location path="~/Admin/MyAccount.aspx">
<system.web>
<authorization>
the application runs OK on local web server box. Our ASP.net application is able to access Admin folder in local IIS application folder and its subdirectory. However, once uploaded to remote web host , user can login but when user wants to use any pages in ~/Admin subfolder, we get an exception that essentially states that access to the sub-directory is denied.
View 3 Replies
Jul 31, 2010
I want to upload images in to a folder in my project and save the URL in the database.
When you add a record into my database you provide title, date added and some other details and there it a file upload control which you browser to a image and it saves the image to a folder in my project, it all works, the record is added and the image is uploaded into the folder, but the problem I have is that there is no link from the record to the image, there is no URL path saved in the record. How do I save the image in the folder and save the URL of the image to the record?
I'm using details view to insert the records and using grid view to view the records.
View 10 Replies
Jan 17, 2011
I am trying to configure my web application to send emails to my email address in case of any error . Below is my coding in the web config file, I am following example from a book cuase I AMM A nOVICE TO VISUAL STUDIO AND .NET AND C#. THE NAME OF THE BOOK IS ASP.Net E-Commerce in C#. I am not sure what to put in for the MailForm value since the book did not say could someone tell me .
[Code]....
In my other configuration file under the App_Code folder I have this coding Below:
[Code]....
View 1 Replies
Oct 29, 2010
i want to keep the database in the root folder of my application.what would be the connection string ?
View 1 Replies
May 7, 2015
I want example upload pdf file and send name, title, filename, filepath to database and retrieve and display pdf from Upload Folder...
View 1 Replies
Dec 25, 2010
i need to rename microsoft access database in APP_Data folder using ASP.Net - VB.Net
View 1 Replies
Dec 5, 2010
When I try to connect to access database from app_data folder of the webform I am getting "Invalid UDL file" .
View 1 Replies
Apr 2, 2010
I am using VB.Net/ASP.Net 2008 and I have a solution with 3 projects:
1. DAL
2. BLL
3. MainWebProject
anyways because it's a Web Application Project (not a web project) I had to set it up so I could access the Profile using Imports System.Web.Profile in the MainWebProj but I can only access the profile in that project.
anyways I need to access the Profile in the DAL also, and I figure since I can import the Profile in my MainWebProj there must be a way to also import that into the sister project, DAL.
My Issue: I can import a class in Project A but not Project B. Is there import syntax so I can also import the namespace in Proj B?
View 1 Replies
Jan 29, 2010
I have a created a solution using visual studio 2008 and added a new project namely "test".
In this project i added a folder namely "code" and in this folder i added a class file "class1.vb".
But i am facinng problem when i am going to create object of that class1.vb in default.aspx.vb page
i want to access my class1.vb methods.
View 4 Replies
Sep 6, 2010
I have .dll file on Desktop, I imported it to References my ASP.NET application - but when I delete this file from desktop I have error in my ASP.NET application. What is the solution ?
View 4 Replies
May 27, 2010
I'm using a .resx file which have some name and values.. I wanna read the values programatically.. the recource file is inApp_GlobalResources folder of the project..
I'm using Visual Studio 2008.. and C# as Code behind.
View 1 Replies
Aug 20, 2010
I need to Copy the Uploaded file to D Drive in Asp.net 1.1 using C#
View 1 Replies
Apr 20, 2010
An associate wants to store an Access database in the App_Data folder of a website that lives on a local server and write new data to it daily from Microsoft Access on a client computer on the local network.Internet users will access the Access data from the website.
Is it possibe to write to an Access database in the App_Data folder of a website that lives on a local server using Microsoft Access? And also connect and read with ASP.Net?The internet connection is "Read Only".
View 4 Replies
Nov 22, 2015
[URL] ....
In above link you clearly describe (How to display directory folder structure).
The path only works when the folder insight the project.
When I put folder outside the project it didn't work. What type of changes I need to made to acces the folder outside the poject. & How can I show other details of files which are including in folders Like. Last Modified Created Date, Modified Date etc..
View 1 Replies
