Simple remote MySQL database in VB Application

Submitted by: 
Language: 
Visitors have accessed this post 82351 times.

 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

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

Hi BEnchamgel,

Anu ung IBM server mo AS400?

emond sabiniano
Project Contractor-Developer/Software Consultant

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]

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.

masterbench

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]

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..

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

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?

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

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????????

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.

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

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

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

Hi Fiona,

You can contact me @ [email protected] for the solutions.

Thank You

Best Regards,

emond sabiniano
Project Contractor-Developer/Software Consultant

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

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

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

You can use Server-Drive Mapping

emond sabiniano
Project Contractor-Developer/Software Consultant

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

thanks & regards

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

hi,

inserting into database field?

emond sabiniano
Project Contractor-Developer/Software Consultant

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
[email protected] g mail.com

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

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]

1)Make sure firewall is Off
2)Check IP, Username and Password are correct
2)Use correct Connection strings

emond sabiniano
Project Contractor-Developer/Software Consultant

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

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.

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

you can check this linK..hope it can helps!!!

http://www.connectionstrings.com/sql-server-2008

emond sabiniano
Project Contractor-Developer/Software Consultant

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

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

How I can access a Microsoft access database remotely using VB.net windows form.

Sir,
I also have problem to connect remote database from vb.net. please send me one example to my email address. [email protected]

microsoft access is not a server database..it is a file database..

it is possible to access remotely in your NETWORK using drive mapping..

if you want to access it via internet you can use PUSH and PULL method.

hope it will help you

emond sabiniano
Project Contractor-Developer/Software Consultant

Sir,
I also have problem to connect remote database from vb.net. please send me one example to my email [email protected]

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

it because you dont have an id in your fields.

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

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]

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]

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.

Does this solved the problem of maXimum concurrent connections

which there are no problem in connecting a VB application from many clients?...

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.

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...

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

use Telnet, SSL, proxy server,

or just contact me @

[email protected]
09212279363

emond sabiniano
Project Contractor-Developer/Software Consultant

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...

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?

Pages

Add new comment

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • You may insert videos with [video:URL]
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <th> <img> <h1> <h2> <h3> <iframe> [video]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.