Improve company productivity with a Business Account.Sign Up

x
?
Solved

Whats the connection string between VB 6.0 and MySQL *Extremely urgent*

Posted on 2004-09-07
2
Medium Priority
?
795 Views
Last Modified: 2011-10-03
hi,

Whats the connection string between VB 6.0 and MySQL?
Its extremely urgent, hope u guys can help!!
0
Comment
Question by:TPoly
  • 2
2 Comments
 
LVL 26

Accepted Solution

by:
Umesh earned 2000 total points
ID: 11994566



ADO
When you are coding with the ADO API and Connector/ODBC you need to put attention in some default properties that aren't supported by the MySQL server. For example, using the CursorLocation Property as adUseServer will return for the RecordCount Property a result of -1. To have the right value, you need to set this property to adUseClient, like is showing in the VB code below: Dim myconn As New ADODB.Connection
Dim myrs As New Recordset
Dim mySQL As String
Dim myrows As Long

myconn.Open "DSN=MyODBCsample"
mySQL = "SELECT * from user"
myrs.Source = mySQL
Set myrs.ActiveConnection = myconn
myrs.CursorLocation = adUseClient
myrs.Open
myrows = myrs.RecordCount

more on this..

http://dev.mysql.com/doc/connector/odbc/en/manual.html

http://www.vbmysql.com/

http://dev.mysql.com/doc/connector/odbc/en/manual.html
0
 
LVL 26

Expert Comment

by:Umesh
ID: 11994589
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In this article, we’ll look at how to deploy ProxySQL.
In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

595 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question