DB/Reporting :: Using SQL 2008 Express With A Multi User .NET Windows Application?

Mar 26, 2009

I'm using SQL 2008 Express with a multi user VB.NET Windows application. Do I have to add each user to the SQL user account? Does NT AuthoritySYSTEM work? I do not know how this works. So far I have NT AuthoritySYSTEM in the Security-Logins of the Server. But do I have to add it also in the database? In the databse Security-User, I have the following:

[Code]...

View 1 Replies


ADVERTISEMENT

DB/Reporting :: Multi User - Windows Application With Back End As SQL Server 2008 Express

Mar 17, 2009

I'm working on a multi user VB.Net windows application with back end as SQL Server 2008 Express. The SQL Server is installed on the intranet network drive. This is the connection string I will be using. Is this correct?

Data Source=.SQLEXPRESS;AttachDbFilename=Q:DatabasePrintDB.mdf;Integrate d Security=True;Connect Timeout=30;User Instance=True

View 3 Replies

DB/Reporting :: Database For Multi-user Application

Jan 28, 2011

i just want some opinnion or suggestions regarding database softwares. we are going to develop a system for 20 or less users, i am planning to use MYSQL community server as our database to lessen the budget for that system, i just want to know if it is ok to use that version.is there a big differece between mysql community server, enterprise server and MS SQL Server in terms of handling data i.e security, speed, etc...

View 2 Replies

DB/Reporting :: Not Saving In Debugger - Windows Form App In VS 2008 Express

May 6, 2009

I'm developing a windows form app in visual studio 2008 express. I'm usin a sql compact 3.5 database on it through the program, several changes are made to database data, and so, i have on form1_closing event, a code to save the dataset back to database, something like:

Private Sub Form1_Closing(ByVal sender As System.Object, ByVal e As System.EventArgs)
Me.Validate()

[CODE]................

But when i run my program on the debugger, the changes i mkae, don't get saved, are lost...is this a charecteristic of debugger, or is my "saving code" wrong?

I already built the program, and the data is not being saved. how to saving the data ? by the way, all changes to dataset are made something like this:

[code]:......................

View 1 Replies

DB/Reporting :: Using Vb Net 2008 With SQL Express 2008 R2 In Windows Forms?

Sep 9, 2010

using Vb Net 2008 with SQL Express 2008 R2 in windows forms. that being said, I have a syntax problem in this form, form has 2 texbox an a datagridview and also the 4 components DataSet. BindingSource. TableAdapter, BindingNavigator. When I filter by LastName no problem it work fine (it's a String) but when I try to filter by CustomerID (it's alphanumeric) I get an error "Invalid character" here is part of my code: Private Sub surnameFilterTextBox_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles surnameFilterTextBox.TextChanged

[Code]...

View 5 Replies

Multi-user Application - Updating All Clients When A User Updates Data (push Vs Pull)?

Aug 26, 2009

I am designing a fairly small application to manage a waiting area for a clinical department. There will be a receptionist who books appointments and updates exisiting appointments to say that a patient has "Arrived". In seperate rooms will be nurses who call patients who have "Arrived" and update the appointment as "In Session" and finally as "Discharged". The appointments are viewed in a flexgrid with nurses across the top and time down the left, patient names are displayed at the relevant times and the cells are shaded a colour to represent the current appointment status ("Booked", "Arrived", "In Session" and "Discharged").

I am using SQL Server as the back-end and Visual Basic 6 (I know) as my front-end.I have been told that there will be 2 or 3 nurses plus the receptionist logged in to the system but I would like to cater for growth.My question is what is the best mechanism to use in order to reflect the status change made by one user on the screens of the other users currently logged in?

I have been thinking about using a timer to refresh the data at a set interval but I do not want to keep hitting the server excessively (although what is considered excessive? we would be talking about a call for data every 60 secs per user). Plus the server could be serving data for many other applications so this is another consideration.Alternatively I have been thinking about sending some kind of message via Winsock to the other users notifying them of data changes as they happen. I don't have a lot of experience with this and am concerned about clients not receiving messages and users seeing old data. It also seems strange to me that once the days appointments have been retrieved from the database that "in theory" a client could go the whole day without having to query the database again to pick up changes - kind of scary.Some information on the data:We would probably be looking at around 100 appointments per day We capture patient name, date of birth, date and time of appointment and appointment status.What is the standard approach / best practice for this kind of scenario?

View 6 Replies

Visual Basic 2008 Express Edition Application Does Not Work On Windows XP Machines

Jun 23, 2010

I have a Visual Basic 2008 Express Edition application that operates as a front end for iSeries V6r1. The application was developed on a windows 7 machine. Users load the application from a shared folder on a server. Currently, there are 2 Vista, 3 windows 7 and 4 XP users. All had no problem in loading application, all users except 3 of 4 XP users can run the application with no problems. However, 3 of the XP users receive the following error message when they perform any action that tries to connect to the iSeries:

System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.

All 4 XP users are on same service pack

View 8 Replies

Make Multi User Application?

Mar 10, 2009

I have finished coding a VB.Net application that has connection to SQL Express 2008 database. My question is, what steps do I have to take to make this a multi user application.

FYI:There are 3 tables in the database of which two tables contain data to be viewed by the user and one table is to insert records by the user. The former two tables will be edited by the administrator only. So there is no issue of concurrency. But the one table that is used to insert records by all users has to be dealt with.

View 11 Replies

Create A Multi-User Application?

Sep 18, 2009

I am new to programming. I know how to create simple windows app using VB and Sql Server/AccessDB. My question is this: Can my windows app be ran on a LAN or do I have to create a special multi-user app for a LAN? If the answer is yes, can someone please guide me on how to create a LAN/Multi-user app.

View 2 Replies

Create A Multi-user VB Net Application?

Feb 19, 2009

I need to create a multi user VB.Net application that connects to Access 2007 and has 2 forms. How do I go about it? Please give me a start up.

View 6 Replies

Make A Multi-user Application?

Apr 11, 2009

I want to about a multiuser application that have a server and 2 or 5 client to interect with mssql thorough application. how multiple cleint connect to database in same time.

View 4 Replies

Multi-user Tcp Chat Application?

Jul 29, 2009

I have been trying for years making a network app.I need linked to a video or something, mainly on msdn or some microsoft site, because youtube created videos for coding aren't all that helpful as most of the microsoft made videos.

I need not linked to things like multi-user tcp chat application, as i have looked at these, and even found no code solution, but the no code doesn't allow too much customization and hard to deal with data received to make your own commands send and receive and have events for them.

The multi-user tcp chat application, it doesn't explain anything, just gives you the code for you to look at, and well, it's hard to understand.

I WANT TO MAKE THE PROGRAM BEFORE MORE YEARS PASS BY.

View 1 Replies

Make Multi-user Application (database)?

Dec 7, 2009

how to make an application with a multiple user.

language: VB
resource: Visual Studio 2008 Pro(90-day trial)
Sql express (the packages when u download the VS 2008)

scenario: i will make database located in a server (LAN) and a multiple client that can access the server database to add,modify,delete records.Im not aware that building a multi-user application database is different from a normal one user application database. T_T.i read some guide and other walkthrough on building a database but it became confusing when it doesnt my requirements. coz when i try to open my database(.mdf) to connect from other client (in another station) it says its currently in use and connot connect to it. err. @_@..

View 3 Replies

Manage Concurrency As It Is A Multi User Application?

Mar 2, 2009

give me some example code to insert rows of datagridview into a sql express database table? Also, how do I manage concurrency as it is a multi user application?

View 6 Replies

Make Program Application Work As Multi-user?

Jul 25, 2007

I am developing a VB.Net application. That application might be working on a LAN. MS Access as a backend will be used.

I have developed many single user applications, but don't know of multi user , LAN, manage DB etc. How do I make the program as Multi user on LAN. Data will be accessed at the same time. How to mange such things.

View 5 Replies

Special Characters - Multi-User TCP Chat Application?

Jan 8, 2010

Someone gave me a link to a Multi-User TCP Chat application once, but, there is a flaw in it, where it wont do special characters, such as Alt+1 will become a different character to the server than the one that was sent. Even I tried to see if the output was usable but it sees it as multiple chars, when it is only 1, and I can't find a link between what it sends and what the character is, so I can't just tell it based on whats sent what the char is, because I see no relation, I would have to type it out for each and every special character.

View 2 Replies

Create A .net Windows Application In Multi-language?

Feb 23, 2009

If i want to create a vb.net windows application in multi-language (EnglishArabic). Is there any steps i need to do?I installed the Arabic at my windows XP and I am able to write the labels and the the textbox for example in arabic but is there a way for the controls to shifts automatically?

View 7 Replies

Create A Multi User Application That Connects To Access 2007

Feb 19, 2009

I need to create a multi user VB.Net application that connects to Access 2007 and has 2 forms. How do I go about it?

View 4 Replies

Method To Develop And Deploy A Multi-user Desktop Application?

Sep 17, 2009

I have developed an application using vb.net. This application will run on approximately 15 machines at the main office and also roughly 10 machines spread over 3 different locations. I am using SQL Server Express edition in the backend. I deployed the application on the network using caspol but it is extremely slow. The Company Manager's perception is that because a script will invariably have to be deployed on each client machine to configure CASPOL, that the solution is not viable.

What is the best method to develop and deploy a multi-user desktop application?

View 9 Replies

Multi-user TCP Chat Application Doesnt Append Text

Apr 6, 2011

I've been trying that example application at [url]...

I'm just using the client part to connect to an exiting server application. It works OK up to the point where it appends text into the[code]...

View 2 Replies

Provide Multi-language Support In My Windows Application Developed?

Jun 3, 2009

I M DEVELOPING AN ASP.NET APPLICATION I WANT TO PROVIDE INTERFACE IN ARABIC AND ENGLISH

View 2 Replies

DB / Reporting :: VB 2008 Express - Establishing A Connection To A Database

Mar 9, 2010

1.Establishing a connection to a database(preferably one that is inherit within the project and can travel with it)

2. Setting the correct references to the database ( I tried connecting via JET with windows 7 and I get an error that I cannot use JET)

3. Query the database (Access) with SQL, and return those results to a recordset.

4. Loop through the recordset.

5. close the database connection

6. Open recordset and write data to table.

[Code]...

View 1 Replies

Multi User Chat .net 2008?

Apr 9, 2009

[URL].. Unfortunately that is for i think it was 2003. Most likely it wont update and still work. along with that would it be possible to have users be able to private messege each other, create their own user rooms, and add admin features such as kick, ban, look up ip and such?[URL].. as my login system. its been modified so that the connection string wasnt hard coded.

View 1 Replies

Express Application Om Windows CE Operating System?

Dec 16, 2009

Is it possible to make applikacations with VB.NET Express version to a windows CE OS?

View 2 Replies

DB/Reporting :: Copy Oracle 11g Which Is Fully Installed - Work With VB Express 2008 ?

Oct 3, 2009

I have a copy Oracle 11g which is now fully installed. Will it work with Visual Basic Express 2008 or just Visual Studio 2008 Professional? I have both Visual Basic Express 2008 and Visual Studio 2008 Professional. I really would like to know if it works with Visual Basic Express 2008.

View 2 Replies

DB/Reporting :: Create Access Database (VB 2008 Express Edition) OledBcommand

Jun 20, 2009

I want to create a table (called "Customers") in a Microsoft Access database and then insert/delete records into the table and update the table. The table shall have 3 columns:

ID
Customer Name
Customer Address

I know i need to make the "ID" column as an autonumber and a primary key, as i need to insert and delete records and update the table. I am using the Visual basic 2008 Express edition and quite familar with the OledBcommand.

View 1 Replies

VS 2008 Multi-User Chat Program In VB2008?

Aug 8, 2009

do this??& can I make a Main server like this?

View 1 Replies

Add Command Line Arguments To A Vb Express Windows Form Application?

Nov 17, 2008

Is there any way to add command line arguments to a vb express Windows form application?

View 9 Replies

Deploy Windows Application With Its Local Database SQL Server R2 Express?

Apr 5, 2012

how can i deploy windows application developed using Vb.net and Sqlserver R2 Express as local database?..how can i make it in setup format(including sqlserver) to deliver to clients?is it compulsory the client should install SQL Server R2 Express in his system apart from the installation of this windows application?

View 5 Replies

Multiple Client Windows Form Application Using Visual Basic Express 2005?

Jul 30, 2009

I am making a server - multiple client windows form application using Visual Basic Express 2005.

I was wondering if there was a way that I could debug multiple instances of the client at the same time?Ashray Lavsi If my post answers your Question, don't forget to "Mark it as Answer"

View 6 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved