Simple remote MySQL database in VB Application

Language

 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.

Comments

Submitted byAnonymous (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 byAnonymous (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 byAnonymous (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 byAnonymous (not verified)on Thu, 07/16/2009 - 18:09

Think about the refresh the table after the search. Regards.
Submitted byemondon Thu, 07/16/2009 - 22:07

In reply to by Anonymous (not verified)

it's just a sample for database connection, not for searching data purpose..
Submitted byAnonymous (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 byAnonymous (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 byAnonymous (not verified)on Tue, 07/28/2009 - 12:12

Can anyone recreate this in VB 2008? Thanks
Submitted byadminon Wed, 07/29/2009 - 17:18

In reply to by Anonymous (not verified)

Wait for my code in the next coming day.
Submitted byAnonymous (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 byashwaon 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 byAnonymous (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 byAnonymous (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 byLocustv2on 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 byAnonymous (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 byAnonymous (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 byAnonymous (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 byAnonymous (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 byAnonymous (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 byAnonymous (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 byAnonymous (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 byAnonymous (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 byAnonymous (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 byAnonymous (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