Copy Opened Database - Application Gets It's Data From A Mdb-file And The Connection Remains Open As Long A Person Works?
May 14, 2010
The fact is I'm making an application, which users can install by using a Setup file...once installed the data in the database can be updated by a centralized server. To do this, they can insert a DVD/CD-ROM and export the necessary data towards it. I need to do it that way, because some of the users who really need this data will be using stand alone computers.The application gets it's data from a mdb-file and the connection remains open as long a person works with the application (maybe not the best way to do, but I know :-) )...when the user uses the application, he can perform an export...this exports the .ini-file and pictures (which works fine), but he also needs to export the mdb behind the application...I already tried connection.close() before and connection.open() after the System.IO.File.Copy...but that doesn't seems to work.
View 2 Replies
ADVERTISEMENT
Dec 18, 2011
During Runtime when it tries to open the connection it throws up this error.System.Data.OleDb.OleDbException was unhandled'
View 9 Replies
Sep 1, 2011
I have a WinForms application that I have taken over support for and it was build using Visual Studio 2005 with VB.Net. The application makes use of an Access database. It runs fine when it is installed as a standalone application, but the install cd for the application also allows for a network install and this is where I am currently encountering issues.
To test the network install I created a folder on my server (Windows Server 2003 SP2) and copied the Access database to this folder. I created a share for this folder and gave everyone full permissions to the share. Then on the workstation I installed the application and gave the path to the database as follows:
\myservermysharemydb.mdb
(The install steps here are as per the instructions given on the installation cd)The workstation that I installed it on is Windows 7 Ultimate. When I run the application, I get the error message given in the title when the application tries to read the database file. I have confirmed that I am able to write to the shared folder on the server, so I don't think this is a permissions issue. Also, the database file is not in use at all, so it is definitely not opened exclusively.
UPDATE:I have tested the workstation installation on a computer with a fresh install of Windows XP SP3 and it is able to access the database file without a problem. So it seems that this error that I am getting is somehow specific to Windows 7. Is there maybe a known issue with Oledb drivers on Windows 7? My version of Windows 7, btw is 32 bit.
View 1 Replies
Dec 23, 2009
my application will remain open after closing every form. This is a recent issue in previous versions my application would close. I call dispose(true) on all form closing/closed events. (some forms require it on closing instead of close because of some custom made classes.)?
View 5 Replies
Dec 23, 2011
I have a table I created in SQL Server Management Studio. I had to create it there because I needed to use a function for an alpha-numeric ID column that increments itself. I then exported the table, but had to use my local server. Now, in visual studio, I have the local server connection that contains the table I want to copy to a connection for a remote server. I can right-click and select 'Copy', but I can't right-click and 'Paste' into the database I need.
View 2 Replies
Mar 30, 2010
I've got a fairly large VB.NET (3.5) project that makes a lot of database calls. So I created a namespace/class just to handle those fuctions. The idea was that this single point of entry into the database would give more control over validating input from users.
So my class looks something like this. (I've chopped some code out for readability, it works just fine except for all the open connections.
[Code]...
So I can close the data reader, but how do I reach back to that original database class and close the connection. If I close it in that original class it will bomb when I try to loop through the data reader the in calling class.I'm sure this is probably pretty obvious but I'm fried from the keyboard.
View 1 Replies
Apr 21, 2009
When using SQL connections in my program, will I have to open and close the connection and the data reader each time I want to access the database ?
[code]...
View 1 Replies
Apr 6, 2009
I have an MS Access 2003 database built that resides on a shared network path at the company I work for.The database works perfectly for users connected directly to the company network.However, when a user tries to open the database while connected remotely to the company network (they can still access the shared path), they receive the following error:The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.At the time that they tried it, they were the only person accessing the database.They tried a local copy as well as a copy on the network shared drive.[code]
View 4 Replies
Nov 7, 2010
i am using access database for my program. now i have connected to the database in MDI form of main exe, and ir also works, user can log in, it gets verified etc etc etc. now here is the problem, when i load a form from dll and try to use any sql query on that form, i get message, "database connection is not opened". so what i did was, i added the connect() (a function i designed to connect to database) in the load part of the dll's form, it made the trick, query's started to run, everything went fine, and when i reload the form i.e after closing the form, i load it again from MDI form, i get error, connection already open..
[Code]....
View 3 Replies
Aug 12, 2009
Here's the (Timer1's interval is set to "1" in the designer, and it is set to "Enabled" in the designer as well.)
vb.net
Public timeElapsed As Int32Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
timeElapsed = 0
Timer1.Start()
[Code]...
The issue is, timeElapsed always comes back as equaling 0, so fileCopySpeed always equals infinity. Also note that test.dat is a 100MB file. There's no way it's getting copied in under 1 millisecond!
View 12 Replies
Jul 8, 2010
I've created a small DLL, an addin for Autodesk Inventor, this addin saves some information provided by the user and the program to an access(mdb)database.The whole idea behind this is that it allows users to quickly find drawings, assemblies and so on.The DLL works great on x86 systems however it has issues on x64 because I used ado.net.In a attempt to solve it I forced .net to compile it with the target x86 CPU settings.
However using this I'm unable register the dll (C:WINDOWSMicrosoft.NETFramework64v2.0.50727RegAsm.exe /codebase SavetoDatabase.dll )It says its not a proper .net dll file and therefore cannot be registered.
is there any other access-database connection provider (like dao or ado.net) that works on a 64 bit machine? Or do I need to change from mdb databases to another type (like mysql)? because sooner or later all machines its running on will be converted to x64.Or do I need to register the dll in another way?I've also tried to replace the conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0 with ACE, with no luck however
View 1 Replies
Mar 15, 2012
I made a quick search program so when I browse for a text file, it adds that text file to a listbox1. And then when you search result will be placed in listbox2 Now I'm wondering how to force the program to automaticly load last opened text file on startup.I tried with this and then I stuck.
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim reader As IO.StreamReader = _
New IO.StreamReader(winDir & "system.ini")
[code].....
View 19 Replies
Apr 19, 2011
I have a problem with a streamreader in visual basic 2008.I am updating a database from text files on an ftp server. The streamreader works fine until the file is more than 100,000 bytes long.It reads until it reaches this point and then just ends. No error message, it just reads to this point which happens to be 2 fields out of 6 in the database stream. My question is - does the streamreader have a limit? And if so what is a workaround?
Dim connString As String = "Data Source=" & pDataBase
conn = New SqlCeConnection(connString)
Dim strQuery As String = ""[code]......
View 4 Replies
Jun 5, 2009
Is there a better way of finding the path of a file that was opened with the open file dialogue? This is what I did. It works, but it seems like there should be a way to get the path through one of the open dialogue options.
Code:
'm_PicSource = OpenFileDialog1.FileName
'm_PicSource is a global var
Dim strCnt As Integer = m_PicSource.Length - 1
[Code].....
View 6 Replies
Jan 10, 2010
So I open files and do whatever with them right. I've set the initial directory to equal the last directory, but whenever I open multiple files, it never sets the directories properly. It acts as though nothing was opened there, so it takes the previous directory as the last one. Thoughts on what's not working? Here's the code.
Code:
With FileOpenDialog1
.InitialDirectory = LastDirectory
If .ShowDialog = DialogResult.OK Then
[code]....
I have multiselect enabled earlier and everything else works but this. When you open a single file, the last directory works fine. It only happens with multiselect.On another note, does anyone know why it freezes when I try to do a lot of files and use another program? I opened 700+ files to see what would happen. When I switched to a IM convo, it froze. When I left it to run, it worked.
View 3 Replies
Feb 16, 2012
I am running an application from my desktop as you see on the picture,and I don't know how to run File Save command on active form without mouse click,only with vb.application?
View 10 Replies
Apr 10, 2011
I want to make a program that looks like an address book (name, birth date, phone, e-mail etc) and stores all the persons data in a txt file. If I add a new person, for example, it will be added after the last person that was added in that txt file.
View 2 Replies
Oct 14, 2010
[URL] to create my sqlite db file. I created it as a sqlite db version 3 file. When I go to open the connection
[Code]...
View 1 Replies
Aug 8, 2011
I created a VS2010 application that stores data in xml files with a custom extension (e.g. ".ABC") I would like to be able to open an .ABC file and have the application launch with the specific file's data loaded. This is analogous to opening a Word doc and having Word open with the doc loaded. I have searched for a while but can't even think of a phrase that explains this process. Nothing seems to match "You know . . . that thing that happens when you double click on a data file".
View 2 Replies
Mar 24, 2011
I have a problem reading data from an RFID-reader. I connect to the reader by tcp and wait for DataAvailable to be true, then reading the data until I got a end of data character. Then I just go back and waiting for a new DataAvailable. This is done in a own thread for the function.
There seems to be some kind of timeout, If I don't got any data in a couple of minutes, then it just sits there in the do/loop waiting for DataAvailable. I hold the card to the RFID reader, it beeps, but there is no data available. I don't get any exeptions, and the information says that the clientsocket is still connected. Are there anything more I can check?
If I put the card to the reader in a minute-interval it seems as this will never occur. So 2-3 minutes idle:ing seems to do this.
Here are my code to read data from the socket, I have taken away some irrelevant code:
Sub test(ByVal ip As String, ByVal port As Integer)
' this sub is meant to run forever
[CODE]......................
View 1 Replies
Aug 14, 2009
I'm having this problem with a networked app in vb.net. If the program exits normally the port closes fine, however, if it crashes sometimes it remains open and I am unable to close it. The next time I run the program it is unable to open the port because it is already in use. Here's the exception: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted on how I can reclaim this port, or how I can close it? I tried using the reuse address socket option
[Code]...
View 7 Replies
Dec 13, 2011
I have a Main form, a Login form and a Splash form. In the project settings I've set the Splash screen.
System.Threading.Thread.Sleep(3000)
Login.ShowDialog()
If Login.DialogResult <> DialogResult.OK Then
[code].....
View 9 Replies
Aug 1, 2011
i have developed an application using OPEN XML SDK Tool 2.0 which generates Excel file. I have Data table of 100000 row and 30 columns and i want to generate excel file with these 100000 rows and 30 columns but it takes about 2 minutes of time to generate excel file. What can i do to reduce this time.
View 3 Replies
Apr 24, 2009
I have created a windows application which creates a database file and saves it to disk, it uses a custom file extension so that when the file is clicked it opens the application. In order for the application to use the data in the file it needs to rename the file so that it has a .mdb extension. My problem is that I cannot see how to get the name of the file which opens the application.
View 2 Replies
Sep 3, 2010
I am using a toolstripDropdownbutton on the toolstrip to populate the
menuItems.The toolstrip is on the customtaskpane of the window.
Problem comes when the focus is on the customtaskpane, user opens a dropdown menu and without selecting any menu from the dropdown click on the other part of the window. The dropdown remains open and even the user switch to other window it remains open and does not hide. It only hide when user click on the dropdownbutton itself.
Note : I had set AutoClose property to Flase
View 3 Replies
May 15, 2010
I've created an application that saves files with an extension of "*.pbca". When i click the saved file in Windows Explorer, it opens my application, as it should, but i now need the code that finds the file path of this file once my application has loaded.[code]...
View 14 Replies
Nov 20, 2011
Basically my script doesn't properly close Word, and it still remains open. Then when I try to run the script again it says its Read-only as its opened..What I need it to do is - put the TextBox1 info onto the DOC - and print it. I don't want it to save, as it's a template. I've tried saving it somewhere else as a "temp" to get rid of this read only but it still doesn't work.Another issue also is that it's trying to close the document before the printing dialog disappears, so I've had to put a timer
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim pName As String[code]....
View 8 Replies
Feb 20, 2010
I can't connect to my database now, although yesterday it was perfectly fine. An error message comes up saying "...A database with the same name exists, or specified file cannot be opened, or it is located on UNC share" this has never happened before. Why can't I access my database?
View 2 Replies
Sep 4, 2011
what is the connection string when the database copy paste in debug folder?I have a code connection string it's work but when i try to other computer cannot connect in to the database.
Try
If sqlconn.State = ConnectionState.Open Then
sqlconn.Close()
End If
[code]....
View 8 Replies
Aug 3, 2009
i made a program that is associated with the .map file type. What I need to do is find out the path of the .map file that opened the application(including the file name for the .map file).
View 13 Replies
