I am using VS 2008 with SQL in express edition . I have made my website and hosted it on server with cuteftp .Now i want to change
the website so when i tried to delete all files the App_data folder does not delete .
So i am unable delete my mdf and log file which are in this folder. It says file error.
I always use SQL in design window in VS and know less of coding in SQL.
I tried this code by inputting the ftp address as ftp//: and the correct username and password and I get the following error
"Unable to connect to the remote server" on line :
FtpWebResponse Response = (FtpWebResponse)Request.GetResponse();I tired this on my ftp server provided by a hosting service and an anonymous ftp located at 193.166.120.5 ?
Note: I was able to connect to both of these ftp through filezilla, via a webbrowser, and through windows command line.
How to delete a file in server with out access denied error? Because File.delete(path) is working locally once if I put in IIS and access the application from another computer I am getting access denied error while deleting the file. How to resolve this.?
View 1 RepliesI have a web site that you can upload images, the image path is saved in the ImgPath field in the data database and retrieves the image and displays it in the grid view. I want to be able to delete the image from a folder within my project when I delete the record. I'm trying to delete it from the Detailsview_ItemDeleting event.
View 4 Repliesi am downloading a file from a server and i plan to delete the file that i have downloaded on the server after it gets downloaded on the client side. My download code is working fine but i dont know when to put the command to delete the file.
string filepath = restoredFilename.ToString();
// Create New instance of FileInfo class to get the properties of the file being downloaded
FileInfo myfile = new FileInfo(filepath);
// Checking if file exists
if (myfile.Exists)
{
// Clear the content of the response
Response.ClearContent();
// Add the file name and attachment, which will force the open/cancel/save dialog box to show, to the header
Response.AddHeader("Content-Disposition", "attachment; filename=" + myfile.Name);
//Response.AddHeader("Content-Disposition", "inline; filename=" + myfile.Name);
// Add the file size into the response header
Response.AddHeader("Content-Length", myfile.Length.ToString());
// Set the ContentType
Response.ContentType = ReturnExtension(myfile.Extension.ToLower());
//// Write the file into the response (TransmitFile is for ASP.NET 2.0. In ASP.NET 1.1 you have to use WriteFile instead)
Response.TransmitFile(myfile.FullName);
// End the response
Response.End();
}
Now i know the response.End() will stop every thing and return the value, so is there another way too do so. I need to call a function
DeleteRestoredFileForGUI(restoredFilename);
to delete the file but dont know where to put it.. i tried putting before and after Response.End() but it does not work.
I am running a SP that entries that are older than 6 months. These entries have a file associated with them. Is there anyway I can delete that physical file with SQL server too? Its a Win2K3 server with sql server 2000.
View 3 RepliesThis issues has been driving me nuts. I am trying to follow the tutorial on [URL] I am trying to connect to a database in Microsoft SQL Server 2008. The way I do this is by right clicking on the "Data Connections" > Add Connection. Afterwards the Add Connection window comes up, I make sure my data source is "Microsoft SQL Server (SqlClient). And, I choose a server name; the only server I can choose is DomainSQLEXPRESS. The issue is when I go down to the "Select or enter a database name" drop down box, I do not see my database listed. I have also made sure in the SQL Server Management Studio that I have given my user all the privileges for the database. I know my explanation is kind of vague, but would anyone know the reason why I would not see my database?
View 3 RepliesI don’t know where to put this Query.
I am trying to open .dbf file from the server for which I have written below code.
Now, the problem is connection string accepts only physical path from the client machine where as I want it to pick file from the server.
System.Data.Odbc.OdbcConnection oConn = new System.Data.Odbc.OdbcConnection();
oConn.ConnectionString = @"Driver={Microsoft dBase Driver (*.dbf)};SourceType=DBF;SourceDB= http://localhost:1308/CNCScheduling/...;Exclusive=No; Collate=Machine;NULL=NO;DELETED=NO;BACKGROUNDFETCH=NO;";
oConn.Open();
System.Data.Odbc.OdbcCommand oCmd = oConn.CreateCommand();
string sPathApp = Request.ApplicationPath.ToString() + "/";
string sPathFull = Request.Url.OriginalString.ToString();
int iPathFullLen = sPathFull.ToUpper().IndexOf(sPathApp.ToUpper());
string sPathPrefix = sPathFull.Substring(0, iPathFullLen) + sPathApp;
string sRPTFile = "XABCL.DBF";
string sCrvPage = "D:\databases\" + sRPTFile;
oCmd.CommandText = @"SELECT * FROM " + sCrvPage ;
DataTable dt = new DataTable();
dt.Load(oCmd.ExecuteReader());
I have a file delete option for the files uploaded by the user, user can upload many files at a time.The uploaded files will be stored in a folder in server and when its is deleted its is moved to trash folder from where it will be manually cleared.
when a user tries to delete many files in the web page IIS get hangs and all session is expired. This case only present in server,in local host this issue is not available.
ALL the operations is carried out completely ie
Database gets updated. Files is moved from upload folder to trash folder in server.
I cannot determine what is going wrong,I just tried to delete many files totally around 35-36 MB. Is the issue with process taking long or is there any changes have to be made in order to perform large files operation, my project is done on VS2005 which is running in 2008 server.
I a webproject in asp.net my project worked fine in my pc but after uploading it to a iis server it is not working.My webproject is to delete a file,
string s;
int i;
s = Environment.GetEnvironmentVariable("temp"); ;
[code]...
I'm getting tired figuring out this error. Well, Basically. I have uploaded my ASP.net website to a server (IIS installed) as well as the VB project I made.
BOTH are connecting to a DB named CLIENTS.
the website uses a datagrid to show data, while the VB Project updates the DB based on a monitored folder.
The Problem is If the website is opened first the VB project shows an error "Unable to open the physical file (MDF). Operating system error 32 (error not found)" and Vice Versa if the VB project is first started.
I have a link http://Test/Folder/file1.xls which is working fine But if I typehttp://Test/Folder/file1.xlsx it is not working. It is giving me a file not found error.So when I read online every one is suggesting me to add the correct MIME type at tyhe IIS level. I don't know if that's the correct thing to do.I opened IIS and navigated to folder FOLDER right clicked and selected properties -> HTTP Headers -> MIME Types->New -> Extension -> .Xlsx-> What should i be entering for MIME type?
View 1 RepliesI have a solution file which has 3 projects in it, which was developed in VB,VS 2003. when i am trying to open the solution file, framework is able to open the 1st and 2nd projects but for the 3rd project it was showing an error "Unable to get project file
from web server".
I have previleges to create folder and create files in the remote windows 2003 server. But I am not able to create im ny Website.
View 2 RepliesI have problem while try to play a swf file from server.
i am using this below code :
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" width="640" height="418" id="csSWF">
<param name="movie" value="FPM_Overview.swf" />
<param name="quality" value="best" />
<param name="bgcolor" value="#1a1a1a" />
<param name="allowfullscreen" value="true" />
<param name="scale" value="showall" />
<param name="allowscriptaccess" value="always" />
<param name="flashvars" value="autostart=false&thumb=FPM_Application.jpg&thumbscale=45&color=0x1A1A1A,0x1A1A1A" />
<!--[if !IE]>-->..........
But this above code work in my local development version , When i try to open from my domain like: http://domain.com/Files/ sample.swf ,not play the file but it show the timing of the swf file then the slider and info icon of the player.
Am also try to open the swf file using html file from the same domain,it not working.
i have a site that will enable users to download an ebook file.i have successfully built architecture to enable users to download pdf and txt files, but it won't work when i try with a .mobi file, even though i know the file exists.the site works by allowig users to upload their work as .doc, .docx or .odt. once it's verified, the site publishes it as .pdf, .txt and .mobi and makes it available for download. the download code is...
string mstitle = title.ToUpper();
string dlpath = [the server path] + msid + mstitle + ".mobi";[code]....
(there are also versions with .txt and .pdf) the file definitely exists at the location in .txt, .pdf and .mobi extensions. however, the .mobi version simply won't work i get an error 404 resource not found. mystifyingly, the pdf and txt versions work perfectly.
I'm running into a problem trying to download a file from the server. I'm receiving a IE 8 "Unable to open this internet site" error dialog.
Basically, I want to open a new page and pass in the file path and mimetype of the server's document using a query string.
My code is as follows:
[Code]....
The JavaScript:
[Code]....
This is the code of the page load event that will transmit the file:
[Code]....
is possible to insert and delete data in database sql server from global.asax? How to make the connection string? Does anyone have any examples? it is difficult for my level.
View 3 Repliesthe application which i created is a web application which doesnt need much of a database,so i am just using the sql express free version which allows 4 gb of data,to avoid disasters iw ould like to delete records which are very old like,1 month,2 months old etc,how can i do this periodically should i do this on client side or the server side...
what id there are 100000 records and if we put this in page load or some method,it could take some time to delete,which i dont want..... how i can automate this process at the server side only
I had this one working a while back i try to upload file to my root folder it works locally but when i try it from my website i get the following error: exception details: system.bet .webexception. unable to connect to the remote server
the code bomb at the following line
requestStream = uploadRequest.GetRequestStream() 'This is where the exception occurs
fileStream = File.Open(localFile, FileMode.Open)
[code]....
I have a .Net Webservice(2.0 framework) and I am trying to call this service from SQL
server 2005 using CLR.
I have created assamblies on server and trying to call the we service through CLR, but I'm getting below error:
"Exception:
Server was unable to process request. ---> Invalid URI: The URI is empty."
I am having issues debugging locally within Visual Studio 2010 on Server 2008 R2 (x64) for a new ASP.Net MVC application. I am able to debug using the VS Development Server (Cassini) but when I change to use the Local IIS Web Server and Create Virtual Directory, I am unable to debug. I get the standard VS message:
"Unable to start debugging on the web server. The web server is not configured correctly. ..."
Everything looks standard in IIS. The Default Web Site is running under the ASP.NET v4.0 application pool. The virtual directory that Visual Studio created is running under the same app pool. I am running Visual Studio as the Administrator account. It feels like some security setting or something is preventing this to work but I'm at a loss to what it could be.
I am unable to restore database in form of .bak files using Microsoft SQL Server Management Studio Express.It gives following error message:
Too many backup devices specified for backup or restore; only 64 are allowed.
RESTORE HEADERONLY is terminating abnormally. (.Net SqlClient Data Provider)
I am unable to connect to my local instance of SQL Server 2008 Express using SQL Server Management Studio.I believe the problem is related to a change I made to the connection protocols. Before the error occurred, I had Shared Memory enabled and Named Pipes and TCP/IP disabled. I then enabled both Named Pipes and TCP/IP, and this is when I started experiencing the problem.
I have now set Named Pipes and TCP/IP back to disabled. When I try to connect to the server with SSMS (with either my SQL server sysadmin login or with windows authentication), I get the following error message:
"A connection was successfully established with the server, but then an error occurred during the login process. (provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)"
My first question here is: why is it returning a Named Pipes error? Why isn't it using Shared Memory? It seems like it is not listening on Shared Memory for some reason?When I set Named Pipes to enabled and try to connect, I get the same error message.My windows account is does not have administrator priviliges on my computer.
i just install the sql server 2008.today i try to open sql server management studio for create database, but once i open, a box say connect to server,when click connect,the error 18456 show.May i know what is the problem?my object explorer also doesn't show anything.my pc is windows 7.
View 6 Replies