 |  |  |  |  |  |  |  |
connect vb application to mysql database
Thread Solved |
•
•
Join Date: Apr 2008
Posts: 84
Reputation: 
Solved Threads: 0
Junior Poster in Training
hi
i need to connect a vb application to a mysql database which is in a remote server
plz suggest solutions
thank u very much
i need to connect a vb application to a mysql database which is in a remote server
plz suggest solutions
thank u very much
hope this qould help you...please see the attached file.
you need an installer ODBC driver. this app uses mysql
you need an installer ODBC driver. this app uses mysql
A conclusion is the place where you got tired of thinking. http://www.martin2k.co.uk/forums/index.php?showforum=4
http://www.a1vbcode.com/a1vbcode/vbforums/Forum3-1.aspx
http://www.developerfusion.co.uk/for...orum&ForumID=4
Hello
if you are not familier to connectivity then directly use the oledb provider
Steps to create the udl file
1. create the blank notepad file ( do not entere anything and save it with mycon.udl on desktop or any other location)
2. close the notepad editor . U will find some new icon to the file currently u created
3. Double click on the mycon.udl file it will display u the same wizard as you get in the adodc control
4. Click on provider tab
5.Select Microsoft OLEDB Provider for sql server
6. Click on the next button
7. Enter the servername on which the sql server is installed
8 specify the user name and password if the sql server administrator has given to u or bydefault user name is sa and password is blank
9 select the database name
10 Click on the test button
11 click on Ok button
12 Right click on the mycon.udl file and open it with notepad
13 u will find some thing is generated
14 copy the text from provider till end
15 paste it in the vb
eg
dim con as adodb.connection
private sub form_load
con.connectionstring=[paste the copied text from provider]
con.open
your connection is ready
hope this help u
if you are not familier to connectivity then directly use the oledb provider
Steps to create the udl file
1. create the blank notepad file ( do not entere anything and save it with mycon.udl on desktop or any other location)
2. close the notepad editor . U will find some new icon to the file currently u created
3. Double click on the mycon.udl file it will display u the same wizard as you get in the adodc control
4. Click on provider tab
5.Select Microsoft OLEDB Provider for sql server
6. Click on the next button
7. Enter the servername on which the sql server is installed
8 specify the user name and password if the sql server administrator has given to u or bydefault user name is sa and password is blank
9 select the database name
10 Click on the test button
11 click on Ok button
12 Right click on the mycon.udl file and open it with notepad
13 u will find some thing is generated
14 copy the text from provider till end
15 paste it in the vb
eg
dim con as adodb.connection
private sub form_load
con.connectionstring=[paste the copied text from provider]
con.open
your connection is ready
hope this help u
•
•
Join Date: Apr 2008
Posts: 84
Reputation:
Solved Threads: 0
Junior Poster in Training
thank u for ur suggessions
as im a new programmer it will be very difficut to me to understand
so plz explain in detail
i need to connect to mysql database not to sql
thank u very much
as im a new programmer it will be very difficut to me to understand
so plz explain in detail
i need to connect to mysql database not to sql
thank u very much
•
•
•
•
Originally Posted by nileshsarode 
Hello
if you are not familier to connectivity then directly use the oledb provider
Steps to create the udl file
1. create the blank notepad file ( do not entere anything and save it with mycon.udl on desktop or any other location)
2. close the notepad editor . U will find some new icon to the file currently u created
3. Double click on the mycon.udl file it will display u the same wizard as you get in the adodc control
4. Click on provider tab
5.Select Microsoft OLEDB Provider for sql server
6. Click on the next button
7. Enter the servername on which the sql server is installed
8 specify the user name and password if the sql server administrator has given to u or bydefault user name is sa and password is blank
9 select the database name
10 Click on the test button
11 click on Ok button
12 Right click on the mycon.udl file and open it with notepad
13 u will find some thing is generated
14 copy the text from provider till end
15 paste it in the vb
eg
dim con as adodb.connection
private sub form_load
con.connectionstring=[paste the copied text from provider]
con.open
your connection is ready
hope this help u
Thank you my friend.. you know this is my first time to participate in this type of forum..since i think all members are active..please do consider me as one of your students... i do hope to with my little knowledge i can help you soon.
i didnt open yet your sample but thanks...bro
i didnt open yet your sample but thanks...bro
Thank you my friend.. you know this is my first time to participate in this type of forum..since i think all members are active..please do consider me as one of your students... i do hope to with my little knowledge i can help you soon.
i didnt open yet your sample but thanks...bro
bro have you included the dbase and the password if ever there is?
i didnt open yet your sample but thanks...bro
bro have you included the dbase and the password if ever there is?
•
•
Join Date: Apr 2008
Posts: 84
Reputation:
Solved Threads: 0
Junior Poster in Training
•
•
•
•
Originally Posted by ramso
I design a vb code + froms then i fail to connect with mysql database
i know how to connect to the localhost
but when i tried to connect it to the remote server its not working and i finally found that
by default accessing mysql on the remote server is not allowed
we can change it but it was also not working
if u just want to know abt localhost may be i can help u
 |
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Need help improving this code,
- Next Thread: What Is Wrong With This Code!!!1 Can Any Body Help Me????
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
* 6 429 2007 access activex add age application basic beginner birth bmp calculator cd cells.find click client code college component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report save search sendbyte sites sort sql sql2008 sqlserver subroutine tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
