I have an application where I check whether a file exists and give user the option to delete the file. When trying to delete the file getting an error. Is there a way to release the lock on the file before delete?
Public Sub CheckReportExists() 'if report exists, do not allow to proceed
If File.Exists("C:Program FilesAstec IndustriesWM2000DailySalesReports" + ReportName + ".pdf") Then
[code].....
I have an application that currently stores PDF files (and others) inside the database as BLOBs. The trouble with this method is that I've now got SQL Server databases in excess of 200 GB! I've finally figured out a way to still enable full-text search without needing to store the PDF files as BLOBs (yay! Adobe's iFilter isn't great.), but I'm having trouble designing the method for a client to get access to the files stored on the server's file system.
I want to place the files in a restricted directory on the server, so I can't simply pass a UNC path to the client and let them open the file from there either in a browser or using Process.Start(filename). I understand how that would work, but if that directory has user access granted, all sorts of security holes open up, right?So, what I'm thinking about is a way to have a SQL Server account that has read/write access to/from the protected file system directory. That way (in my mind), the SQL Server can take a file as it's loaded in through the import client (as a series of byte chunks) and write the file to that area of the filesystem. Then, when a file is requested, the SQL Server can bulk load the file into a varbinary(max) field and do whatever I want with it.
1. How can SQL Server take a stream of bytes and write them to a specified location on its local file system? (This is assuming that I want the import utility to be able to be run on a client machine and not require it to be run on the server itself.)
2. Is there any way to stream a varbinary(max) file to a web page out of SQL? I'm using a lot of PDF files that will have Fast Web View enabled, so if I can stream the bytes to a web page, the user will be able to see the first few pages of the document while the rest is loading. I thought about having the SQL Server read (bulk load) the file from the protected area and write it to an unprotected area just long enough to point a web browser to that location, then wiping the file, but that brings me back to #1 above and would THEN require me to be able to issue a delete command from SQL.
I need to parse a Unix text file so, I am using System.Net.WebClient to ftp into a Unix server then using the .DownloadFile() method to get the text file, but its coming in with the Unix end line ""; so is there a way to convert that to windows format while doing the DownloadFile method? I do re-read it after and fix it, I am just looking for a better way.
Or is there an alternate such as instead of a DownloadFile, and the two other steps above can I just read it into an array right off the Unix server?? If so then what method would I use?
I want to know how to connect to a remote system having some shared folder.(ex, \myservermysharedfolder).Actually, I was supposed to copy a particular file which is available in a shared location of a system. To copy that file, first i need to connect to that system with an user id and password.I know copying of file (), But not getting clear idea on how to connect to the shared folder. I have tried with System.Management class, but no use..
View 2 Repliesa company offered me to develop a project for our attendence system in which finger recognition system is used. now i have quitely no idea that what i do and what do i do with this finger recognition system project.
View 3 RepliesI'm writing an application which has user authentication system, basically, when the user open the software, he has to enter his/hers username and password which are retrieved form a access data base, and if the user is set as admin then it enable some features, I couldn't figure out how to read the column lets say, IsAdmin table, which will store an value of 1 or 0 for example. I need a concept of how build a login system with levels or whatever you guys call it...
View 2 RepliesI have a project that I am working on and I just recently transfered it from an XP machine to a Windows 7 machine. Both machines are running VB Studio and the only thing that changed was I moved it from the XP machine to the WIndows 7 environment. I have not changed any of the code, I just transfered it and ran it to make certain nothing happened.
View 9 RepliesI am attempting to use the System.Management.ManagementObjectSearcher class in VS 2005 (see below) but get a error message for both the ManagementObjectSearcher class and queryObj As ManagementObject - Type ManagementObjectfSearcher is not defined and Type ManagementObject is not defined. how do I use this class in Visual Studio 2005?
Dim searcher As New System.Management.ManagementObjectSearcher( _
"rootCIMV2", _
"SELECT * FROM Win32_ComputerSystemProduct")
[code]....
I have a utility that is a simple exe that is not installed compiled with VS2005 and works well. But when I upgraded to VS2008 the utility can no longer locate files in the active system folder. I have UAC turned off and am logged in as the Administrator and it still can not locate a file that I can see in Windows Explorer. The file I am looking for is PakMgr.exe.
View 1 RepliesI have finished coding an application which I designed for people working in my office. When I started to install the application to computers at the office, I realized that, in some machines, application doesn�t work properly. Although it worked for 15 computers perfectly, for 3 computers following error code is displayed:
System.IO.FileNotFoundException: Could not load file or assembly 'System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified.
[code]....
WRN: Assembly binding logging is turned OFF.To enable assembly bind failure logging, set the registry value [HKLMSoftwareMicrosoftFusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.To turn this feature off, remove the registry value [HKLMSoftwareMicrosoftFusion!EnableLog].
I have a vb .net application where the user can choose a directory into which an excel file is written. If the user selects a system directory (yes, my users do this, don't ask me why) then a System.Runtime.InteropServices.COMException is thrown at runtime. I am handling this exception telling the user to please select another directory.
View 1 RepliesIn a windows forms application I am attempting to read a file from a share into a filestream.I then start impersonating and write the stream to another share that only my impersonation account has access to.This works fine for small files. But if I attempt this on a 90 meg file I recieve a "Insufficient system resources exist to complete the requested service" error on the following line:
System.IO.File.WriteAllBytes(myLocation,MyByteArray)
Full Example:
Dim ImageData As Byte() = Nothing
Dim fsAttachment As IO.FileStream = Nothing[code].....
i am working on my A2 coursework and trying to get the log in system working. I wrote a query where i ask the databse if there is a username entered and password. if there is, it will return the username. if there isnt it will stay empty. But how do i do some kind of if statement that if there is the username returned that it will let the person log in ? im really bad at explaining things here is my code.
So basically all i want is how do i make it to see if there is anything returned or not. (im sure the query is working)I am happy to try different ideas but this is furthest i got so far with this one spend like 3 days on this..
[Code]...
I have an application where I check the existance of a file. If file exists and I try to delete I get an error. Is there a way to release the lock on the file?
Public Sub CheckReportExists() 'if report exists, do not allow to proceed
If File.Exists("C:Program FilesAstec IndustriesWM2000DailySalesReports" + ReportName + ".pdf") Then
[code].....
I'm using System.Net.Sockets namespace for connecting to an ftp server. If a user has to login to a firewall first though, I'm not too sure what to do. The following is what I have working for logging into an ftp server without a firewall. (The Else statement) Do you know what I might add to the if statement? In the method where this conditional is, I am passing a firewall username and password.
m_tcpClient = New TcpClient
' Try to connect to ftp site
' If using firewall, login to it first then issue another command to log in to actual
[code]....
I am working on a VB Console Application that takes an Autocad drawing type DWG and converts it to a PDF using a shell command that calls a third party application. In this case, acmecadconverter.exe from www.dwgtool.com. Then the PDF that is created needs a unique watermark, so I call a second application for that called pdftk.exe from www.accesspdf.com/pdftk/.
Everything works as intended, except when I try file names that contain spaces. The file system object does not tolerate spaces in the drawing file name. For instance, the following command gives me a system.io.filenotfoundexception...
My.Computer.FileSystem.RenameFile("Test Flowchart1.dwg", "Test~Flowchart1.dwg")
It's the same problem for all of my File System commands. Either file not found or invalid arguments.
The complete script I'm using is here:
Code:
Sub Main()
Dim arrArgs() As String = Command.Split(","), _
i As Integer, folderPath As String, myPart As String, _
[Code].....
my advance project for the final semester of software engineering is an intruder detection system which is based on motion detection. I'm using a web camera in order to capture the images sequently and let them to process for further checking to see the difference.
first of all i want to know, is this possible in vb.net (image processing)? if it is possible, please give me some ideas about this to start.i have a brief imagination about the structure but i'm not sure about the success
I want to control all the processes of my system. for instance, whenever i start a new process, my application has to ask me whether to allow it or not. I should have control to either pause, resume or terminate the process. for eg,if i start IE, my application should ask whether to allow the process or terminate it. if i provide "allow", the process should run, either it should terminate. Can i use "process" control to do these stuffs? Or do i need any API?
View 1 RepliesHow to run windows application in mac system
View 4 Replies[2005] System.Configuration.AppSettingsReader
View 4 RepliesMy System gets restarts When i Install MS SQL SERVER 2005,
View 2 RepliesI need a clue where to start: how to create an icon that will show up at bottom right of explorer bar.. maybe I don't what its called. I guess windows named that "system tray icon".
View 3 RepliesWeird problem that just started, I am using an OleDbCommnad to create a dataadapter then fill a table everything from a .csv file, works fine except no dates are coming over? I added a datagrid view to my project just to see and any column that should have a date value is empty. I confirmed that the column is of System.DateTime value so I am at a complete loss?
View 7 RepliesI am storing images in a database. When I call the function to get a picture it returns an array of system.byte[]. How do I convert this to an image?I've searched for information, and found this page among others. But the code given doesn't work for me.
'Byte[] to image
imgMemoryStream = New IO.MemoryStream(imgByteArray)
myImage = Drawing.Image.FromStream(imgMemoryStream)
[code].....
how to convert system.string to char for label text?? Here it my
[Code].....
I need to get the strings from the site and input the fields strings in the label text, so I needs to convert char of system.string but i don't know how to fix it.
I have a laptop with vista and desktop with win xp. I am building the application on win vista but when i copy the same project and view it on win xp , then it only shows the fields that fits on the screen. the rest of the fields that needed to be scrolled on right , does not come at all. The project works fine on win vista. I even tried to tried publishing the project. it works fine on win vista but is missing some fields on win xp.
View 9 RepliesI use the System.Net.Mail namespace to send email messages in my application and I have a beta customer that reported that some characters were not coming through correctly on his CZECH box. I was not currently giving the option to the user to select an encoding, but I think that I actually should be.
View 6 RepliesI am developing an application using VB.NET ( VS 2005) for Transforming high volume of Data between 2 SQL servers. So I am using DTSObjectLibrary ( COM Objects). The Transforming of Data is fine.
I wanna use EVENT Handlers of the DTS Package. Some code available in msdn helped me. the Event is fired if I use MSGBOX() with in the Overridable Overloads Sub OnProgress . But if Wanna display the result in a Textbox or a Gridview It is not showing.
[Code]...
I am using memorystream to get and store images into sqlserver 2005 table image field. This process is working and I am able to display image in picture box. I need to be able to store PDF files into the same field and be able to display in a picture box.
View 2 RepliesI am a student of PGDCA. making a project of LIBRARY MANAGEMENT SYSTEM IN VB.NET 2005 VERSION.
View 4 Replies