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, 10/22/2011 - 06:29

it because you dont have an id in your fields.

Submitted by Anonymous (not verified) on Fri, 09/03/2010 - 10:46

Please send us the connectivity code for MS sql server using VB6 remotely. we have server at Atlanda can i connect from india using remotely and VB6 code. i will update the data from india to atlanta server. Any one help me. Thanks in advance Pandi Rajan

Submitted by Anonymous (not verified) on Mon, 11/08/2010 - 17:19

hello, can you create another one for dao. I am not quite familiar with adodb... please...

Submitted by Anonymous (not verified) on Thu, 11/25/2010 - 09:31

How can i be able to connect to my database in sql management server2008 from vb(visual studio 2010)?

Submitted by Anonymous (not verified) on Thu, 01/06/2011 - 15:56

Please any one help for this.Because i m using well connected structure. problem occur when i m using the connection in timer control after some time.It show's "cannot connect mysql with localhost 10048". why? i am not understanding.Any one help me for this.

Submitted by Anonymous (not verified) on Sat, 01/29/2011 - 17:06

hello sir can you help me with codes of adding image from picture box in vb6 to Mysql database. thank you

Submitted by Anonymous (not verified) on Thu, 02/03/2011 - 04:27

Sir, i can't connect to remote mysql database using vb 6.0. every time i run the program it will prompt error : [Mysql] [ODBC 3.51 Driver] Host "(my computer ip)" is not allowed to connect this mysql server. can you give me the solution plz... here is my email id : [email protected]

Submitted by Anonymous (not verified) on Mon, 05/09/2011 - 11:35

i have a program in which i cant connect to a server of my database in other pc.. it just returns a error msg of Cant get hostname for your address.... what should i do... [email protected] +639056962564

Submitted by Anonymous (not verified) on Wed, 06/08/2011 - 16:47

Sir I'm trying to create a program that will be used by school in exam times,the program should send files to server shared folder without students knowledge where is it exactly going. please send me source codes to saintpremath@ g mail.com

Submitted by Anonymous (not verified) on Sat, 06/11/2011 - 18:09

Sir, I have a problem in writing a code for inserting an image into vb.Please tell me how to do write it.

Submitted by Anonymous (not verified) on Tue, 08/02/2011 - 15:24

i will build a GPS Tracking Server, how to listener data of gps tracker with C# or VB thanks & regards

Submitted by Anonymous (not verified) on Tue, 08/16/2011 - 13:49

sir can i ask you something about connection of vb6 in mysql. am .. how to access mysql using vb6 in another computer?

Submitted by Anonymous (not verified) on Wed, 08/17/2011 - 18:19

Hi there, I was wondering if you could send me your VB code. I am trying to connect to a remote Mysql db from an access db and update infomration in 1 table (to be published on a website). Am not very good at this and am finding difficulty in writing the code for it. Thanks, Fiona

please sir, i have a program in vb 2010 and i want to connect to sql database in another pc with the same program but could not succeed. please i need your help

Submitted by Anonymous (not verified) on Fri, 09/02/2011 - 16:52

Hello sir,. this one was a great help for me. i have a project that need remote connection to msql server. I need this msql driver so i can test and apply this code for my project. Thanks sir,. Great idea! Bench

Submitted by Anonymous (not verified) on Wed, 09/07/2011 - 20:46

HI I've a doubt in connecting mysql database with VB6.0

Submitted by Anonymous (not verified) on Sat, 10/22/2011 - 06:34

it is a very nice example. i just read the codes then got the important parts. thank you very much. maybe just an update, the freesql.org as i am writing this now, is i think currently having problems because i cant connect to their phpmyadmin.

Submitted by Anonymous (not verified) on Wed, 11/02/2011 - 19:46

hey siir !!!!!!!how can i connect my vb 6 program to my sql server 6.0 and what are the steps?? show me sir the details????????

Submitted by Anonymous (not verified) on Sun, 11/27/2011 - 23:04

pls. help to create enrollment system using visual basic DAO 6.0 and ms access thanks pls do help me thanks

Submitted by Glenmar (not verified) on Thu, 12/15/2011 - 00:24

Hi, is any one can help me to find code for a system that ca send and reply a sms through usb modem using php?

Submitted by Davyth (not verified) on Sun, 01/01/2012 - 18:12

I would be glad if you could help me some code to connect MySql Database which is on ODBC platform.......I will be using the data in the Database to plot graphs on an Mschart....Thus I have to declare some variable...etc.Dim Con As New ADODB.Connection ' Connection Dim Rss As New ADODB.Recordset ' Recordset...am ok with Access but finding difficult with Mysql... i want a code equivalent to this..Con.Open "Provider = Microsoft.jet.OLEDB.4.0; Data Source =" & App.Path & "\Statistics.Mdb" ' Making Connection to with the Database

Submitted by dominique (not verified) on Thu, 01/12/2012 - 10:49

hi plz help me i can't connect to my web database server...i am using vb6 and i want to connect it to my database in my hosting datbase...plz help me..

Submitted by MIchael (not verified) on Sat, 01/14/2012 - 00:00

Hello sir, i would be glad if you can help me on a code about using the txt message received from globe broadband to my vb application.. how can i make the txt msg somewhat be store in a variable as a string. i hope you will send me some sample codes... [email protected]

Submitted by BenchDaddy on Sat, 04/28/2012 - 14:11

I can't wait that post.. That's what i need. Because i develop VB to SERVER IBM X3400 for local area only. What i need is u can use anyplace you want using ISP to connect to my server.

Submitted by Naitesh on Mon, 05/14/2012 - 14:12

Hello sir, my name is naitesh patel, i make vb6 project for hospital and backend ms access. there is two branches of hospital.i want to connect ehch other database on line via vb6. i m not getting proper remote connection string. so plz halp me. my email: [email protected]

Submitted by Benchangel (not verified) on Sat, 05/26/2012 - 11:54

Sir Emond, nagawa mo na ba ang project VB6 to IBM Server connectivit?. Inaabangn ko kc ito.. Thanks..

Add new comment

About text formats