Multiple Apps With Central Database
May 8, 2009
I have an application which writes to and reads from a database. I'd like to be able to have the application installed on a number of computers with the database installed on a central server which all of the applications will connect to.
first of all, installation (installing the app is simple, but how can I get an install program to put the database on the server?), and next, concurrency errors?
I understand that having more than one person trying to update the database at the same time is likely to cause concurrency errors, but short of deploying my application and having everyone try to write to the database at once, I'm not sure how to approach this.
View 8 Replies
ADVERTISEMENT
Aug 19, 2009
We have several VB.NET websites running internal applications. These sites are often modified with minor changes, and are maintained on the server as uncompiled code. I'm looking for the best way to maintain classes so that we can reference them from multiple websites.
Specifically, we're looking to put some common functions (error logging, common database calls, etc.) into a centralized location where they can be maintained separately from the sites and called as needed. And we'd prefer to have this on the server as uncompiled code, so it can be uploaded without precompiling. I feel like I'm missing something obvious, but what is the best way to set this up?
View 3 Replies
Nov 1, 2011
I am wanting to build a menu from multiple xml files in a central location this will be to help with adding crystal reports after application has been deployed to an end user.I am able to get the list of all the xml files in a folder it is just the adding the ReportName to the different menu buttons i have set up.
Dim dirs As String() = Directory.GetFiles(Application.StartupPath & "Reports", "*.xml")
Dim dir As String For Each dir In dirs Dim xe As XElement = XElement.Load(dir)Next
View 9 Replies
Jan 1, 2011
My application is in VS 2008 (vb.net Windows form)
I want tips for this:
What types of care I take for it?
What types of problems can be generally happen?
View 1 Replies
Mar 3, 2010
My program opens an excel file with excel.application's .visible=false. If the code is running and I manually open any excel file the excel file being used by code will then open up as well (making the .visible=false useless). Then at the end I use the excel.application's .quit to make sure that instance of excel quits, but it will quit every open instance of excel (even ones not opened by that code).Is there any way around this? to make sure it does not appear when other files are opened, and to make sure it only closes that one instance of the excel application.
View 4 Replies
Oct 27, 2010
I need some advice here, i have several little applications that i want to be small modules (don't know if it's the right name), in one Main application.I know that i can do this in several ways (add the code, call the exe), but i was looking to guidance for the best way / pro way.
I was thinking in creating DLLs for each one, and after putting the DLLs in one folder inside my Main Application instalation, it recognizes all the DLLs in that folder and create the appropriated menu for the DLL with the options defined inside. Kind off add-in, this may help me in the future if i need/want to add other apps/DLLs.I already seen something like this in the web, but i don't remember where or what should i write in the google to get what i want...
View 4 Replies
Jun 1, 2012
[i][b]I have always developed apps for desktops with an access database on one server for one company or sql server. I had one connection string. Now I am in a situation with multiple clients using my software on their own server. This means different connection strings can anyone suggest an efficient way to do this without changing connection strings for each server throughout the application?[/b][/i]
View 1 Replies
Jun 11, 2011
I have created an application using ODBC data sources.it runs on a local machine well. but i want it to run on client machines from central server. the following is the code that i use:[code]where cleaners is a data source i have manually created in ODBC data sources.and then uses the connection for inserting,deleting and so on.can somebody help me with a code that can enable it access the remote machine.
View 1 Replies
May 28, 2011
In Mac OS X I can take advantage of more than 1 core using GCD (Grand Central Dispatch). What is the equivalent for a Visual Basic program?
View 2 Replies
Jan 6, 2011
I'm using a central startup routine to initiate several TCP connections, start up a background thread that does some monitoring, and instantiate a group of objects that track information throughout the lifetime of a networking session.
There are periodically server-side problems with the protocol I'm working with, at which point the whole mess has to be torn down and set back up, so at the front end of the startup routine I'm disposing of instantiated tracking objects, killing the monitoring thread, and disconnect/close the existing sockets (if they're already set up). At that point the sockets may be in the middle of an asynchronous send or receive operation, which is causing system exceptions when the socket is torn down and then the asynchronous delegate gets called and EndSend or EndReceive thinks there isn't an object there anymore.
I had assumed .Disconnect and .Close would take care of these async processes, and I'm a little lost. Is there some one-shot method I can use to abort those async operations before I tear the sockets down to re-instantiate them?It never hurts to try. In a worst case scenario, you'll learn from it.
View 10 Replies
Jun 25, 2010
I've got a game I would like to build, it will require a central game server where peoples data (game data :-)) will be sent to and shared with other players - how is the done. Is it remoting? TCP? something else - I need to study up on it but want to make sure I'm learning the right thing.
View 3 Replies
Jan 22, 2010
I need some help with to make a messages system. I build a form with display a message code and the message.
Example : 0000001 : Not connected to network
The problem is that i want to store in a central place where the numbers and the message will be stored in the code. I was thinking about a array to store the date.
View 3 Replies
Jun 22, 2009
This is the situation: i have the central location with the main computer,and 14 distanced locations connected in VPN and often we need to update program manually (on distanced locations) by overwriting the existing .dll-s of the program and this is pain in the ass to connect remotely to 14 locations and on each workstation overwrite the .dll files so i want to create application which is going to be installed on each WS and by running this app it will check the program folder on central computer and if there is any file with newer version then existing one on the WS it will copy it from central computer and overwrite the old file/s on WS. It is a small app with two buttons and progress bar but the main thing is the Update now button because i dont�t know which commands it should commit.
View 22 Replies
Jun 21, 2010
what WPF based apps are?Is it an application that runs under Silverlight? If so, how?I know; Windows Forms based apps,console apps,DLL _ Class Library Projectsand I've had an introduction to ASP.Net.What I mostly want to know is, if WPF apps are for Silverlight then do they also run in a server based fashion like anASP.NET website would when you create ASP.Net webpages?Is it a way of creating what looks like a FORMS BASED application but it runs in a browser instead or what?Please enlighten me a bit further as I have no idea what WPF is all about.
View 3 Replies
Sep 12, 2011
I have a vb.net web application and when a particular function runs , i get data timeouts in the rest of the application..(ie..row not found errors or column does not belong to table but it does) The function is adding multiple rows in multiple tables in the database and is running in a for loop. It seems to be all SQL related but I am not seeing anything in the error logs in SQL or in the application Right now I am assuming it is memory related where to start note..the for loop will be replaced with a bulk insert but right now I jest need to resolve the issue of the timeouts
View 1 Replies
Jun 2, 2012
I am wondering if Global.asa can handle a procedure like this:
Protected Sub errore(tipo As Int16)
'Response.Write(Err.Description) 'or your own custom error message
Dim msg As String
[CODE]...
The idea is to have a central place to put the routine in instead to copy it into every .vb file that belongs to each .apsx code file.
View 4 Replies
Dec 15, 2011
I am making a window based application in vb.net. Now i have work in two sql databases, so i when the window opens it will show two databases..when i select first db then i can work in that particular db only..if select 2nd db then i can work in second db only..how to do that?
View 1 Replies
Dec 17, 2011
I am using an Application server for calling Oracle Reports and I have a URL to call the report. When the report is called the server converts it into PDF but when report contains large data it takes a lot of time to load. I want to do in asp.net that when I call the report url it opens the PDF file and copies it into the root of my web folder. The next time when I call the URL it opens the PDF file and creates a new PDF on backend for next call. I have made this function to download file
[Code]....
View 2 Replies
Oct 3, 2010
Basically, i am trying to determin if an application made for 1.x will run on a computer with just one copy of the .NET framework installed which is a higher version than what i am targetting, ie: it only has one copy of .NET 2.0, or 3.0, or 3.5 or 4.0 - has one copy of either of these and thats it, the hypothetical computer would not have 1.0 or 1.1 installed.
[Code]...
View 5 Replies
Sep 12, 2009
Usually when you right click on an application, and then click on properties, you can find the applications exe name. Such as, explorer.exe, mspaint.exe, and much much more. But I can't find the exe name of any of my apps.
View 7 Replies
Apr 10, 2010
If I control both applications, what is the best way to communicate between 2 exe's written in VB.Net. For example, I want to drop an XML file from one app, and pick it up with the other, but I do not want poll for the file. I've heard of named pipes, but I found it was complicated. What's the most effecient way to do this?
View 4 Replies
Mar 19, 2012
I need to develop some apps that will be accessed from both PC and macs. Can this be done with visual Studio 2010?
View 2 Replies
Nov 1, 2009
I have the following
Private Sub startMySQLConsole()
Dim parameterString As String
parameterString = ""
[code]....
For some reason, it partially exists the program. The first letter of the line is starred (MySQL wants me to enter a password).I want to use get to mysql via the my app, which launches mysql.
View 1 Replies
Jul 8, 2010
I'm developing a media player app and upon looking at it for a week now, it seems really bland. I would really like to add some animations for it (besides just moving forms with x,y locations) but have no idea where to start.
Are more complex apps/designs/animations better suited for a language like c#/c++? I've never done animations before (except simple form moving) and I think now would be a great time to get some opinions!
You could probably say this would linger more so on 3d images and 3d animations
View 3 Replies
Oct 17, 2011
I've heard a lot about Mono but I have no idea what exactly it is or how to use it. All I know is it's aimed at making .NET apps cross platform. Could someone tell me or point me to some tutorials explaining how to port my vb code to run on other operating systems? Maybe shed some light on all of this?
View 9 Replies
Sep 9, 2009
say i have a piece of code of some function I would use in many different new apps for example
Code:
Dim Expression As New System.Text.RegularExpressions.Regex("S+@S+.S+")
If Expression.IsMatch(txtEMail.Text) Then
[code].....
View 4 Replies
Mar 26, 2009
how to create a local database, create some tables and set relations between those tables (just like in access) and I can show, add, edit and delete that data from a form.
but what I have yet to figure out is if I have 2 tables (i.e: tbleName, tblFood) and I want to have multiple tblFood items show for every 1 tblName item.
I've found that if I add a txtbox of the name table and a datagrid of the food table, the datagrid view shows all the food records, not just the ones for the name txtbox.
View 3 Replies
Jun 9, 2011
how can you connect different user accounts to their respective info?for example:I login as bebi and then, all of my info will show up in a window from ms access 2007 and if another user logs in, the info of that user will show up in the window
View 7 Replies
Feb 26, 2009
I am on the brink of developping an application for myself and some collegues at work. I will use VB 2005 and SQL server 2000 or 2005.
Here is my question: When I build the connection string do I have to use only 1 database user for all of the users of the application or does each user need to have its own database user in SQL Server?
View 4 Replies
Aug 15, 2011
I would like to develop a VB.Net based smart device app. A simple one. Do any of u know where i can refer to samples of such apps?
View 2 Replies
