MySQL And VB 2010 (.NET/Express)
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
ADVERTISEMENT
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
Jan 18, 2012
I've been reaserching for 3 hours on how to save data and retrieve data in mysql database I am using vb.net 2010 it would be nice if someone will post some codes or links
View 7 Replies
Jan 7, 2011
My question is how to link database from MySQL2005 with the interface created in Microsoft Visual Studio 2010 Express?Is it possible to link the database into my interface?
View 2 Replies
Jul 15, 2010
I have been reading about ADO, SQL, datasets, data adapters etc and have gone into information overload. My next step is to create a simple data file of my own that I can manipulate, update, sort etc in VB Express. Do I need another piece of software? I read about MySQL, which I understand is primarily used to access databases on the net, but can that be used to create a simple local data file on my PC? Can you simply hard code something in VB Express?
View 6 Replies
Feb 29, 2012
I am trying to make a user account SQL database work with Visual Basic 2008 Express for login purposes, i.e. usernames & passwords. Plan is to host this server so people can login to use the the application and verify they have a valid account. I would like to host all the account information in SQL due to the possiblity of hundreds of users at any given time. I also need the ability to add data to the database for users registering for the first time. The SQL server will need to be able to access the SQL Server databases remote via WAN.
View 3 Replies
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
Jan 12, 2010
I am trying to figure out how to connect to a MySQL Database and manipulate it using VB Express 2008
View 6 Replies
Dec 7, 2009
I downloaded the free Visual Basic Express Edition to create an application that connects to a Mysql database. I searched for the connection string and found a bunch of different ones.I have no idea which one should I use with Visual Basic Express Edition. I have been using PHP, javascript and mysql for a couple of years, but I have never used Visual Basic and have everything to learn.
View 2 Replies
Mar 22, 2009
I am looking using VB.NET 2008 with MySQL and I have a question regarding connectivity support for MySQL between the Express Version and Professional version. As far as I can tell you can connect to MySQL in Express version provided you have the .net connector for
MySQL and you have to code the connection and call it every time you want to use it. The IDE does not really support it. I want to be able to use Add Connection connect to MySQL via ODBC and then bind controls to it. For this do I need the professional version? What exactly are the differences between Express and Professional version with regards to MySQL?
View 2 Replies
Apr 8, 2011
I've installed MySQL .NET connector but it's not shown in data source options to connect in Visual Studio Express Edition.
View 2 Replies
Jun 12, 2011
What driver do you need to connect vb.net to MySQL?How do I create a Data source to MySQL? am only getting the options for SQL and MS-database! am designing a reg system for a college
View 9 Replies
Oct 16, 2010
I tried to start using VB 2010 Express with a program I originally developed with VB 2005 Express that I moved to VB 2008 Express successfully a couple years ago. It uses a database file (*.mdf) that is on the computer ( not out on a server). When attempt to run the program in debug mode, I get the following error "An attempt to attach an auto-named database for file C:Documents and SettingsTomMy DocumentsQuizzing StuffQuestion Database 2010QuizQuest ionGameQuizQuestionGameinReleaseQuizQuestionDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share."
I first made a copy of the entire project folder that was working in VB 2008 Express and gave it a different name. In VB2010 I opened the project in the copied folder and it said it successfully converted the project. I am able to open the Data Source inthe Designer and see the database structure as I expect. I think the project is still using SQL Server 2005 Express (because it is what is checked in the list of prerequisites on the Publish tab).
Note, I have programmed off and on for many years, but fairly new to using databases and SQL Server.
View 3 Replies
Feb 29, 2012
Here is the scoop: I am trying to make a user account SQL database work with Visual Basic 2008 Express for login purposes, i.e. usernames & passwords. Plan is to host this server so people can login to use the the application and verify they have a valid account. I would like to host all the account information in SQL due to the possiblity of hundreds of users at any given time. I also need the ability to add data to the database for users registering for the first time. The SQL server will need to be able to access the SQL Server databases remote via WAN.
View 1 Replies
Jan 21, 2011
I am trying to re write a VB6 program using MS Access, many years ago, using VB 2010 express and SQL server 2008 R2 Express. I have a database with several tables, which I created using the designer. I am able to connect to the database and select data and display it in textboxes etc in vb code. What I have not been able to in code is to INSERT rows DELETE rows or UPDATE any data in the tables. I can do any of these operations using the Query Designer, but I want to do it in code. I can post some code if necessiary, but I thought it might just be some property that I had not set in the designer.
[Code]...
View 13 Replies
May 12, 2010
Is VB Express 2010 slower to compile and run that older versions of VB Express? I've installed it this weekend and it seems a little sluggish on my quad core computer with 1 gig of RAM. I have VB Express 2005 installed for my students at school and it seems to fly just fine. Those school computers are older P4s with 512k of RAM.
View 7 Replies
Jun 3, 2011
Initially my app worked with excel fine, now it causes my computer to reboot only after Excel has been opened (two or more times). I have opened and closed Excel files 20+ times without running thru either of my apps (they all uses identical code for excel) and it has never caused a reboot or a crash.
run either of my apps and have the app control excel has become a crap shoot, it will reboot my computer. Adding to that I then have to do a manual shutdown because the reboot process after is unstable. (System doesn't respond properly). My code in this app is small, should make for a good example. I can provide the entire project to anyone who would volunteer to test it. (First I need to know how to send the project).
[Code]...
View 10 Replies
Feb 29, 2012
there Dream in Code Community! Im an okay programmer as far as skill right now I am still learning as we all are I need some help from some experienced VB.NET programmers in the community, Here is the scoop: I am trying to make a user account SQL database work with Visual Basic 2008 Express for login purposes, i.e. usernames & passwords.
[Code]...
View 2 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
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
Aug 19, 2011
If I create a DLL using VB 2010 express can it be used by previous versions of of .Net (3.5, 2.0)? Will the DLL use .Net 4.0 components, which is what I want. I don't see a way to force that to be the case.
View 1 Replies
Mar 26, 2012
this is my very first posting and I must say I am desperate. I have a VB assignment due in 2 days and I am so lost. I have written a code to draw some graphic, just a basic house, tree, sun etc. I have also written a code to magnify said graphics which were all the specifications of my Assignment 1 part A. Now for Part B I am being asked to extend my program so that: A - My graphic can be drawn using different colour schemes designed by me but chosen by the user B - My graphic or an appropriate part of it can be animated around the picture box if the user chooses to do so. C - Error checking is included.
[Code]....
View 2 Replies
Mar 7, 2012
Is it ok to install my VS 2010 Ultimate even if I already have VB 2010 Express Edition? or should I uninstall the express edition first?
View 3 Replies
Nov 3, 2011
Here are my questions concerning VB 2010 Express:
1. I've registered my VB 2010 Express, will it still expire?
2. Will the applications I made using VB 2010 Express expire after some time?
3. Is it OK to write my code in the designer.vb file? I don't know why, but when I started writing my application it took me to the designer.vb instead of form1.vb code.
4. I've been working on an application for a week now, but suddenly I can no longer access my Design View(Shift-F7). All my codes are written on the [form name].Designer.vb. I can still view my codes but I cant access my form layout. On the solution explorer, my forms no longer have the 'form icon'. When i press Shift-F7 nothing happens. Right-clicking the form on the solution explorer doesn't show 'View Designer' option. How can I fix this?
View 5 Replies
Mar 16, 2010
I just downloaded the Visual Studio 2010 Express for Mobile Phone. C# is the only language available. Will Microsoft add Visual Basic as well? When?
View 5 Replies
Apr 14, 2010
I was looking all over but didn't find how to change VB 2010 Express default gray theme?
View 4 Replies
Oct 7, 2010
I am learning VB for the moment. I want to copy/paste code from a PDF to Visual Basic 2010 Exppress, but if i paste the (structured in PDF) code to VB, i get 1 long string of code and need to restructure it by entering after each line. Otherwise VB gives me a lot of errors. This is a time consuming work. Isn't there a way, VB puts the code in the right format?
View 4 Replies
May 23, 2011
I'm trying to create an installer with VB 2010 Express. In order to do that, I need my project to have some files embeded so I can copy them in the installation directory. How could I make this (embed the files and then acces them from my code)?
View 7 Replies
Jun 13, 2010
im a beginner in visual basic.
View 4 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
