Is Storing Image File In Database Good In Desktop Application Running In Network?
Oct 21, 2009
I recently came across a problem for image file storage in network.I have developed a desktop application. It runs in network. It has central database system. Users log in from their own computer in the network and do their job.Till now the database actions are going fine no problem. Users shares data from same database server.
I recently came across a problem for image file storage in network.I have developed a desktop application. It runs in network. It has central database system. Users log in from their own computer in the network and do their job.Till now the database actions are going fine no problem. Users shares data from same database server.
Let's say 10 desktop shortcuts, all with different names/icons, point to and can start the same exe application from the same directory. Is there any means for the application to know the distinct name of the shortcut that was doubled_clicked. Also is there any means for a running application to know if it was started by command line, by a double_click on the exe, by a double_click on a shortcut that points to it, or by another process' call?
I am trying to use Setup project. Want my setup to create a desktop shortcut with my application.I donot understand how to do it. Clicked on User's desktop, I created Shortcut to User's desktop, changed the properties Target and Working Folder as 'Application Folder'But it does not connect with MyApplication.exe When I ran the setup and tested Desktop short cut, it took me to the folder where application was installed, instead of running the application.How to make the application run using this shortcut?
Basically back in VB6 days, I created several VB6 apps with Access as the backend database. I'd package my Access db file with the application setup, which copied it on to a shared network drive, and then different computers on the LAN could use the same backend database file, and that worked just fine. With SQL and VB .Net, I've done work with a SQL database hosted on a remote server, so you can basically build your query string easily and anyone can connect to it from anywhere, and it works just fine.However, what I'd like to do is have a local SQL express database as the backend for a VB .Net application and make a setup program that can install it in a way that it could be shared on a Local area network, without the user who is installing the application do anything.
I know about building a connection string with the local machine name, but I don't really have any experience with including an actual MDF file with the application. Does anyone know how it works, and is it a better approach? Does it work similar to placing an access file in a shared unc path?I know that ClickOnce (which is awesome) can install SQL express easily on a user's machine. However, the key is that I want SQL express to be installed only on the machine that is going to be the database server in a LAN enviornment, and not on every machine, unless it is neccesseary. And then how does your VB app know how to build the connection string to access the database from any machine on the local share?
Is there a way to determine if the application is running from an RDP session or not? Our staff has VPN access and use Microsoft's RDP Client to connect to their computers at the office. They mostly interract with software we've written. I'd like to identify those people that use our applications via RDP as opposed to being physically at their computer.
This is probably a pretty novice design question. I'm trying to work my way through a number of requirements and give the users the experience they're looking for.I've written a tool that does big calcluation-type things. It currently consists of a class library and command line tool (separate .NET projects.) We're using an Access database format as the file type because it can keep all the various tables together in one file. A few other items about the application: There are not many users. There are no concerns with scalability. There are not great concerns with updates. Desktop is desired. Not web.Using VB and .NET 3.5 SP1
I now need to develop a GUI front end that will allow typical File/Open and File/Save type operations.Users expect that they can open a file, edit it some, then either choose to save it or close it unsaved without any changes being written back to the file. Saving it would obviously save all changes affecting all tables back to the file.
Does it then make sense to use a temp file for something like a proxy then? To, when a user "opens" a file, copy the source Access file to a local temp file and then use that for the editing session? Then, if the user "saves", copy the local temp file back to the source path?
Update: [tagged with ms-access tag too] Also, I omitted the fact that users would expect typical File / Save As functionality too. I think the design I've put in question in this post is what is traditionally called the Proxy design pattern. Has anyone tried this (successfully!) with Access database files before? Words of caution or advice?
I have to store a image file into my Access database.
For that i've used 'OLE Object' datatype for my field. When i convert the image into byte array and tried to insert it, i got an error saying "Syntax error in INSERT INTO statement"
I want to know what datatype should i use in Access 2007 and how to convert the image to byte array in my vb.net code.
My code is...
Dim conn As OleDbConnection = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:DBHROsam.accdb") Dim cmd As OleDbCommand = New OleDbCommand("INSERT INTO Member (ID,mname,fname,image) VALUES (@ID,@mname,@fname,@image)", conn)
I am trying to store a .png image inside a database using SQL Server 2008. I have done this just fine using mySQL but for some reason it looks like this when placing it into ms SQL Server:
Our engineers use an application developed internally to perform risk assessments at a customers site. Sometimes on larger jobs a group of engineers will all carry out risk assessments together and will all need access to a single database file to all work on at the same time.
i would like to build an inventory manager application that would have two versions :1. Would run on the desktop 2. Would run on windows mobile 6 I would like to have both these versions store and read data from a database that can be stored centrally either on a webserver or somewhere on the LAN.
I would like to know can i use Access as my backend database or sql server ? will windows mobile app be able to access it and read and write to it Note : I would prefer to create only one database that will just store the details in the tables and do not need any other functionality. All functions such as save,edit,delete,search,filter etc with be done from the FRONT-END VB.NET interface ONLY If you suggestion involves the use of 2 databases such as one for desktop version and one for windows mobile then please also tell me how would i sync the data between them.
I am here to write a small database application that will be running in desktop (offline mode).I am using MSAccess 2007 as my database file and trying to write code in vb.net.I used to write the code vb6 an usually had global variables for storing database connection and executing every query from that.I am trying to upgrade myself from vb6 to vb.net.do i need to read some more simple starter books also?
I have been tasked to create an application, for which the requirements may change over time.This application will be a data entry Windows application,of which multiple copies will be running.All data will be written to text (.CSV) files for validation before being uploaded to a remote mainframe system (iSeries).My application needs to store certain variable information in an external text (or XML) file; for example, the file path to shared resources (which may change over time),as well as the specific data fields required by the mainframe system.
My questionsare these: what is considered the best practice for accomplishing such a task, and how would I accomplish it?I am completely new to XML, so I don't even know where to begin, although I am sure that XML is the path to follow for what I am trying to accomplish.
We don't want to get the password, we only want to store the user credentials so when they do work on the application we can apply their usernameto each operation and when they are done with an operation and do a digital signature by scanning their badge we want to compare the user's credentials with the stored credentials to ensure the user has logged in and is the current user.1. User 1 logs into the program using their username/password for windows.5
When I store a binary file in a MS Sql table & then retrieve it & write it back to disk the new file is always 1 byte bigger than the original file, no matter what the file type. Is this normal? The files all open fine in their respective applications, but I'm just wondering where the extra byte comes from & if I'm doing something wrong in my code.
Using con As New Odbc.OdbcConnection(conString) Using cmd As New Odbc.OdbcCommand("insert into mytable values (?,?)", con) Using fs As New IO.FileStream(filename, IO.FileMode.OpenOrCreate,
I am designing a desktop application that will be driven by local data. I am trying to determine the best way to accomplish this. The database would contain about 10-12 tables if I use a database and I would imagine no more than 10000 records in any one table (but honestly 99% of users would not have more than 1000 records). I am thinking about using SQL Server Compact.
Is this a good solution? I can certainly include this in my installation, but I am just wondering if anyone knows of a better solution? If this is the best solution, how would you suggest that I create the tables upon deployment? Should I just run "queries" with create table statements in them from my vb application or include a database file or what?
I am using Microsoft visual basic 2010 and SQL server 2008.I develop a small database application and it run well on my pc.I built and distributed the application to other pc on the same network, but when I run the application from other pc I got error message like this: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)[code]
i want some work with swf. the steps are: all these things i will do with desktop application
1) break the swf file in small parts and store in any database or put these parts on physical path but in that case all swf part should be encrypted so nobody run these files with click.
2) run that parts from memory ( any of these part is not run with mouse double click ) with vb.net application
i read delphi can do the streaming of swf. so can it possible with .net
We have a Windows Forms VB.NET application running on Windows Server 2008. Users access this app using Remote desktop.The app displays information in Excel, but Excel opens on the server.Is there a way for the .NET app to launch Excel on the users local desktop?
We have a windows service running under a network account that calls and runs an ActiveX exe. The exe is running under the local system account, not the network account of the service.
Using Visaul Basic 208 Express. I have running serial port communications with send and receive texts shown in a richtext box. I would like to store that data in a text file for later review.reate such window text file to store all data sent and received from the serial port in all events. I would like to have that file accessible through a button in the form. Also, the file should store all data in all events, i.e. same file needs to be opened so all data accumulated in all events
I am working on a project based on networking. My problem is that database on server (time to time updated by clients Application) is available in shared folder sometime any client delete that database file from shared folder then project stopped working. So give me process for accomplish this problem is there any way through which is database on server work invisibly and client unable to delete that file. I tried read only attribute on shared folder then my project unable to insert record in that database file.
I have this code that creates a template and stores that template to a local database and I want it also to store in a network database but I'm having problems on the other end it seems it's not storing the right data.
Server side Dim cnString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=|DataDirectory|fp.mdb; Jet OLEDB:Database Password = joceradmin" Dim fpFilename As String Dim userID As String userID = InputBox("Please enter ID number to enroll", "Enter ID Number", , 100, 100) [Code] .....