Current location: Hot Scripts Forums » Programming Languages » Visual Basic » how to connect vb 6 with mysql


how to connect vb 6 with mysql

Reply
Page 2 of 2 1 2
 
LinkBack Thread Tools Display Modes
  #11 (permalink)  
Old 08-02-06, 09:39 PM
dzol dzol is offline
Newbie Coder
  
Join Date: Jul 2006
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Unhappy it still...
i'sorry, please anyone....
what ever i do and change, it's still error at
Code:
cnMySql.EstablishConnection
can u give me a solution. i don't know what to do
Reply With Quote
  #12 (permalink)  
Old 08-03-06, 04:56 PM
duesi's Avatar
duesi duesi is offline
Wannabe Coder
  
Join Date: Jun 2006
Posts: 225
Thanks: 0
Thanked 0 Times in 0 Posts
Did you check if you can connect to your database with other means (for example using Mysqlfront or something)?

I guess that your connection data (uid=root;pwd=1234;server=localhost;" & _
"driver={MySQL ODBC 3.51 Driver};database=kamus) is incorrect.
__________________
Duesi

"One of the great skills in using any language is knowing what not to use, what not to say" (Ron Jeffries)

http://www.swissbytes.de
Reply With Quote
  #13 (permalink)  
Old 09-02-06, 12:44 AM
kaustubh_luckyall kaustubh_luckyall is offline
New Member
  
Join Date: Sep 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
try this :

cnString = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=" & varmodserver & ";PORT=3306;" & _
"DATABASE=" & varmoddb & ";USER=" & varmodusr & ";PASSWORD=" & varmodpass & _
";OPTION=3;"
cn.Connect = cnString

cn.EstablishConnection
Reply With Quote
Reply
Page 2 of 2 1 2

Bookmarks

« Acessing VC DLL from VB6 | Form Display Problem »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
can't connect to MySQL all of a sudden, PHP My Admin still works nassau PHP 6 03-10-06 01:24 PM
Connect to MySQL and create variables ronlar ASP.NET 2 08-19-05 11:34 AM
PHP scripts unable to connect to DB after MySQL 4.1.10 upgrade Jason L PHP 3 03-08-05 12:32 AM
Vb -MySQl Performance Evaluation Feed Back. please! Romeo PHP 0 11-06-04 02:38 PM
Can't connect to mysql in include file when included in forums Forse PHP 2 07-12-04 07:39 PM


All times are GMT -5. The time now is 01:15 PM.
vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.