Any Type Of Database That Could Serve Purpose Without Giving Sharing Violation Error?
Jan 25, 2012
My problem is I need to develop a sales application to be used on 5 computers. The database needs to stay on a main computer and other computers should connect with that over LAN.I donot want to use SQL Server as it is too complicated to give permissions, setting up firewalls etc. for the end user.Is that any type of database that could serve my purpose, without giving sharing violation error?
I was writing a small test to verify loading and editing a bmp file with a process and MS Paint. If I load the file image into a picturebox before I run the process MS Paint reports a Sharing violation on the file during save. If I Leave the Picturebox empty MS paint allows the file to be saved.
Below is my snippet. I assumed setting the picturebox image to something else would fix the problem. I does not. Looks like something is still holding its finger on the file.
Code: Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load ' Remark the line below out and there is no violation. PictureBox1.Image = Image.FromFile("C:Tom.bmp") End Sub
I have a procedure that is building a PrimaryKey based on values input from a CSV File. There are 4 fields that make up this PK. My code is below.
[code]...
For some reason when it takes the "IF" branch, it gives me the "Violation of PrimaryKey" Error. When I debug the 4 key values, the record does exist in the DB Table. Not sure why it's taking this path. I think I'm not testing the "row" object correctly.
I have been using access for my applications from over 4 years now. I realize its time to move on now and i need suggestions for a new database. Here are my requirements :should be able to connect it with Vb.net windows form frontend GUI - all database functions such as add/delete/edit/update will be done through the vb.net front-end only.Should be able to place the db on LAN and each client on the LAN can then access the centrally stored db through their individual front-ends.At the most 5-6 users will be reading/writing to the database at the same time , so the database should not crash or slow down Since i come from MS access background, i would like something thats similar to it so that i can learn and adapt to it quickly.Not very important, but i think its worth mentioning. This db will be the main central db for my .net application.My .net application will also be interacting with quickbooks and magento via some apis but ultimately all this data will go to the central db. So just curious, will there be any compataibility issues with the database that you suggest Should handle about 10 tables and around 10k records in each table Should be secure - just that i should be able to lock it up or anyhow prevent it being accessed from anywhere else other than the vb.net front-end.
Lastly, I would prefer it to be free to use if possible but not essential. I realize there are some topics like mysql vs sqllite and on databases, but pls understand i need suggestions for one that will be apt for the purposes i have listed above.
Edit : Just curious - Would i pushing the limits if i still stick to access - i understand access won't be good for multi-user access but i guess 5 users is not much ?
A concurrency violation error? It happens on this statement:
CODE:
It thinks I'm using a key value of 1 when the actual value is really 1218. I'm using a command builder. The attachments show the value of the key value and the value of the update text values. By the way, I can insert data but not update it.
im trying to either download a webpage source or get the source and load it into a variable but i keep getting an error:The server committed a protocol violation. ection=ResponseHeader Detail='Content-Length' header value is invalid
Public Sub DL_webpage(ByVal url As String) Dim client As WebClient = New WebClient() Dim stream As Stream = client.OpenRead(url)
I'm having some trouble updating changes I made to a datatable via a dataadapter. I am getting "Concurrency violation: the UpdateCommand affected 0 of 10 rows"
'Get data Dim Docs_DistributedTable As New DataTable("Docs_Distributed") Dim sql = "SELECT DISTINCT CompanyID, SortKey, OutputFileID, SequenceNo, DeliveredDate,
i have get that exception when save my db with TableManager.UpdateAll command:
Violation of UNIQUE KEY constraint 'IX_InstalmentID_DueDate'. Cannot insert duplicate key in object 'dbo.Instalments'.
This error only occurs if I remove existing records from BindingSource (without saving) and add them again (with same date) and then save the all changes with UpdateAll command. Here is the my table schema:
I have created an application using Visual Basic .NET, the application use an access data base which must be shared in server of a local network. The problem is when I run the application in a client machine (connected to the network) I can't connect to the data base.In the same machine the connection work which it's not the case when I change the location of the base to: Data Source="serverIPAdress/DataBase.mdb"
I am trying to connect to a remote machine through a vb.net application and want to retrieve the system information using WMI Classes. But the source line (scope.Connect()) as below generates an error "Access Denied HRESULT...." [code]
I just finished putting the first 6 datagrid controls on my form and i went to go test it and got this build error: Error 4 Value of type 'String' cannot be converted to 'System. Windows.Forms.DataGridViewTextBoxColumn'.C:SoftwareForm1.vb 1425 19..When the line generating the error is this Me.Name = "Form1".where it has the "Form1" portion underlined in blue.This is a weird error because that line was made by the IDE to say the name of the form and has nothing to do with 'System.Windows.Forms.DataGridViewTextBoxColumn'.I tried saving my progress and restarting the IDE with no luck..Now I cannot even access the form in designer mode,One or more errors encountered while loading the designer. The errors are listed below. Some errors can be fixed by rebuilding your project, while others may require code changes.The designer cannot process the code at line 1424: Me.Name = "Form1" The code within the method 'InitializeComponent' is generated by the designer and should not be manually modified.
I am trying to insert a variable in Decimal type into an Access table. When I use "decimal" field with 0 digits after the decimal separator (,) my program works properly. However, when i use the field with 2 digits after the separator I get a "Data type mismatch in criteria expression." exception. This happens also when I try to update the table. The debugger shows me that my variables contain the right values but the update or insert command gives the error.
It's saying I cant access this object in my class. Why? I'm pretty sure Ive used this method several times before. Below is some bits of code to figure this out. Object reference not set to an instance of an object."
When I am scrolling datagrid after selecting one row I am getting error as "An unhandled exception of type 'System.StackOverflowException' occurred in System.Windows.Forms.dll" on line :
I am trying to check to see if a value in a textbox is already in a drop down list. If it is, I will simply write to a label. If the textbox value is not in the dropdown list then I want it to write to the dropdownlist.
I am getting the following error Collection was modified; enumeration operation may not execute
HTML
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click For Each value In DropDownList1.Items
I've written a new DAL and BLL, but when I try to create an instance of my class, I get an Object Reference error, is there anything particular I should be looking for? I am fairly new to this concept?
Call is such:Protected Sub btnSignin_Click(ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles btnSignin.Click Dim l As New Log()l.Log = "Attempted staff login with username [" & txtUsername.Text & "] and password [" & txtPassword.Text & "]"
[Code]...
Intellisense highlights no problems and if I Build the web site in VS I get a few warnings about schema information in the web.config (unrelated), otherwise no problem.
Trying to run the following code but am receiving an string to integer error. Basically, I am running a report through code and trying to retrieve a number from a line of code by removing the line description and spaces. Having problems trying to figure out how to do that.
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim strURL As String
I have a show button.The user will select a data from the dropdown list of the combo and on clicking the show button the corresponding data will be fetched from the database and will be shown in the corresponding fields.So I did this
Private Sub Show_Btn_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Show_Btn.Click Using connection As New OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=BankAccount.mdb") connection.Open() Dim command As New OleDbCommand("Select * from BankAccount", connection) Dim reader As OleDbDataReader = command.ExecuteReader()
Private Sub btnUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdate.Click Me.Personal1TableAdapter1.Update(Me.HRDataSet4) Dim myConnection As OleDbConnection Dim myCommand As OleDbCommand [Code] .....
I use web methods in a couple of places in the intranet site im working on and they work fine, however one page is constantly throwing a HTTP 401 error every time I try access the web method.
Im not sure how to aproach this issue, I have tried commenting everything out of the web method, and still get the 401 error, even a basic connect to the database just doing SELECT 1 does not show up when I watch the DB with profiler.
My web.config is the same for all pages in the intranet and I cannot see any differences in my ASP.Net page compared to pages where web methods work.[code]...
I've developed a windows service that connects to a database and executes a Stored Procedure when running in debug mode I get the following message: "ContextSwitchDeadlock was detectedMessage: The CLR has been unable to transition from COM context 0x1ffc20 to COM context 0x1ffd90 for 60 seconds. The thread that owns the destinationcontext/apartment is most likely either doing a non pumping wait or processing a very long running operation without pumping Windows messages. This situation generally has a negative performance impact and may even lead to the application becoming non responsive or memory usage accumulating continually over time. To avoid this problem, all single threaded apartment (STA) threads should use pumping wait primitives (such as CoWaitForMultipleHandles) and routinely pump messages during long running operations."
vb 'Explicitly imports a namespace into a page, making all classes and interfaces of the imported namespace available to the page.
I'm trying to trigger an animation declared in the window's XAML file from the window's vb code when an event is raised (calling a function), like a window's "loaded" event.
Here's how I declare the animation (as a storyboard):
Dim StartAnimation As Storyboard = DirectCast(FindName("ServiceOn"), Storyboard) Dim StopAnimation As Storyboard = DirectCast(FindName("ServiceOff"), Storyboard)
And here's the code for the function that is failing:
I've developed a small HR program that connects to the SQL database which is on the local PC. I've created an ODBC connection to connect to this server and the program works fine. I've used VB 2008 Express edition to develop.
My concern is now I want to install this EXE on a server. ON the server, I've created the same databses and successfully created an ODBC connection on the server as well. Also created one shared folder. I copied all my EXEs and DLLS on to this folder. On the server I was able to execute the program without any problem.
From a remote client, I opened this shared folder and try to execute and it was giving me an ODBC related error, basically it was not able to detect the SQL connection.What I want to achieve is to have one EXE. The program did not throw any other errors.
Public Shared Function GetData(ByVal id As Integer) As List(Of SomeClass) Dim command As New OracleCommand Dim conn As New OracleConnection(WebConfigurationManager.ConnectionStrings("ConnectionString").ToString) Dim param As New OracleParameter
[code]....
This function is giving an ORA-00911 invalid character error. I have other methods of the same style and these are functioning correctly.
I am using combobox to populate values from a table, 'Suppliers'. I put this combobox in a form wherein the order details are filled up. This column 'Supplier' is a Foreign Key and set to NotNull in the order detail table. Selecting the first available entry on the combobox gives error 'SupplierID cant be Null' . Selecting the 2nd value is OK, first choosing 2nd and coming back to 1 is also OK. This error comes up when trying to update the database.Even with the first value, the combobox is having a text. I would like to know why the error.
Trying to convert my home app from vb6 to .net but have a problem. I am using the code in the tut by Paul Kimmel but it is returning Err.LastDllError = 126. I am using this code as posted on Win7 and VS2010. KeyboardHandle is retuning 0 but Im not sure which part of it is the problem. There is a lot of new stuff there for me.
Everything was working just fine...then one time running the debugger and I'm given a 401.2 error from IIS Express 7.5. I created a new project and tested - worked fine. I ensured the web.config and other project settings where identical - still getting the error in the original project!
I am working in vb express 2008. I got some sample code from the site www.vbhelper.com and tried to implement it as it is. Debugging of the code gave following errors:Error 1 'Protected Overrides Sub Dispose(disposing As Boolean)' has multiple definitions with identical signatures.
C:Documents and SettingsDaLicaRestaurantLocal SettingsApplication DataTemporary ProjectsPrintingForm1.Designer.vb 7 29 Printing
