I use Visual studio 2008 I use MYSQL 5.1 I want only to backup database Test to to a specific directory.I use the application settings to determine which directory(see attachment).Green shaded code works perfect.
Red shaded code works not!! This is with My.settings.I can not see the error code, it goes too fast, I can not capture this with:
In vb.net how do you check if a ANY directory exists inside a directory I would need to know if there is a folder inside the c:windows directory (WITHOUT knowing if there is ANY directory is in there).
I am trying to find a specific file in a specific directory and then i need to get the full path of the file.Is this possible i cant find any help topics about a specific file.
Is there an easier way to test if a file system item is a directory than using bitmasks?I have this code in one of my applications (two second line is actually in a loop over folderItems but for simplicity assume the first element):[code]This works, but is there an easier way than using bitwise AND with 1000 (base 2)?
before re-inventing the wheel, i want to ask you how i can do this best: I have a VB.Net application that uses a database connection to MS SQL Server 2005 (express version). There are users that input data with the application into the database lets say once to 2x an hour to once a minute. I want to do backups like this: Once a day or once a week (in the evening) a full backup, and whenever the program/user is idle for lets say 10 Minutes, i want to do an incremental backup (so that it does not take so long until he can work on after the backup).
There are no big security issues, just copying the backup data files to a network share / a different computer or server would be fine. i guess the average db size may be 300MB, but the daily increments about 1MB.
I have and excel invoice temple, I need to fill this temple with information that I will get from a test file.So I need to read the test file and then fill specific cell in the temple.
I finished every piece of code in my program save for one tid bit, how to pull two numbers from a text file. I know how to pull lines, I know how to pull search strings, but I cant figure out this one to save my life.
I've had a search through a number of extremely useful articles on the forums, however rather than reinvent the wheel I thought I would ask if anyone already had what I am looking for..A simply little VB app that opens a session to a specific IP port and then writes to a test file everything it receives. If the connection drops, simply re-stablish it and keep listening for text to write to the file.
I am using vb.net and sql server 2000 for developing windows applications. I want to know how to take the backup of database for after each and every transactions. is it possible? if possible,
First off I am programming a hotel booking system for my college computing project. This consists of a bunch of windows forms coded in Visual Basic, and an Access database stored locally. The application gets information for the forms about customers, bookings etc... from the database.I would just like a way of making a complete copy of the database (.mdb) file and placing it into a user selected destination.
I want to backup and restore the database by using vb.net.I have a problem here..This dialogue box appear.
" [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open backup device 'C:Documents and SettingsSMy Documentssales.Bak'. Operating system error 5(Access is denied.). [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally. "
I am visual studio 2005(VB.NET) and MYSQL 5.0 as Database. I want to Backup my Database. I am using the following but the result is in 0 KB.Process.Start("C:Program FilesMySQLMySQL Server 5.0
inmysqldump.exe", "--user=root --password=root --host=3306 --databases MySQL hospitality -r ""C:BackUpDataBase.sql""")
My application has an access2007 db as its database. I am trying to create a backup/restore utility in my application that allows the user to take the backup or restore the database file "StudentsData.accdb" which is in the application folder. I tried the filecopy method but it gives me an error saying that the "file is not accessible, as it is being used by a process." I believe it is my application process that is using the file.
How do I stop my application accessing the database? I have database connections which i have written in code and all of them close with their respective forms.
i have a problem with using vb.net application, i want to take backup of my database from my vb.net application so that user clicks the button and backup can be copied in a drive .
I'm working on a Warehouse Item locator. I use an Access database for all the information and I made a backup so after all the change are made, I can keep a copy of the database in case something happen.
What is the best method to backup a sql database.Would it be simply to copy over the database to a seperate location or is there a proper sql way of doing this?
I am using vb.net and ms access for developing windows applications. I want to know how to take the backup of database for after each and every transactions.
Or anybody can tell me : HoW can create storeprocedure which contains this code.I created a store procedure but it cant be saved.If i create a storeprocedure which contains this code then problem will resolved.
I'm creating a program with database and it almost done. The only one thing that left is the backup and restore of database. I don't know how to do this.
I want to Backup my Database to a location and restore it afterwards. The problem is , i want to keep my program open. I seem to have a problem with this, the connection stays open. How can i do this , close connection and open it again without data loss?