Setup Some Form Of Database
Jan 19, 2012
I trained myself to program beginning in 1980 with the Basic language for Radio Shack's TRS-80 Model III.Later learned to program macros in Lotus 1-2-3, then taught myself DBase, then started Visual Basic.I've trained myself on Visual Basic up to VB 6.0.Now, as I understand it, Windows 7 and beyond will not support using VB 6.0. I have programmed many pieces of software we use in our offices.My software is Access Database intensive. I put the database on the server and we can connect from our various computers to the databases and work on the data as necessary.I've never gotten into Server/Client types of organization because I don't understand the server model and how to do that...For the sample databases one needs a server application running and I don't have one (Our server only has a standard operating system on it).
Now I was looking at Visual Basic 2010 and am totally lost.In VB 6.0 samples, I could put a break point (debug) and stop the program and examine what it is doing.now I don't even know where to put a break point..When I put one in the samples, the sample application loads and does not hit the break point...Is there anywhere I can learn how to move up to Visual Basic 2010?I don't want to have to quit my job and go back to school but it seems soooo different from VB 6.0.Just trying to figure out 'datasets' is a chore and to see how they work in the samples, I have to set up some form of database somewhere and it does not show me how.
View 13 Replies
ADVERTISEMENT
Jun 15, 2011
I'm trying to set up a login form which draws the username/password from an online database but keep getting the same error(shown in attachment).
Imports System.Data.SqlClient
Imports MySql.Data.MySqlClient
Public Class LoginForm1
[code]....
View 6 Replies
Jan 10, 2011
What type of database?[code]...
View 1 Replies
Dec 7, 2006
im making a setup project with my windows application. i have pack it but the problem is my database. how do i set there new targets once i added the mdb file. i know thats the problem but i really dont know how to reconfigure
another thing, when its already pack and when i try to run the msi, the interface has an error on the picture above. and whats the bootstraper for? why is it that clicking the bootstraper is an error.
also if my target machine doesnt have vb.net and ms access, would my project be still running in there? this is my first time in making setup projects.. im using vb.net 2k3.
View 12 Replies
Dec 15, 2009
1. What tools do I need to set up/create a database?
2. How do I set up/create a database?
3. Lets say I have some sort of "text" in my database. How would I get another one of my programs to connect to my database, and download the "text".
4. How would I "host" my database? I want my program to be able to connect to my database without having my computer on 24/7. must be free
View 2 Replies
Feb 10, 2012
I have written many programs and never really needed a database before. Just never came up. I am a self learned programmer. I have experience in using php and database on websites etc. I am currently writing a program in VB 2010 and need some assistance in using a database.simplest way to setup and use a database in VB. I would believe that it's better then saving "clients/data" to a file. . The software is being created only to be used on one computer and not over a network etc.
View 4 Replies
Jan 23, 2008
I am using VB 2008 Express. When I publish my project, all files show up properly in the publish directory. When I go to setup.exe it installs with no errors. When I go to launch the program it says it is missing the database. Sure enough the database that is suppose to go along with the install does not get copied over. If I manually copy the file to the install directory and remove the .deploy from the name the program works like it should.[code]...
View 2 Replies
May 12, 2011
I have been Google-ing for four days now and still i can find no solution to my problem:(and my brain hurts) i recently made a windows application that pulls data from a mySQL Database and populates my form but when i was told to use excel instead of MySQL thats when the problems started. while setting up vb to connect to MySQL i found a few articles that explained in good enough detail how to set up vb before ever doing any coding
ie.( boot vb, start windows form project, click project/add reference, click on the COM tab and add the MySQL reference then click ok. next click data/Add new data source, chose database click next, click new connection, choose MySQL data source click continue, enter database info(server, user, password, port) click ok. then start coding connection strings and commands ( which i have no problem with)
My problem i can find all sorts of code to work with excel but i feel i need to go through the same environment set up as with MySQL but i cant figure out how to set it up i only need to read data from excel file to populate my form data ie.( text boxes, labels, datagridview, Ect...) does anyone know how to set up the development environment to facilitate my use of excel. or does anyone know of a better way to store and retrieve my data maybe a vb local database ( does that travel with the .exe easily?)
View 5 Replies
Jun 19, 2010
I'd followed Beth's video which nicely explains how to setup a "connector" to an existing database. Also, I've updated a method to retrieve information from one of the tables.Now, I need to retrieve information from the table, but I don't succeed to find the "method" to do so (I don't get to the situation that "Fill" or "GetData" are recognized methods). Could anyone send me references through which I could easily understand. how this needs to be done?
View 1 Replies
Mar 20, 2012
IDE :: Publish - Won't copy database on setup
View 3 Replies
Mar 15, 2011
I have developed an application, in vb.net, which uses the sql database to store some data. I have created the database using server explorer inside visual studio. Afterward I have created the setup wizard to install the application on to another computer but the problem is, I dont know how can I include my database file into the setup file
View 2 Replies
May 30, 2009
I created a new Setup project to my original project. In my project's code there is this line: Public DBPath As String = My.Computer.FileSystem.SpecialDirectories.MyDocuments & "Visual Studio 2008ProjectsFUV1FUV1FU.mdb" I just wanted to know, if I am instaling the project in other computer that has no VS in it, with the SETUP project, do I need to change this line? something to do with the Application Folder of the Setup project?
View 1 Replies
May 10, 2012
I want to create a real setup project for my application so when someone want to download it he can run only setup, not default setup that provide me VB . How can I do that?
View 4 Replies
Jun 29, 2009
I made one application form in vb.net and access as database,in this form there is a imagebox field where i can upload the images.i put one default image when the form gets loaded. i want to save this default image if i dont upload an image.And another problem i'm facing is i want to deploy my project on another system but when i'm deploying my project, the database is not connecting so i've to add database separately on the other system even though i'm adding database during setup.May be i'm going somewhere wrong.how should i add database while setup and save the default image.
View 4 Replies
Feb 15, 2011
I am writing a program that is using a access DB for the info to be displayed. However when i started making the program i started by just databinding the listboxes.
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'AcskillsDataSet.Skills' table. You
[Code]....
but now that im looking at the data this is prolly only useful for simple data. Im wanting to seperate the data from queries into multiple boxes. Am i better off just manually having a connection to the database and running queries into arrays to sort the data?? The above method looks like im going to be trying to fight the databound stuff. There are two tables and the way the built in query builder is im starting to think its easier to write my own queries in variables or whatever.
View 4 Replies
Mar 13, 2011
friends i m a newer for dotnet...and i m a student i m creating a project with a simple database connection
i need to make a setup of that project but whenever i create a set up it wont connect with my database
it'll shows a error how to make a setup in vb.net with a project with a database connection
View 6 Replies
Jun 24, 2011
the right direction for creating a setup of my application in which i had used Sql Server 7.0 as a database
View 3 Replies
Jun 5, 2011
How can i create the project setup and include the database itself..
View 7 Replies
Jul 11, 2009
I have created a Windows Application in Visual Studio 2005(VB .Net) and used Sql Server 2000 as Backend,Now I want to know how to create a Setup of my Project so that I can install it on clients machine.I have tried by Adding a setup and Deploy project in My application but my setup file include SQL Database files(.mdf,.ldf) and my client has Win Xp installed so my Setup file is asking for sql server connection,but on clients machine Sql server 2000 can't be installed as its compatibility.
View 3 Replies
Dec 31, 2011
I have completed my Project in VB.Net and has published my project.But i want to come out of these things.I have Sql Server Database in my project and i want my setup to add that database to sql server on installing my project.I want my application to automatically detect sql server 2008 r2 and if it is not instaled i want it to install for me and then atach the database.I dont want to add the database as a Attached database in my project.i dont want to install crystal report in my application.I have some unused refernces in my application in my project which i want to removed, i have tried the default visual studio remove unused references but still have some references like shockwave.dll log2net.dll etc.
View 1 Replies
Mar 20, 2010
I was just wondering what is the Quickest way to set up custom settings, every software has settings that are created and saved, Example a Hotel Software has rooms, roomtypes etc that are used in combination with other things, an Accounting software has Account type, Employee Software will have Full time,Parttime, or anything else, An Employee time Clock would have departments, Tax Brackets.
[Code]...
View 5 Replies
Jul 1, 2011
I have created a setup using INNO which puts a Visual Basic 2010 Express program on the computer to update an Access database. It works on my Windows XP computer. On the user's computer, which is a Windows 7 computer, the Access database comes up as Read Only when opened. I get an "Operation must use an updateable query" error in the Visual Basic program when I try to create a record. The database has Read Only checked off in it's properties. But when you open it in Access 2010, it says Read Only at the top. (This computer has Access 2010. The database itself is in 2002-2003 format.) How can I get this database to be updateable on the user's computer? It works on my computer/does not say Read Only when opened in Access 2007.
View 3 Replies
Apr 14, 2009
I make a program-application in visual basic and it work OK. When I pack my application in setup project and make the installation, the database(in program) it did not save a new data or any update. Where is a mistake ?
View 3 Replies
Mar 26, 2012
I am creating a desktop application in vb.net by using visual studio 2008 and using ms sql 2008 as back end for my database.As I am creating application on my own system I know my connection string and I have created database manually on my system.
What I want is, when user install application on its system, the database created dynamically at that time on his system and he must enter server name, username and password for ms sql server that application should store for future use.If not at installation, it should atleast check and create database, everytime the user open the application.
View 2 Replies
Aug 21, 2009
how to i iinclude sql2000 database in vb.net desktop applications setup
View 2 Replies
Sep 3, 2010
How I make SetUp for program in vb.net with local database(data base which include in visual studio.net 2008) to make it work in other computers which not have the visual studio 2008?
View 7 Replies
Jul 15, 2011
I have a VB.Net program which reads and writes to an Access database. I am trying to deploy the program using a setup (created with INNO Setup). Upon installation on a Windows 7 computer, Windows 7 is preventing it from writing data without changing the permission settings. It reads data but it doesn't write data. This problem doesn't happen in Windows XP. My question is: is there any way to make the Visual Basic .Net program write data to an Access database on Windows 7 from the setup without the user having to change permission settings?
View 12 Replies
Jun 22, 2010
When i make Setup of my project then my crystal reports keeps old database path how can i resolve it please help me.
View 2 Replies
Dec 9, 2009
I am trying out the Visual Studio 2008 Standard Edition Setup and Deployment - Setup Wizard on a very simple VB 2008 app which includes a simple SQL Express dB. The build works fine and it installs on the target system ok. But when I go to run the application and add a new record for example, I get a "read-only" error indicating that the sql db is read-only. Yet none of the files in the folder are read-only. What is odd is that the folder that it was installed into "acts" like it is read only, yet it is not identified as such. If I move the .exe and db files out of that folder, (onto the desktop for example) it works just fine. Should I set up a post build event or something to make
View 6 Replies
Oct 10, 2010
how to create a setup in vb.net that comes with a ms access database and the .net framework if it is not existing in the system.. and also a crystal report... and also i want my database go automatically to C:
View 9 Replies
