Search
Language: Visual Basic
11922 reads
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?
http://emondsoft.qapacity.com/
Pm or email me
dark_raditz@0825yahoo.com
09212279363
Download Code
Your Vote!
Note
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.
- 11922 reads
MS SQL server connectivity
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
Remote access of microsoft access database...
How I can access a Microsoft access database remotely using VB.net windows form.
microsoft access is not a
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
Web/System developer-IT Consultant
MySQL - Server.zip
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
send SMS via VB6
Dear Sir,
Can I have your sample project on GSM Modem/Phones as for reference.
csgwong328@yahoo.com.hk
Thank you in advance
Cheers
Larry
server ms access database connection "server project" in vb6
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:parimal_vimal@yahoo.co.in
sir i want to connect remote database (mysql) via vb6
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 yogipatil1@rediffmail.com
ssh, telnet, proxy firewall and server
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...
Question about the code.
Does this solved the problem of maXimum concurrent connections
which there are no problem in connecting a VB application from many clients?...
How to access sql database in other PC
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.
remote mysql connection
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...
HELP ~~~
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
use Telnet, SSL, proxy server,
or just contact me @
dark_raditz0825@yahoo.com
09212279363
emond sabiniano
Web/System developer-IT Consultant
ODBC Connectivity
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.
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?
give me ur email add and i
give me ur email add and i will send you the sample in .zip format.
emond sabiniano
Web/System developer-IT Consultant
i watched the server.zip and
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?
Remote MySQL Access
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
Need Help
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!
incompatibility with VB 2008
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!
ashwa
Reading SMS from Globe Broadband
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
Hi
Can anyone help me how to send an SMS via VB6..
thanks a lot..
re: Reading SMS from Globe Broadband
I think emond can help you on this matter.
VB2008
Can anyone recreate this in VB 2008? Thanks
re: VB2008
Wait for my code in the next coming day.
Thanks
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
steffenrneess@hotmail.com
bind a picture in vb6
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 savagedragon_24@yahoo.com.ph
thanks in advance
Nice code
Think about the refresh the table after the search.
Regards.
it just a sample for
it's just a sample for database connection, not for searching data purpose..
emond sabiniano
Web/System developer-IT Consultant
How can i send SMS using VB
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
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
emond sabiniano
Web/System developer-IT Consultant
SMS through VB6.0 from access database
Hi Emond,
How are you?
I'm trying to send SMS through vb6.0 from mdb file. Please help in scritping this program.
Thanks a lot.
Sri
+91 9900518451
Hello Do you know how to send
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
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
emond sabiniano
Web/System developer-IT Consultant
SMS
hi sir,
Please send the sample code for SMS and MMS for this id rjpm.karthi.it@gmail.com
need sample code for mms gateway
can you help me to send sample code for mms gateway
my email: johns_dui@yahoo.com, thanks
thanks for sharing all of
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!
SMS server
hi edmond,
it'll be great if you can send the sample in .net its a great service you'll be doing. thanks Ayush
ayush_agarwal@msn.com
MMS ,SMS
from where country u are?
please PM me for your request
dark_raditz0825@yahoo.com
emond sabiniano
Web/System developer-IT Consultant
indonesia
i'm from indonesia
sorry for late reply.. Please
sorry for late reply..
Please email me.. i will create a sample in VB 2008..
tnx for your interest..
dark_raditz0825@yahoo.com
www.emondsoft.qapacity.com
emond sabiniano
Web/System developer-IT Consultant
I am looking for this kind of
I am looking for this kind of project. Thank you very much for the code.
ur Welcome
ur welcome..U can freely modify or improved the sample..
for your questions and request tutorials
email me
cheers!
emond sabiniano
Web/System developer-IT Consultant
Post new comment