Back to discussion

mySQL & ADO

Last post was 11 Nov 2001 at 10:23
mysql , vb6 United States
  • 19 years ago

    I want to execute an SQL statement with VB ..
    I can connect and stuff .. but I don't know where I can enter fe. "SELECT * from table"
    I've search many sites about ADO and SQL .. but couldn't find an answer ..
    One site said I had to use control.execute .. but that doesn't work either :\


    Can anybody help ?

    Report abuse
  • 19 years ago

    What DB are you using? If it's mySQL, then it won't work.... (see here)
    otherwise, you can use
    objRS = objConn.Execute("the sql statement")
    once you have opened a connection for objConn (an ADO connection object)

    Report abuse
  • 19 years ago

    You can use mysql in VB .. I can connect and see the tables .. but when I type componen. usualy you get a list of things you can do .. but Execute is not there ..

    Report abuse

Post a reply

Enter your message below

Sign in or Join us (it's free).

MySQL forum discussion

MySQL tutorials

Quick links

Recent activity

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Web Development

Developer Jobs

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

Cancel
“Any fool can write code that a computer can understand. Good programmers write code that humans can understand.” - Martin Fowler