0

hi to all the experts here, i am facing a minor problem.....
i ady established the connection from VB6 via ODBC to MySQL and all the data needed has been passed to MySQL perfectly. But then how do i actualli retrieve the date from MySQL and show in VB 6.0? (I didnt use any id, instead i just want to get all of 'em) I am using ADODB.Connection and the command shown below:

strConnect = "dsn=xxxx"
    Set connPM = New ADODB.Connection
    connPM.CursorLocation = adUseClient
    connPM.Open strConnect
    Set rs = New ADODB.Recordset
    rs.CursorType = adOpenStatic
    rs.CursorLocation = adUseClient
    rs.LockType = adLockPessimistic
    
    rs.Source = "Select Whofirst,Player, Date, Status, Level, End_Time fromyyyy"
    rs.ActiveConnection = connPM
    rs.Open
3
Contributors
2
Replies
4
Views
9 Years
Discussion Span
Last Post by debasisdas
0

Put a bracket on Date.

'easier way to open a recordset 
rs.Open "Select Whofirst,Player, [Date], Status, Level, End_Time from yyyy", YourConnection, , adOpenDynamic, adLockPessimistic
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.