I'm trying to figure out what would be the best way to have a history on a database, to track any Insert/Delete/Update that is done. The history data will need to be coded into the front-end since it will be used by the users. Creating "history tables" (a copy of each table used to store history) is not a good way to do this, since the data is spread across multiple tables.
At this point in time, my best idea is to create a few History tables, which the tables would reflect the output I want to show to the users. Whenever a change is made to specific tables, I would update this history table with the data as well.
I have made this history window showing the history of the user on the browser via a database.On opening however, the window freezes with the Histroy button pressed and stops working. here is the code.
We are creating a Who wants to be a millionaire style game in VB. Our server is pulling information such as questions and answers from a Access Database and sending them to the contestants (Clients). All transfer of information is directly from the server to each client. One of the "Life Lines" we want to use is "Ask a friend", where one client is able to Instant message another client for a short time to get help on the question.
Im a beginner at vb.net, and just wanna ask if it is possible to make a vb.net app/client app that can connect to a database on an online web server???The app is locally on the client computer and the database is uploaded on the web server/host together with its website.
i an encounting this problem that is...my database is unable to access in client pc and its comes out this error: cannot open database "synonym" requested by the login.The login failed. Login failed for user 'SIDNEY-U1KECH4Tsidey'.
For example, i installed the windows application in more than one pc. All the pc's are in network. I want to save the data in a single database. How it is possible?
I'm creating a VB2010 application which will require a connection to MSSQL. Should I Install SQL 2008 on my computer then use MS SQL 2008 as my data source or skip installing SQL 2008 and use MDF instead?
Also the program must have the following requirement
Program must use SQL as their database source End user must not install SQL server on their machine Program must be able to update (sync) the local SQL database from SQL server on the web. (User will have option to delete everything on their local database and load everything fresh from the server or to merge the update with existing data) Programs will (most of the time) run in an offline environment. When the user have access to internet they can update the database The program must allow user to add,edit, delete their local database while offline Only certain user (authorized user) can update their local database back to the serverC
Is it possible to created a program that meets all the above requirement ?
I would like to create a server program that accesses an "ms access" database. I will also need a client program that connects to the server. The reason for this is that the server is a mediator for several clients. Since I am using access, I plan on maybe having 20 or 30 clients connect to the server only. The client will have access to a virtual market. So when a person buys or sells something on the market, the server mediates the transaction and etc. At the same time, the access database saves each clients data as well as the overall market data.
I wrote a program in VB2005. It is a program that is supposed to run in a client computer accessing an MS Access .mdb file stored in the server. The program itself is stored and run in the clients computer. I am not good in networking at all. The way I do it now is:
1. Have a directory made in the server to hold the MS Access .mdb file, and have the directory to be shared.
2. Have the same directory accessed and mapped in the client computer (say to Z:)
3. Then have the program in the client computer simply access the database as if it is in the same computer (as the directory already mapped into the client computer). In the VB 2005, this is done when we set the connection string of the database connection.
However, my user is complaining that by doing so, the database is basically exposed to the operator of the client computer (through the mapped directory), hence more vunerable for any bad intentions from persons who may have access to the client computer but not the server. He insists that he used to have a program that does exactly the same thing like my program, but the database is shielded in the server, where it cannot be seen in the client computer (I have other people who confirm that this can be done, though they can't tell me how, since they are not programmers themselves). Now, I have no idea on how to connect a database that way, and I don't even know where to start looking.
We would like to create a client-server architecture application that the server can control all client computers connected to it (e.g shutdown) and we would like to put a security login and a desktop lockeron the clients. The process of the system is that when the clients starts, the desktop is locked and ofcourse the user can't access the desktop unless he/she logged-in. And when the scheduled time (e.g 1 hour) is done, the client computers where automatically shutdown like the Time Logger Softwares
i am doing school software projects in windows application. now i want to install. this project to my client place. i can able to convert my application in to EXE using setup project. The problem for me is the database. i am using sqlserver 2005. i don't how to install my database and table into the client computer. is there any way to copy the database. if anyone have any idea about how to install my database i have create for that application into client computer.
I am currently working on a Database that collects information. Firstly, i use a new windows form to collect that data. I have it set up to where, when the form loads, the database is ready to collect the information fields. And then the form closes on the button click to add that data, it does not update that data table view. It adds it once i close the program and debug it again.
Code: (Open the windows form) Private Sub btnAddNew_Click_1(sender As System.Object, e As System.EventArgs) Handles btnAddNew.Click AddNewClientData.ShowDialog()
[Code].....
Problem two: I need to make a button that will increment a cell that was set as an Int, by one, but can't figure out how to put it into code.
I'm developing a remote control program that uses a mysql database as the bound beetween the server and the client.The only problem is that cause of mysql being really varnuable to crashes i made it in a way that it checks for information every 10 seconds so things doesnt get messy. [code] For some reason after 10 seconds the connection is mysteriously aborted and the reader gives a fatal error.How can i extend the time limit to >10 seconds ?
This is my first client server application using vs2008(vb) + sqlserver 2008. how can i hide my database schema,tables from application users through management studio..?
I am a student and trying to start a programming career, my colleague asked me to make a multi tier or multi client desktop application for the schedule tracking using xml as a database; however the desktop application would be deployed in one or more computers but my leader can monitor the info from her office in addition she wanted me to put administrative privilege to avoid unauthorized access in some database features of the system. an info regarding multi-client desktop app.
I have been reading through Atheists posts in regards to client-server and TCP client/server connection's. But how do i go about writing a program with 1 client and server where the client side creates a text file.Once the server sees there is a text file it connects and downloads it to itself or the client pushes the text file to the server.Once on the server i will read the text file and put its info into a sql db.
I have an application that takes a series of reports and sends them as attachments in an email to a specified group of email accounts.
When I run the Java version of this using apache commons and the same setting, the email is sent. However, when I run the VB.NET version of the code, it fails on my local machine and on the client machine.
I have a VB.NET web application running on a server that uses similar code. I tried that code locally and it fails. Yet, the web application is working perfectly.
Why is it that the Java application can send the email, but the .NET application cannot?[code]....
Im using the code from [URL] as a starter, most of the code is the same. the chat system works fine but on the client a added a disconnect button "clientSocket.Close()" and as soon as i click that i get errors, on the client, this is the code...
Private Sub getMessage() For infiniteCounter = 1 To 2
[CODE]...
And this line...
serverStream.Read(inStream, 0, buffSize) gives me "Unable to read data from the transport connection: A blocking operation was interrupted by a call to WSACancelBlockingCall."
Now im talking the server, after the client clicks disconnect or closes by task manager, looses connection, etc the server crashes and gives me.
How would I go about clearing IE's history from with VB? I've looked on the internet and couldn't find anything, and I honestly don't have a clue about how to do it.
I am a still a beginner at this so bare with me. I have made a web browser which is my starting point in VB. Now its fully functional and has history and all that. And i am using tab control as the browser part. History works when the go button or enter key is pressed but I can't get this to work when a user clicks a link.
Public Class Form1 Dim int As Integer = 0 Dim tabs
Im working with vb2010 with ms access as its database and a newbie into programming. is there anybody who have an idea how to make a log in history.. i mean whenever you specify date from..to.. (e.g 01/02/2012 to 01/05/2012 ) on ur filter command it'll display on a listbox the user who logged in at their specific date and time and what they have accessed inside the program.
list of URL for the web pages requested by the user should be maintained. The user should be able to navigate previous pages requested by clicking on the links in the History list. On the browsers start up, the History list should be loaded to the browser.
