how to connect different vb applications to a database server.like accessing data from one database by different applications...
View 4 RepliesWhen I try adding a new data source to my project I get a prompt saying "The connection you selected uses a local data file that is not part of the current project. Would you like to copy the file to your project and modify the connection?"This sounds rather obscure to me, as I'm new to VB.NET and programming non-script apps in general. The data source in this case is a .sdf SQL CE file.
Question 1: If I say that I want to copy the database to the project, what will happen after I compile the app, where the database will be? (how will I edit it from another app?)
Question 2: If I do not include it, how the data source will still keep linked? Can I link using filesystem enviroiment variables like %ProgramFiles%MyAppDir?
Question 3: Can I just tell it to use a read-only (Just needs to read it) data source on the web, like on an FTP?
is it possible to use same database for both vb.net appplication and asp.net??and if is possible, how can to connect it?now..i'd build vb.net application and asp.net in my laptop...it can connect..but i wonder how to make the database connect for vb.net and asp.net in real..
View 2 Repliesim using ms access 2003 and vb 2010, i already have 3 different vb apps, and i want to access a single database over the lan. but i dont know how. is this possible using a client-server type or is there much simpler way to access the database?
View 4 Replieswhich method is more efficient to use: DataAdapter and DataSet Or DataReader when importing data from a certain database table???
View 6 RepliesI'm a first time visitor and poster, but I'm definitly going to stick around. I'm running an old version of Visual Studio .Net Academic 2002 and the .Net framework 2.0. I'm stuck on an issue regarding the deployment of a few programs I've thrown together. They all work fine on my development machine, but the problem they all use SQL Server databases, and I can't find any specific help on deploying a windows application with a database on a machine that isn't set up basically just like my development machine.
I know that I need the .net runtime bootstrapper on the target machine, so I can run basic programs that dont use SQL databases. That's no problem. But what about programs that make heavy use of databases? How does one go about deploying it on target machines? Is there a SQL server bootstrapper?
[Code]...
Recently i had a discussion with someone about the proper way to develop a database driven (SQL Server) application.In his opinion i should design also the database inside the application.At this moment i design the database in SQL Managaement tool and use a custom class to connect to this database (or the one of the client) in my application.What are the cons and pro's of using the VS database designer inside my IDE?
View 4 RepliesI am developing desktop search engine. For that i am maintaining indexed database with file name and their path. The indexed database is created at once by scanning all hard disk. This indexed database is further updated when user creates, deletes or renames file. The updation task is carried out by an windows service application and for searching files on hard disk I have created another windows aplication. The problem is that when windows service is updating database, windows application can not read database. It gives error 'Cannot open user default database. Login failed.Login failed for user 'WINXPSwapni'.
View 1 RepliesI have an application which takes input on a local machine and sends it to a database stored on a server. I'd like to be able to deploy my application over a number of computers (all on the same network), all of them updating the same database (on the network server).First of all, will this be possible without putting together a completely new application to handle all connections to the database and sorting the entries?
View 7 Replieshow to access an item like a button in a windows application?For example, I would like to create an application that would be able to look at notepad's file menu and "know" that file, edit, etc on the file menu are clickable objects and identify (expose) these objects to my application.
View 3 RepliesDo users of windows applications have to have the database application installed if your program uses databases to store information? For example, when making VB2008 programs, if I use the visual studio express database (.sdf), or maybe a MSAccess database, to store information within my visual basic program...when I deploy the application to the users, can they run the program okay even if they don't have MSAccess installed on their computer?Also, do I need to have MSAccess installed in order to write programs that use MSAccess databases?
View 1 Replieshow to i iinclude sql2000 database in vb.net desktop applications setup
View 2 RepliesWinFormsApp Login passes information to .php (server based) Login (provided credentials are correct) to DB to retrieve Decryption Key. WinFormsApp then uses Decryption key on Hardcoded encrypted connection string and renders application usable.This would then eliminate the necessity to encrypt/decrypt a connection string at runtime, virtually rendering any unauthorized person with a useless software.
View 1 RepliesI'm am wanting to get out of access dbs and into something more solid, ive heard that sqlite or mysql are great database tools for your applications. I am also looking for a database with a GUi to manage the database more easily and links on how to incorporate the database into my projects, etc. So any links,videos, suggestions i'd like to hear them all.
View 9 RepliesI am working on a project that is used for key broadcasting. Don't worry nothing illegal, I'm making a multibox application for world of warcraft. However I am having trouble when it comes to launching and manipulating other applications from another.
[Code]...
Im am trying to get two separate applications to communicate with one another via a txt file. The first application writes to a txt file every even second and the second application reads the text file every odd second. The problem is Im getting an exception saying The process cannot access the file FILE_PATH.txt' because it is being used by another process. Not sure if my code is correct or not? Or if there is a better way to do this?
[Code]...
I have a program that is running with a Data Connection to Database MS Access Office 2007. I maxed the Database at 1.97 GBytes of memory. I then inserted the Database into my VBasic Program and tried to compile. The compiler gave an error at the Me.ChemicalsTableAdapter.Fill(Me.Chemistry2aDataSet.Chemicals)
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.ChemicalsTableAdapter.Fill(Me.Chemistry2aDataSet.Chemicals)
radPrefix.Checked = True
[code]....
How can i connect two VB.net applications together so that they can send each other informations ???
View 3 RepliesI am very familiar with VBA and have been using access and excel to create applications that connect using ADO and/or linked tables.I'm looking to start developing simple Windows applications for my company using Visual Basic, that will connect to Oracle and SQL Server Databases using ADO. What do I need to accomplish this? If I purchase Visual Studio 2008 Pro, will it come with VB? And do I need anything in addition to this in order to connect to SQL or Oracle databases using ADO method?
View 7 RepliesI am about to start developing my second application in VB2008. The need is that it has to run on a network enviorment, probably under windows nt, the database has to be on the server so everybody uses the same data. The database is suppose to contain a lot of data on many tables, whatīs the ebst way to go? Access, SQL, foxpro dbf? Also what kind of project am I suppose to start? a windows app? or some kind of .net app.? I am sorry if I am saying dumb stuff itīs just that I am a rookie. Have in mind that after I build the application, many users have to have access to it from different computers and I also want the database to be availbale for a future website with forms and queries and stuff taken from the same database, is ASP the best choice for that purppose?
View 6 Repliesam new to visual basic and I would like to learn socket programming, I've seen a lot of tutorials on the intenet and they worked, but when I come to add my own code like sending a file or excute a command etc, I realize am not able to. so am requesting a tutorial with DETAILED EXPLANATION on socket programing, both server and client, I might be asking for alot, but I need it
View 1 RepliesI have saved documents into my SQL Server 2005 database and they have been converted to bytes. My web page is made with VB.NET in Visual Studio 2008 with ASP.NET. The following is exactly what I need to achieve;
1. Allow user select document with a button
2. Select the document from the SQL Server table
3. Allow the user to download this document.
The error I am getting is that Category is set as Byte and it can't be passed through GetDocument because filePath is a String. I think that I am pulling the file path from the database wrong
[Dim Category As Byte() = NothingDim fs As FileStreamDim br As BinaryReaderDim document As Byte()Dim documentFilePath As String
Protected Sub ImageButton1_Click(ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles ImageButton1.Click
myConnection = New SqlConnection("server=ORLA-PCSQLEXPRESS;database=Edpac;
[Code].....
code to access SQL Server database in connected and disconnected mode through ADO .Net.
View 4 RepliesHow can I write a connection string? I has four different computer that can be connect via ethernet.How can I maintain a inserting data if to computer insert on same table at a single time..??
View 1 RepliesI am looking into writing a web-based vehicle tracking system. The framework I have in mind looks something like this:
Client application --- Database --- Database updater.
Client application: This would query the database for information and then display this information on a map.
Database: holds vehicle information such as speed, location, payload etc.
Database update: This application would need to continually check for information received from vehicles and then add that to the database.
I am confident that with my current skill set and some research and learning, I could write the client application and interface it to a database. However, I am at a loss as to how to write the database updater. Presumably, this would be an application running continually on the server, waiting for information to be received from vehicles and updating the database. Is this something I can do with ASP.NET and Visual Basic? Or would this require a different way of thinking than writing web pages?
I migrated some applications from Visual Studio 2005 to Visual Studio 2010. I develope using VB.NET in VISUAL STUDIO 2010 on a Windows 7 PC (32 bit). The applications writed in VB.NET - VS2005 run correctly in PC having XP, VISTA, WINDOWS 7 and Windows Server 2008. After the migration, the exe of these applications work correctly in PC having XP, Vista, Windows 7 but work stop immediatly on Windows Server 2008. The error returned is 'System.InvalidOperationException'. Seems that the application stop when attempt to evaluate the first global variable that meets. If i change the framework from 2.0 to 3.5, things don't change.
[Code]...
Is there any chance who can give me a sample code for client-server applications using vb.net 2008 express edition/professional edition?
1. What SQL Server should I use? Can we use SQL Server 2000 for Client-Server application as my back end database? and will use the vb.net 2008 express edition as front end?
2. If we use these two components (SQL Server 2000 (Back-end) + (VB.Net 2008 Frontend) do you think this will works properly?
3. If this is possible by accessing via code? then please send me connection string.
4. Is there any database server we can use? asides from sql server? where we can implement client-server applications? how about oracle? MySQL Database Server?
my friend tell me .they use file.txt,file.ini,file.xml and registry for save connectionstring for connect to database and what do you use save connectionstring.
View 6 RepliesIs there a way to, when a parent application is opened up, that at the click of a button, or anything of designated event, that this parent application can open a secondary one?
View 11 RepliesI would like to make a multi-socket TCP server (to accept multiple clients at the same time).I'm working with Visual Studio 2005 Express, maybe that's why files on CodeBank don't work..I found on the web an example about MultiThreaded Server Socket programming, but this is done for "Console application" in this way:
[Code]...