iam working to develop a CMMS software for my company this software will connect to MySQL over LAN or WAN and i will update and view data from MySQL many times in software (to insert, delete, update,...) now i code every time i use the data , i connect to mysql and make my order and close. as the following code
[Code]....
I am trying to make a login system mysql try to connect to a mysql database.
Here is my code:
Imports MySql.Data.MySqlClient
Public Class LoginForm1
Dim MySqlConnection As MySqlConnection
Private Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK.Click
MySqlConnection = New MySqlConnection()
[code]....
I am trying to make a login screen that is connected to a mysql database. I cant seem to get it to work it keeps giving me an error that says ("there is already an open datareader associated with this connection which must be closed first")
Imports System.Data.OleDb
Imports MySql.Data.MySqlClient
Public Class SalePersonLogIn
Dim con As MySqlConnection = New MySqlConnection("Data Source=localhost;Database=testdatabase;User ID=fvfvxcv;Password=cxxvx;")
[Code] .....
What 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
We have a VB.Net application which works fine in our tests in different Windows XP SP3 machines. However there is one machine in which is displaying this error:
Unable to connect to any of the specified MySQL hosts
Using the mysql command, we can successfully connect to the database. We already checked for any other application or firewall that could be blocking the connection but it seems fine. We also reinstalled the system (no errors during the installation) but the MySQL error message doesn't change.
The system settings are exactly the same as in the other computers. We are using "localhost" as server in the connection string. The "hosts" file has its default values (nothing strange in there).
I have made a music player, using the windows media player dll but now I want to make a graphic frequency equaliser
View 6 RepliesIm building an app to manage PSP contents, and it should connect to my MySQL server on my domain to refresh game info and ratings and so on, but I cant make it connect with MySQL Connector 6.1.
[Code]...
I can have mysql database. but i have not mysql. how to connect this database vb.net 2005. but i have mysql-connector-net . I want to mysql-connector-net use to connect this database. database path(C:Documents and SettingsAdminMy DocumentsVB.NETStock delnaSTC.sql)
View 3 RepliesI am trying to connect to my remote MySql Database within Visual Studio using the compact framework.
I can successfully add a data source and preview the data within the IDE so assume that the connection is ok regarding Connection strings and remote access.
However, when I attempt to access the data using any run time control I get the following error when the table is loaded using the .fill method.
MySql.Data.MySqlClient.MySqlException was unhandled
ErrorCode=-2147467259
Message="Unable to connect to any of the specified MySQL hosts."
[Code]....
I'm trying to make this program that counts the frequency of each letter in the alphabet for a set of ciphertext, the calculation i want to do is:lettersum*(lettersum - 1) + lettersum*(lettersum - 1) for however many letters example: User puts aabbcc in the ciphertext box , the output should be
2(2-1)+2(2-1)+2(2-1) =6 If the user inputs aaaaab the output should be 5(5-1)+1(1-1) = 20 The code I have so far only counts the last number of letters for example: aabbcc only reads the cc part and only outputs 2(2-1) = 2 instead of 2(2-1) + 2(2-1) + 2(2-1) = 6.The code below is part of a button_Click item
[Code]...
I want to make an button that runs an action with the frequency from an number input in Visual Basic .NET . How do I do it? Could someone point me out the syntax of such an action?and all that I want to do is use an number from "NumericUpDown" to give a button how many times the action the button has to do it.
View 2 RepliesI'm connecting to my mysql server using ODBC in vb.net, the database is shared throughout the company because it is used in an accounting program (simply accounting), each user has their own account user/pass to login to the database. I have developped a program that uses the accounting database and combines it with other information, my problem is that at least once a day I get this error when I run my program: "(10061) ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on"and the error persists for at least 4 hours, for some reason it starts to work again later on in the day.
View 1 RepliesI have build a program until now with an MySql database. The programs add records for the customers and the products of the company(Its works perfect).. I am trying to build now the Orders the last part of my project but I have a little problem.. First of all I need 4 different type of database:
Cash
Credit Card
Check
Debit
Price Offer
This is the the type of the payment. The user must add the order by the payment of customer so we need to seperate each one.. Unitl here I am fine::
Now, my serious problem is with the order table:: If i used the code that I use for my other adding records (like product and customers ), for each order it's add only one product!! BasicallyI need to be able to add multi products and the user have the ability to change the price of one product:: for example "to make an offer for some special customers" without change data into the database of products..Thats has a lot of typing code but I need a base to start since I have a little bit of confused. At the end am trying to load data from database customers into text boxes:: for example the user select one name that loaded into a combobox and then appears the city and the mobile into a text boxes I build a code below but it's works only One type, actually fill the text boxes but after I clear all the boxes and try for a new customer or the same isn't fill anything.
Dim ServerString As String = "Server=localhost;User Id=root;Password=root;Database=test" ''Sting Server
Dim SQLConnection As MySqlConnection = New MySqlConnection ''SQL Connection
Dim Sql3 As MySqlCommand = New MySqlCommand("SELECT * FROM customers", SQLConnection)
[code]....
I'm developing software using vb.net. I want to do following things in my application.
View 5 RepliesI have an application running with a access db. I have written some code to copy & zip the db file to another location (selected by the user) for the purpose of backup. (I am using sharpzipwrapper)Whenever I try to run the code for the copying & zipping it gives me an exception saying that the file cannot be zipped as it is use.Do I have to close all open connections in order to backup the .accdb file? If yes then how? else what do i have to do inorder to get 'access' to the file.Do I have to exit the application to close all connections? These connections are written in code for e.g. :
dim
cnStudent as
oledbconnection
[code].....
do u need to download something for VB2005 to connect to a mySQL db?cant connect to mysql db?
View 2 RepliesI am trying to connect to a MYSQL database using VB.NET to handle some simple tasks at a page level. Usually the connections are made to a MYSQL database. I have downloaded a MYSQL-CONNECTOR 6.0.7. How do I reference or add this to my web project so that I can create the connection and use the provided methods?In the unzipped package I download I do not see any dll files so not sure what to do with this ATM, I am used to seeing a bin folder which contains this.
View 2 RepliesI write an HTML file with MS Word, and use it on my application. The problem is that I need to close Word or Visual Studio in order to save the file, or compile the code, because each one reserves the file permission rights. The html file is only written by word, and only read from VS. At compile time, the file is copied to execution directory. Is there a way to give both programs simultaneous permission rights?
View 4 RepliesI'm just looking for an answer or idea.I plan to connect vb.net to mysql (which is done) and also the PHP connected to the mysql.But I'm confuse with something.VB.NET is use for offline things (which people will come to store and buy), but PHP is buying / booking online. (You know the airport things right ? customer can directly go to the airport and buy tickets or they can buy tickets from the internet)
For ex :Customer A come to airport and buy a ticket which is only left 1 tickets. Customer B wanted to buy from the internet. Both of them saw there is only left 1 tickets. So, both of them buying. When Customer A buy, the employee click buy at the same time with Customer B.In here, I'm confuse, how to declare which person should get the ticket because they click buy at the same time (server time because PHP and MySQL located to the server and vb.net applciation located to other PC/Machine) ?.
I have a VB.Net application that must connect to online MySql database.I already have a MySql database and I connected to it from VB.net using the MySql connector (new instance and direct connect).All I want to do is to connect to this database via a PHP web service, this will make a fast connection and more users can be connected at the same time.I tried to search for this, and I think that the solution is easy and simple, but I don't know a lot about PHP; how to upload files and connect via Web service Reference in VB.net.I downloaded these files: RemoteMySQLDatasetWS.zip And RemoteMySQLTest.zip. from: http:code.google.c.../downloads/list. which contains ".php" / ".wsdl" / ".dll" files and a VB.Net test solution.I uploaded the files (".php" / ".wsdl" / ".dll") to the FTP manager in the cPanel where I created the database. The problem is, First: I don't know if these files are working.Second: if they are working, I don't know how to accesss these file via HTTP, so I can add the "server.php" address as a web service reference in VB.Net.
View 2 RepliesVB.NET Express 2010.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[Code].....
Just got a mySql database up and running (about 3 weeks ago) and it's working fine for web pages with PHP, but wanted to see if I could access it from Visual Basic (why not right). So I downloaded whats needed to get the MySqlConnection working and Been looking around online and nothing is very intuitive as to what the problem is. The error message is:
MySql.Data.MySqlClient.MySqlException: Host '192.168.2.184' is not allowed to connect to this MySQL server
How to connect mysql to visual basic 2008?
View 2 RepliesHow do i connect MySQL to VB2010. eg Provider=???
View 2 RepliesI try to connect my programe with MySql on my computer but it could not execute. The error like attached image file.[code]...
View 6 RepliesI want to use datasources or something to connect VB to mysql db and execute a querry with the information filled in and standard information.
i know how web scripts work with mysql but in VB i cant find any tuts anywhere about mysql and vb
need to connect to a MySQL 5 DB from VB.NET [2008] 3.5 Framework from code.Help ..need the connection code
View 11 RepliesHow to connect using MySQL connection?
View 1 Repliesim a beginner in visual basic.
View 4 Repliesi installed visual studio ( full installation)then i got xampp from their site i have mysql and apache running i downloaded the connector from mysql site and i created a simple project to check if i can connect to mysql or not i have made this code so far
Imports System.Data.SqlClient
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim Connection As String = "Data source=localhost;user=root;password=;Initial Catalog=test;Integrated Security=true;"
[code]....
im having trouble with an exception though it says {"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"}
how can i get rid of this, is it because i installed mysql 2005 with visual studio 2008? and maybe it runs with xampp's mysql and creates these problems?