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] .....
the new program I'am developing will enable the user to customise form and text colour.hese settings are to be applied to all forms used throughout the System.The method breakdown is as follows:1. User selects colour of form and text through hovering over a rectangle object of relevant colour.2. That information is stored to a text file.3. As the system is accessed again at log on, the settings are applied to all forms.
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'm working on saving a database(excel) in GUI. I have a button that link to an excel file that is saved in my desktop. But when i click on it and change the details in the excel file, it can't be saved. [Code]
I've got a SQL Server and I need to save files somewhere and I guess I hsave two options
1. Save the file path
2. Save the file in the database.
Issues with option 1 are for complicated reasons the file path is not the same for everyone. I'm talking about saving 200-400 per month, is there any issues with saving them into a SQL Server Database that is used by internal employees only?
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.
How can I save a file to a folder on a network drive. I have the drive mapped on my pc as "G:" but someone else could have it mapped as "Q:" or something. I can save if I use "G:ServerNameDriveNamefolder"; but can't from another pc unless I change the code to what the drive is mapped to on that pc.
Here is the code I'm trying to use to direct to the folder with out using the mapped drive:
Code: Private Sub Button9_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button9.Click FileOpen(1, "\ServerNameDriveNameFolder" & filenamec.Text, OpenMode.Output) 'location of the file.
I teach using VB. At the moment the kids are having to save their projects to usb drives because VB does not see the network folders on the fileserver. They lose the usb drives. The kids do not have access to the c: drive by Group Policy. How can I set up VB.net to see the their network drive folder?
I am trying to store the filepath of uploaded files in a sql server database using vb.net. I have run the code at it uploads fine but nothing is being added to the database.
Protected Sub btnUpload_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnConfirm.Click If IsPostBack Then Dim path As String = Server.MapPath("~/UploadedVideos/") Dim fileOK As Boolean = False If FileUploadVideo.HasFile Then [Code] .....
I want to upload a text file to a table I have in my database. I have never done this kind of a thing so I don't have any clue. The column is in longblob.
I've had this problem with both VS 2010 and Visual Web Developer 2010. I want to save my projects on a network share (which I have as a mapped drive), because our network drives are backed up daily. For some reason though, VS only shows local drives when I try to save a project - all my network drives do not show up.
1.is it possible to save the database connection string to the textfile so that user would be able to know where the database is stored? 2. Any way to let the user decide where the database is stored? Since usually we, the programmer write the database connection string ourselves..
So I am working on a small program that will tell the engineers the status of their testers; whether they are up or down with the time and date in addition there is also a comment box. I have created a program that has all the right buttons and options. Where I am stuck is on the save option. I want the engineers to be able to make changes to the status/date/comments and by clicking the save button to save all changes(in the status and date boxes) and text(in the comment box) so that when the program is opened at a later time or by another user on the network from a diffrent work station the latest changes from whomever will be present. The code that follows only allows the changes to be seen by on that specific computer and they are not shared to everyone who uses the program that accesses it over the network. Any help would be awsome!! Hope this is clear!
How can I get it so everyone sees all changes over the network regardless of the computer they are using? any help would be amazing!!
Friend Class CellValue Public CellColor As Color = Color.White Public CellShape As Shape = Shape.Blank Public CellName As String = "" End Class
Then in my main I make an array of CellValue but I want to know if the values are also being passed down with the array.
Dim Plan(SizeW - 1, SizeH - 1) As CellValue Dim CellW As Integer = PictureBox1.Width \ SizeW Dim CellH As Integer = PictureBox1.Height \ SizeH
[Code].....
Are CellName, CellShape and CellColor being tied to each element in the array?. The reason is because I need to use these properties to tie certain functions to them. The CellName should have a MachineID which I would have to use to pull some info from a Database.
The Array should also be serialized and deserialized to XML as customer needs to create/edit and delete certain values in the array. And in order to save the array has to be in XML
So the Questions are does it save the CellName, CellShape and CellColor for each element, will it be affected if I serialize and deserialize using XML. If possible, how can I call up the Cellname p.e for a specific array element.
I have developed a VB.NET program using a strongly typed dataset. This dataset has its connection to a SQL Server 2008 R2. The software should now be additionally used offline. The database should be exported to a *.sdf database. If no connection to the SQL server is produced, the software have to try to connect to the *.sdf database.I would like to achieve:
1. Export the data in the SQL Server 2008 R2 database to a local *.sdf file.
2. This *.sdf file has to work as an alternate connection string in the strongly typed dataset.
Currently I am saving data from my applications by saving a text file via a stream reader as a string. I have come to a problem. In my current application, I have an array of the following structure:
Here is my idea so far: I have a bunch of computers connected in a local network. One of them is a MySQL server, one will have a vb.NET program wich will act as a "second server" and the rest will be different clients. What I want to do is that the "second server" will send out some kind of message or network package to some of the clients in the network, and they will execute a code based on what message it is, or what kind of package it is. I'll give you a simple example:
I am trying to copy a table from a network database to a local database. I used DAO and could check if the network table existed using a function that tried to assign a TableDef object to the table in question. If there was no error then I assumed that the table existed and the function returned true...Or it would error out and return false.I could then proceed with the copy or not as the case may be.I am converting the code to ADO.net and need to know how to check for a table. [code]
Public con As New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Tramsco\Tramsco\payroll.mdf;Integrated Security=True;User Instance=True;MultipleActiveResultSets=True")
as my connection string and when i run the .exe from the other computer to access the database on the host, it gives me this error:
An attempt to attach an auto-named database for file C:\Tramsco\Tramsco payroll.mdf failed. A database with the same name exists, or specified file cannot be Opened, or it is located on UNC share.
but when i use the computer where the program is, i can run it with no problem.
I'm just getting started with VB.NET and SQL Server 2005. I have VS2008 installed on my machine. My SQL Server is in a domain that my machine is not a part of. Here's my code that I'm using to establish a connection:
Dim conn As New SqlConnection conn.ConnectionString = "Server=SQLServer.hbug.lan;Initial Catalog=HUGRegistration;Trusted_Connection=True"
This code is part of a console app. that I'm using as a test. I'm just trying to set up a simple connection and then read data from the database. When I run this console app. in VS, the program hangs for a few seconds and then I get an error "SQLServerProvider has stopped working". My options are Debug or Close program. When I choose Close program, then an error pops up in my console window "Error: Unahandled Exception: System.NullReferenceException: Object reference not set to an instance of an object. I assume this error is spawning from not connecting to the database properly.
im creating a program that will connect to a database (not local).That database will be access by everyone of my officemate for our data storage.The problem is the sample for creating a database is it make use of lacol database which can only be access by single user.how connect to a database later on after my deploying my application.
Scenario1:
interface program created: DONE User input interface created: DONE
Database created(but not yet connected to the actual application): DONE
Scenario 2:
Program Deployed :DONE
Scenario3:how can i connect to the Database i created with program i just publish/deployed?
something like that i have a command button then it will open a dialog to locate an existing database then connect to that database (ms access database or sql database created in - creating database sample).
how to do a database a network? in a library system, when the student searches a book in a datagridview then, when they borrow books, they click the borrow then it borrows. Then it would reflect the students name and the book that the student borrowed in the librarian form. how is that?
for my vb project, i have to develop a system for a network environment. it means a central database to the application. i don't know how to do that. i am hoping to do a sql database. guyz please help me to do this.if you have any tutorials or any of your advices, will help me a lot.