I'm bulding a program that willl work with a database the database is made with mysql.I would like to know if there is a way to install the DB automatically with the application without requiring the user to create a mysql server...the db have more than 5 million records.
View 3 RepliesI have a project that i have created in Visual Studio express and SQL server express. i want to create an install file so that i can send to others to install. Currently it is requiring the user to install SQL server Express and 3.5 .net framework.what steps can i take to stop the user having to install these 2 so that it is a simple install for them.
View 2 RepliesHow can I create a VB application in VS2008 without requiring the application be run on a computer with a .NET framework in place?
View 4 RepliesI have successfully create a user name = 'root' and host = '127 .0.0.1 ', use the mysql command (client mode) as follow: sql = String.Format("CREATE USER '{0}'@'{1}' IDENTIFIED BY '{2}'; GRANT ALL PRIVILEGES ON *.* TO '{0}'@'{1}' IDENTIFIED BY '{2}' WITH GRANT OPTION;", userName, serverHost, userPassword) When the script above I change it to store procedure (server mode) as below, I found the error as follows: (Error 1064 - You have an error in your SQL syntax; check the manual That corresponds to Yout MySQL server version for the right syntax to use near 'pass' at line 1)
[Code]....
Is it possible to create a setup installer that will auto install fonts when user install the applications?
View 6 RepliesI'm working on a MySQL database with a VB.NET front end, and I'd like the installer to first install MySQL and Connector/.NET (if they aren't already installed) and then run a query to load the dump file that I'm including among the program resources.Is this possible, or will I have to instruct my users how to install MySQL and Connector/.NET themselves beforehand?
View 21 RepliesWhat i have going on, is i have a MySQL connector as a resource on my application, and im basically trying to connect to my MySQL server, to either a) register a new account, or b) check that the account exists and they are premium, and login, Now what i have run into problems with is: My MySQL Database Name has a _ in it which VB is not allowing for some strange reason.
The code i am using is below
Imports MySql.Data.MySqlClient
Public Class Form1
Function UpdateRecord(ByVal query As String) As Integer
[CODE]...
How i can allow the _ into the application, because the only databases that don't have a _ in the user or dbname are a) Paid ones which i DO NOT have the money for or self hosted ones, i cannot leave my computer on 24/7
My project is about recipes. I want to automatically create table inside in mysql database when I hit the add button on my project through codes. First is when I input recipe name in the textbox1 then my input will be saved in the recipes table under recipe name column and also create a new table through codes on what i input in the textbox1
Example of my database in sql
texbox1 input will be save here
recipes - id, recipename
And then it will also automatically create a new table in mysql database, create newtable, with id, quantity ,unit, ingredients
Private Sub iadd()
Dim command As New MySqlCommand("insert into recipes (recipename) values ('" & TextBox1.Text & "')", connection)
Try
connection.Close()
connection.Open()
command.ExecuteNonQuery()
[Code] .....
I need to define some roles in my program with defined permissions. Let's say the administrator can have access only to certain features. The officer in charge to certain features and the user as well. for example, I have several group boxes and the user can access one of it only. So how i do manage these permissions? What I want do is have the roles already with the defined permissions. When I create the user and assign the role, the user should get the permission automatically.
View 6 RepliesHow can I do it so every time the user loads my application it will automatically (without prompt, or user selecting) upload all the files in a folder i select beforehand and add them into ListBox1
View 16 Replieshow I can deploy my .NET applicationwithout the user having to install the program.i.e. In VB6, I could just create a executable file which did not require the user to install anything, they would simple run the program.
View 6 RepliesI am a new Visual Basic 2008 Express Edition and just finished and distributed my first program. However, one of my users (Using Windows Vista 64-bit) cannot install my program. He gets the following error An error occurred while installing system components for <PROGRAM NAME> Setup cannot continue untill all system components have been successfully installed. Component .NET Framework 3.5 SP1 has failed to install with the following error message: "Another installation is already in progress. Complete that installation before proceeding with this install." Other 64-bit users on both Windows 7 and Vista don't have this problem.
View 2 RepliesUsing Visual Studio .NET 2008 or 2005, is there a way to automatically generate properties for each column in an SQL Server database table? I am assuming other code-generation software exists that will do this. I know with Visio I can connect to my database and it will generate diagrams by table, this would be similar to that.
View 6 RepliesI wanted to know how I can make a stand alone exe without making the user install the application. So that the program can be ran from a disk or flash drive. Currently I can run it just fine on the PCs, I'm developing it on. But when I take it to another, that has the targeted framework, it crashes.
[Code]...
i, im new to this forum, but i know hot to use.i have 2 question
1- i want to create a application that make the same job that do CCleaner software, but i don't know the full code.can anyone tell me?
2-hot to create a application that don't need to be install
How do I create a desktop shortcut to my application when the user presses setup to install?
View 7 RepliesI have a datagrid control with a list of names that it retrieves from a MySql database. I can search through them until i have one result. I want to be able to Display a groupbox control when the number of results is equal to 1. Also, in the groupbox i have a button that when clicked will delete this user from the server and their information from the mysql table called "employee". when the user is deleted i'll display a confirmation message in a messagebox, and reload the table with the updated list. so far the only two problems i have are showing the groupbox when the results are equal to 1 and deleting the user from the sql server based on the name of the search result
Private Sub TextBox1_KeyUp(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles TextBox1.KeyUp
'Search Function.
[code].....
I was wondering if its possible to create a chat that runs off of mysql and not a server?
View 4 Replieshow to work with distributed application in vb.net that automatically stored data into server? How to configure to ensure the consistency of data being stored.
View 6 RepliesI developed a chat application with an attendant chat server. Everything is working fine. The issue now is the fact that whenever the chat server goes down (for instance, the server system shuts down as a result of power failure or some other problem), by the time the server system come back on, the chat server would have to be restarted manually.
I believe (and I know) it is more appropriate for the chat server application to restart itself when the computer comes back on (and of course regardless of who is logged in and of course, even before anyone logs in). I have a batch file that executes the chat server. My attempt was to create a windows service that start automatically and runs this batch file using a Network Service account on the server system. Although, I'm having a hard time with this (temporarily), I would love to ask if there are any alternatives to using a windows service.
how to create table in mysql server 2005 dynamically through vb.net
View 2 RepliesI would really like to know if there is anyway in which I can package two or more set up files together with my vb.net application; so that after installing the application, it automatically starts installing the other applications from the other set-up files.
In my case I want to include mysql server and client together with the application for a demo cd, that am making for a client.
I have an issue with my code. The application interacts with a MySQL database on a remote server, I have access to this server. When my app is running the insert into code I m getting this error: "Conversion from string "INSERT INTO phpvms_fsspireps(pil" to type 'Integer' is not valid."
The variable which holds the Inser Into string, during break point debug gives me this: ""INSERT INTO phpvms_fsspireps(pilotid, code, flightnum, depicao, arricao, route, route_details, distance, aircraft, flighttime, flighttime_stamp, landingrate, submitdate, accepted, log, load, fuelused, expenselist, source,
[code]...
And this is my code.
Dim conn As MySqlConnection
Dim cnString As String
cnString = My.Settings.constr
[code]...
the DB spec:
Total DB size: 190,1 MB
Total Tables: 106
and the table specs. The titles are in Greek but I think you can understand it from the data. [url]
how I can make my Application to automatically create preset folders with files when installing the application? The files should be under user/documents/MyApplication/Newpresetfolder
View 5 RepliesI have a project where I added visually and successfully a datasource of MySql. I binded a datagridview with a table.
But, how do I change programatically the password, ip or user to connect with the MySql server? Because it can change at any time, so I can let the user change these values.
I'm Using Visual Studio 2005 and Mysql Database to create a windows application. The datagrid displays all the records. Since I don't know how to directly update from datagrid, thats why I have used textboxes for the respective datagrid fields. A load button is provided which on clicking puts the data on the respective textboxes. The data can be edited in the textbox. Problem is that I can't save this edited or modified data back into dattabase.
[Code]...
I have made updates to my programs, including a large update with the fonts on my forms. The only problem is this font is not found on vista or Windows XP and must be downloaded. The program is completely ruined with its looks without it. Is their a way so that both Windows XP and Vista could download these fonts, On startup of the first form, Form Load maybe? Even if the user says that he or she would like to see the program with the fonts? I just don't want to take the many hours i wasted resizing with the new fonts, ect. If it would be easier I could ask the user if they are using Windows XP, Or Vista?
View 10 RepliesI am linking VB.2008 with a software called R.
Different people may install R in different directories or different versions.e.g. My R dir is C:Program FilesRR-2.9.0
How can I let VB automatically detect it and return the directory path to me?
With the on-line one click install feature will the application install on a MAC?
View 2 RepliesWhile trying to install my application, when system tries to install .Net Framework, it gives an error.Is there any source where I could download uninstalled .Net Framework 3.0 and provide my clients with application?
View 1 Replies