Connecting to MySQL ODBC 3.51 with VB

  • 13 years ago
    Can someone please help me with the debugging of my code?
    I'm using VB for my codes, MySQL database and ODBC connector.
    Theres no error when run, but the system failed to establish a connection to the database records.
    What's wrong with my code?
    Plzz help. Thank you.

    <%@Import Namespace="System.Data" %>
    <%@Import Namespace="System.Data.SqlTypes" %>
    <%@Import Namespace="" %>
    <%@Import Namespace="System.Web.Util" %>
    <%@Import Namespace="System.Data" %>
    <%@Import Namespace="System.Data.Odbc" %>

    Dim myString As String = "Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=slim;uid=root;pwd=fyp;option=3"
             Dim myConnection As OdbcConnection = New OdbcConnection(myString)
             Dim myCommand As OdbcCommand = New OdbcCommand("SELECT Name, Member_ID, Password FROM Member", myConnection)
             Dim myDataReader As OdbcDataReader
             myCommand.Connection = myConnection
             myDataReader = myCommand.ExecuteReader()

Post a reply

No one has replied yet! Why not be the first?

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


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!

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.

“PHP is a minor evil perpetrated and created by incompetent amateurs, whereas Perl is a great and insidious evil perpetrated by skilled but perverted professionals.” - Jon Ribbens