Member Avatar for evios

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
  • 103 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for cometburn

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
Member Avatar for debasisdas

Are you facing any problem with your code ?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.