Hello there
I use an ADODB connection Through MySQL 5.0; the provider is ODBC. My problem is setting a SQL querie to a variable (vb6). For example, here is my vb/SQL querie.
VB Code:
  1. rs.Open "SELECT username, password FROM tehtable WHERE username='" & Text1.Text & "' AND password ='" & Text2.Text & "'", conn
i want to do
VB Code:
  1. return = rs.Open("SELECT username, password FROM tehtable WHERE username='" & Text1.Text & "' AND password ='" & Text2.Text & "'", conn)
but that returns errors as it says it expects a function on ".Open"
if any of you could help that would be great