VS 2010 To MySQL Or Not To MySQL?
May 19, 2010
Now I have my databases in .sdf-files. These files are located on a server and loaded into several listviews. It has worked fine for a while, but I found out that last week one of the computers didn't close the connection with the database, which resulted in (a bunch of) errors on the other computers.
I have a mySQL server (external) where I can add the data into, but I think that it would slow down the loading severely, but it's very important that people can import the data at the same time.
View 4 Replies
ADVERTISEMENT
Jun 21, 2012
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
View 3 Replies
May 1, 2011
How connect Vb.Net to MYSQL..? How to add info to database user informations using mysql database. How to call login infos using mysql.
View 8 Replies
Apr 11, 2011
I have determined thanks to the last q & a that there is something wrong with my "save to db" code as well as my "retrieve to picture" code. Even If I manually save the pic in the db it stil wont retreive. This is code i patched together from 3 or 4 examples around the net.
Dim filename As String = txtName.Text + ".jpg"
Dim FileSize As UInt32
Dim ImageStream As System.IO.MemoryStream[code]......
View 2 Replies
Sep 22, 2009
MySQL databases exists for saving values as strings (text only). Is there any way that i could store files with the same speed as a mysql command ? I know that it depends on the file size but lets say that the file is "Avatar.jpg" 50KB... I ve tried FTP but this is not what im looking for. e.g. You want your users been able to upload a file like the [Add This Attachment] button does in dreamincode.net and you dont have any background on PHP/HTML/Javascript/ASP.NET just VB.NET and the basics of MySQL plus you dont want to use it for a website. How do you accomplish this? Something silly that ive tried was opening an image as text then update the mysql server with that text but it didnt work backwards after i wrote the text on the file and oppened it ...it said that the image was corrupted.
View 7 Replies
May 3, 2010
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]....
View 6 Replies
Aug 27, 2011
i Built A MySQL Login System Using MySQL Connector But If Other People Want To Use The Program Thay Get An Error, I Think This Is Due To Thay Do Not Have The Connector So What Should I Do, Btw Dont Say 'Tell Them To Connector'!
View 5 Replies
Nov 16, 2009
Im 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]...
View 2 Replies
Jan 30, 2011
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 Replies
Mar 21, 2011
I have a query from within my vb.net code which searchs for a record by date. The date being entered via the code is in format dd/mm/yyyy, i need to search in the database using yyyy/mm/dd? Ideally i thought there may just be a function within MySQL which will convert this. If not in vb.net to convert the string 01/01/2011 to 2011/01/01?
View 1 Replies
Feb 26, 2012
What i am trying to do is get my system to look into the database and recognize if the user is a admin or a user, based on that they have certain rights below is my code
Imports MySql.Data.MySqlClient
Imports System.Data.SqlClient
Public Class Form3
[code]....
View 5 Replies
Jun 4, 2010
I'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 Replies
Sep 20, 2011
error " Unable to cast object of type 'MySql.Data.MySqlClient.MySqlException' to type 'MySql.Data.MySqlClient.MySqlDataReader'. " ?
THIS IS THE CODE Ssql = "SELECT ItemID, Prodname, qty, Desc, Cost * FROM items ORDER BY ItemID ASC"
[Code]...
View 4 Replies
Jun 13, 2010
im a beginner in visual basic.
View 4 Replies
Mar 8, 2011
I am trying to connect my application to my database that's hosted on my website through another host. I am using the System.Data.SqlClient Namespace, and I have tried about every connection string possible, and I either get a long delay (About 30 seconds) before the main form displays with a warning in the Console box or it just gives me the warning and loads fast. Either way, it's not connecting.
code:
The x's represent just a masking. The server value is the ip address of my website. Basically, I am wanting this app to connect to my database of my website and it will be used to compare login information as well as the status of the logged in account (blacklisted, active, or needs to be activated).
View 14 Replies
Jul 6, 2010
I'm used to use the Listview, but need/want to use the datagrid. The problem is that I have never used the datagrid, so don't know how to import the data from the mySQL-database. I'm loading the data directly from the database, without any dataset.The code I use:
vb.net
Try
mysqlConn.Open()
Dim mysqlComm As New MySqlCommand(strBeslagdataComm, mysqlConn)
[code]....
View 2 Replies
Apr 23, 2012
I'm coding a personal auth system using MySQL and I have made it using MySql.Data.MySqlClient but when I build the final version people required the MySQL.Data dll to run the application
Is their way of not requiring this or another way to linkup?
View 2 Replies
Jun 18, 2012
I've written an application and I'm trying to utilise a database behind it. I've created a mysql database, and table which all appears to work correctly. I appear to have connected to the db correctly too. And hit a bit of a brick wall. As a side-note, within Visual studio connected to the database using the add data source wizard, I then dragged and dropped my db table's column onto my form that intends to display them all (6 textboxes, including primary key) and that now displays the first record of the table. It confused me, because i did this as soon as I had setup the database with no visual basic code assisting, so there wasn't even a connection string?!
One functionality i want to have is to press a button and cycle through the table's records using the form by the unique id, how would I do this? I'm essentially asking how can I enter a number in a textbox which would then return me the relevant primary key and data attached to that record.
View 1 Replies
May 21, 2012
I'm pretty new to Visual Basic, do mostly web programming in PHP/MySQL. Need to pull data from a MySQL Database using Visual Basic Program I'm making. Need to when I click a radio button, it shows in text box only the results from a table with a certain trait(as set in the database) etc. For example if an item is set to a certain category. And i click the radio button for that category it shows me only items in that category. I've attached an image of sort of what I've got. I've already downloaded the ADO connector from mysql site. I just need kind of a push from there or a link to a few really good articles. Followed a few youtube videos but I was unsuccessful somehow.
View 1 Replies
Aug 5, 2011
Im trying to execute on the click of the submit button adding the text in textbox 1 to the field status within the mysql table. My code is:
Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged
End Sub
Private Sub Submit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Submit.Click
[code]....
And the error I get is NotImplementedException was unhandled.
View 2 Replies
Aug 16, 2011
I'm using the latest version of the MYSQL DotNet Connector (currently 6.3.7) and I am unable to connect to my database at all with it. It keeps giving me an error. I can connect the the database using SQLyog with the exact same information but not with this.
This is the error:
A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond Here is the code I'm using:
Dim conn As New MySql.Data.MySqlClient.MySqlConnection("" _
& "server=mydomain;" _
& "user=myusername;" _
[Code]....
View 7 Replies
Nov 18, 2010
I have an app, that is going to connect to a remote MYSQL DB.I've look around online, and didnt find any good resources. I've seen some where you have to download an odbc driver etc
View 10 Replies
Sep 3, 2011
I want to add a new Data Source (so I can use it with Crystal Reports) but using mysql, I did this before.
In the left side under: 'Data Sources' and then choosed 'Add New DataSource'Then I choose: Database > Dataset I clicked in 'New Connection' and I changed the first box (with 'change' button (as you can see in the image attached)) to what is showed in the image (MySQL Database..)The problem is, as I type the first letter of any of the textbox's that are below (server, user, or pwd) it closes that form showing the previous form (where I clicked 'New Connection')
Have someone had this problem ?I had a connection there, but since I changed the project from 'Framwork 4 Client Profile' to 'Framework 4' (so I could have the Crystal Report Viewer) the connection has gone and don't leaves me create it again.PD: I'm using dotNetConnector (already Added as a Reference)
View 2 Replies
Mar 27, 2012
I have a MySQL Table that I would like to insert stuff into using VB.NET.[code]
View 15 Replies
Feb 2, 2012
I know this is simple, but for some reason.. Im just simply trying to take my whole dataset and put it into my premade mysql tables.
[Code]...
View 15 Replies
Sep 11, 2011
So I'm creating this little app to generate words from A-Za-z0-9 and then save that on my local database.Here is my code to do this:
[Code]...
PS. Fell free to help me modify my code. It's quite simple and horrible since if I start generating words more then 5 characters long, it will crash
View 15 Replies
Jul 6, 2010
My program needs to connect to a mysql db, but if the users has no internet or fails to connect i don't want my app to crash
View 4 Replies
Oct 7, 2011
I've gone through different sites and got ideas about how to connect MySQL but it didn't work.
Imports MySql.Data.MySqlClient
Public Class Form1
Dim con As MySqlConnection
[code]....
View 6 Replies
Sep 16, 2011
I am trying to follow this userguide url... to basically build an application that will allow users to connect to my database, from an exe file. I'll try to explain as best i can. The plan is, users will launch an exe file that i have built in Visual Basic(VB) 2010 Express. When they launch the application they will see a 'login screen'.I am following the example guide (see link above), and will customise it once i can connect to the database. For some reason whenever i connect to the database it gives me two errors, the first is if i use the 'debug' mode in VB to test the script (note it doesn't produce any build errors), the second is if i build the application and run it as my users would.
1)Error Connecting to Database:Access denied for user 'mike'@'92.**.**.***' (using password:YES)
2)Error Connecting to Database:Unable to access any of the specified MySQL hosts..The ip address starred out (*) is my local machine ip address.The server is the server in which my Database runs on. 'mike' is a listed user on my 'user' table, the password i use is the password assigned to this user on my table.
3)I've rebuilt the whole VB project, but still no joy, wern't expecting it to as there were no errors generated.
4) I've read, but don't really understand that it could be something to do with my database not being able to be controlled remotely, only locally. I started digging into 'Access Your MySQL Server Remotely Over SSH', didn't really know if i was going completely off the mark, it didn't mention needing to do any of this in the guide i've been following, but just a thought. It might be the case as i've tried to access my database through a programme called MySQL Administrator. I punch in the host,username etc and connect to my database, for some reason it won't allow me to add new users, could this be because i can't control my database remotely? Would this stop what i'm trying to do working?
5) When trying to install the MySQL.Data.dll file i had great difficulty in choosing one and finding it, adding it to my project using the 'Add reference' in VB. Finnally got it how it should be (i think), installed MySQL.Data.dll Ver 6.1.2.0 into my project.
View 8 Replies
Oct 3, 2011
I want my vb application to communicate with a MySql database on server on a LAN. What connection string can i use? Also, what syntax can i use? My application is installed on many computers in LAN with one central MySql database. I want all data to go to the database.
View 1 Replies
