1. Visual Basic
  2. Simple remote MySQL database in VB Application

Simple remote MySQL database in VB Application

Submitted by emond on Friday, May 29, 2009 - 20:18.
Language
Visual Basic

 a simple database app that can be used to manipulate your website's MYSQL  database, applicable in administrating your web databse from your Windows based PC .Connection is  via MySQL ODBC 3.51 Driver. CAn perform CRUD and it shows how to connect and query records in a remote server (for this sample i used www.freesql.org) using ADOdb control and datagrid to show data from remote server..

I'll Post my VB to IBM AS400 Server connectivity projects soon...please watch out

 

Hope you like it..

TODO:

download the MySql odbc driver 3.51 driver in mysql websites..

 

questions and design projects?

Mobile

+639399393702 +639155338048

Blog Site

http://www.freeprogrammingtricks.blogspot.com/

Facebook Fan Page

http://www.facebook.com/emondsoft/

Skype

My status

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Tags
visual basic
MYSQL
Remote Server
Remote database
VB Mysql
ODBC
CRUD

Comments

Submitted by Anonymous (not verified) on Sat, 05/30/2009 - 14:49

I am looking for this kind of project. Thank you very much for the code.

ur welcome..U can freely modify or improved the sample.. for your questions and request tutorials email me cheers!

Hi i'm doing my project in accesing remote database of a mobile phone.. Which protocol is suitable for accesing database of the mobile phone from another mobile phone. Kindly give me some idea about this........

Submitted by Anonymous (not verified) on Sat, 05/30/2009 - 15:13

Hello Do you know how to send an MMS data in vb.net? i have this apps that export its data to xls format. my problem is that i would like also to put a functionality that the file exported is also can be send through mms or sms. if you had a such source code or tutorial please kindly post it here... Thanks and God Bless

hi sir, i have created some SMS projects in the past.. i used GSM Modem/Phones and some SMS Server,SMS ocx and gateways in order to put send/receive SMS/MMS functionality to my projects.. I posted a sample SMS app written in vb6 in this site but it's not well commented coz its just my sample.hope you will able to try that.. PM or email me if u want a ample in .NET , i will be glad to help you.. Goodluck

thanks for sharing all of your program, this site is so important because they help some beginners in programming, I hope that you shared always your program, thanks!

Submitted by Anonymous (not verified) on Sat, 07/11/2009 - 16:02

Hello sir, I want sample code of sending the sms from vb project to mobile and mobile to vb project. from where I shall I got that.

i posted a sample using At commands but since not all phones are supported by AT i have different Commercial systems using SMS Server and GAteways and other are Active X..if you want sample using other technology just PM me dark_raditz0825

Submitted by Anonymous (not verified) on Thu, 07/16/2009 - 18:09

Think about the refresh the table after the search. Regards.

Submitted by emond on Thu, 07/16/2009 - 22:07

it's just a sample for database connection, not for searching data purpose..

Submitted by Anonymous (not verified) on Mon, 07/20/2009 - 12:35

hi sir, i am a bigginner in myysql, and i have some trouble on binding pictures in vb6 from mysql database. can you help me, my email add is [email protected] thanks in advance

Submitted by Anonymous (not verified) on Mon, 07/27/2009 - 08:18

Hello. This is exactly what im looking for since i program alot php it would be superb if i could make a application wich could control the databases as well. Im not a very experienced vb user, but i get a error when i try and run the program, saying .connectionstring method or data member not found :S any solutions? i got the mysql odbc driver installed. //Neess [email protected]

Submitted by Anonymous (not verified) on Tue, 07/28/2009 - 12:12

Can anyone recreate this in VB 2008? Thanks

Submitted by admin on Wed, 07/29/2009 - 17:18

Wait for my code in the next coming day.

Submitted by Anonymous (not verified) on Tue, 09/08/2009 - 12:18

Hello... Anybody can help me create a VB6 programs that will read messages from my Globe Broadband... I have already tried to send message from it and it works.. But i dont know how to read messages using VB.. Thank you and i hope you can help me... IRWIN CANSEJO

Can anyone help me how to send an SMS via VB6.. thanks a lot..

Submitted by ashwa on Sat, 11/07/2009 - 21:00

Whenever I try to open and run the project,VB 2008 is tryiing to upgrade it. And while upgrading, the upgrade wizard shows following errors: "upgrade failed : exception occured couldn't load referenced components: msbind.dll,sapi.dll,MSRDC20.OCX,...etc.. It is recommended that u install VB 6.0 with all referenced components & ensure app compiles & runs before upgrading" what does this mean? I have installed VB express edition 2008, what else shpould I install? I want to make an application in VB which accesses mysql and uses data reports to generate reports. plz help!

Submitted by Anonymous (not verified) on Tue, 01/12/2010 - 03:51

I am trying to generate reports in vb6 on an MySQL 5.0 database but am lock up! my problems is how to create a data link and a data environment. will be greatfull to anyone who help me out!

Submitted by Anonymous (not verified) on Wed, 02/03/2010 - 02:00

Great code to access MySQL remotly with ADO Confused though I can access every single table from the MySQL database except "Products" table. Can not find any solution and wondering if you can through some light/help that could resolve the issue Thanks Rana

Submitted by Locustv2 on Sat, 05/22/2010 - 01:53

hey that seems to be nice. actually i like creating small apps in vb for myself and i was googling for how to use mysql and vb how to connect, read and write to mysql from vb. and i dropped here. that could help me but i can't find the sample. where can i download it?

i watched the server.zip and its very interesting. i have one question thougn.. if i have another table that i am using in my program how do i close connection to current table and open the other... and how to close connection completely from mysql?

Submitted by Anonymous (not verified) on Mon, 06/07/2010 - 21:29

hai.. This is my first project in VB. I need to establish connectivity between VB(frontend) and MS Access(backend) using ODBC. please give me the coding and instructions for how to connect. Here is the situation. the details of the Information Request Form will be submitted to the backend. Hope you will post reply...

Submitted by Anonymous (not verified) on Sun, 06/20/2010 - 23:00

Can Anyone help me on below situation ... Tq : I want to link a Microsoft Access Database from 1 PC to another PC using Internet Link , i want it work just like the teary of LAN , but it is in WAN, Can ? And the Coding is in VB6.0 , Tq

Submitted by Anonymous (not verified) on Fri, 07/02/2010 - 18:33

Sir, i cannot connect to the mysql database in the other computer im using vb 6.0 every time i run the program it will prompt error Mysql ODBC 3.51 Driver host "my computer name" is not allowed to connect this mysql server. here is my connection code: Set conn = New ADODB.Connection conn.ConnectionString = "driver={Mysql ODBC 3.51 Driver};" _ & "SERVER=localhost;" _ & "PORT=3306;" _ & "DATABASE=Information;" _ & "UID=root;PWD=; OPTION=3;" conn.Open can you give me some idea how to solve this? plz...

Submitted by Anonymous (not verified) on Wed, 07/14/2010 - 11:38

Hi, sir. I am doing an app using VS C# which requires me to connect with one central PC sql server 2008 database. I have tried on finding lots of method online but still cant get it. Can sir give me some ideas on how to do it? Thanks.

Submitted by Anonymous (not verified) on Sat, 07/17/2010 - 18:26

Does this solved the problem of maXimum concurrent connections which there are no problem in connecting a VB application from many clients?...

Submitted by Anonymous (not verified) on Thu, 07/22/2010 - 14:53

i want know, how to by pass firewall and sever using ssh or telnet...? is it possible to do this ??? Any body has any idea then reply me...

generally you need a wrapper, a proxy, a tunnel, or a vpn connection. PuTTY will do tunnels. You may need to adjust a line in the source: .ConnectionString = "Driver={MySQL ODBC 3.51 Driver};Server=www.freesql.org;Port=3306;Database=dbobri;User=obri; Password=emondyhen;Option=3;" or settings for the odbc driver to use the tunnel.

Submitted by Anonymous (not verified) on Tue, 08/03/2010 - 20:03

Dear sir i want to connect remote databse (mysql) via vb6, i download your zip file & done necessary changes : my mysql database install on server i connected through Php but i cant vb6 help us but i get error [MySql ODBC 3.51 Driver] Can't connect to MySql server on (10061) how can i solve this problem, plz help me. my email id is [email protected]

Submitted by Anonymous (not verified) on Fri, 08/06/2010 - 14:25

hello EMOND, i have downloaded your server.zip and mysql odbc 3.51 driver.. when i run this project---- display connection error.. Adodc1 [MySQL][ODBC 3.51 Driver]Access denied for user 'admin'@'210.212.141.158' (using password:YES) runtime error '02147467259' method 'refresh' of object 'IAdodc' failed what's problem ? WHAT I HAVE NEED TO CHANGE IN YOUR SERVER PROJECT.. URGENT... PLZ my mail id:[email protected]

Submitted by Anonymous (not verified) on Sat, 08/14/2010 - 22:19

Dear Sir, Can I have your sample project on GSM Modem/Phones as for reference. [email protected] Thank you in advance Cheers Larry

Submitted by Anonymous (not verified) on Sun, 08/15/2010 - 05:28

Hi I wonder if you could help please? I have downloaded your server.zip (Simple remote MySQL database in VB Application) I have changed the connectionString to point to MySQL database ang it connects OK. I have created a database with table - Users and Fields:- Location, Latitude, Longitude, Population, ZipCode and Area. When I run the VB code I get an Error:- [MySQL][ODBC 3.51 Driver][mysqld-5.0.51a-19~bpo40+1]Unknown column 'id' in 'order clause' I do not know what this means, I would be thankful for any help. Brian

Add new comment

About text formats