problem Mysql 5.0.77

2010-04-01
2013-04-09
  • tallara Ramon
    tallara Ramon
    2010-04-01

    I'm using this component for consultations, the problem I have is as follows:

    I have the same Mysql database on a server and also have another on my computer (localhost) the two database are the same version 5.0.77 and if I connect to the web bd read me perfectly but if I connect to the local gives me this error:

    MySQLDriverCS Exception: MySQLDriverCS Exception: MySQLDriverCS Error: wrong query.You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near

    Anybody know if my Mysql (localhost) needs to be set differently to let me do the consultation?

    In both Bd is the same. which changes only the server is dire, pass,
    this is what I do

    Dim f() As String = {"id", "I", "II", "III", "IV", "V", "VI", "VII", "VIII", "IX", "X", "XI", "XII", "XIII", "XIV", "XV", "XVI", "XVII", "XVIII", "XIX", "XX", "XXI", "XXII", "XXIII", "XXIV", "XXV", "XXVI", "XXVII", "XXVIII"}
                    Dim t() As String = {mesleer}
                    Dim dt As DataTable = New MySQLSelectCommand(DBCon, f, t, Nothing, Nothing, Nothing).Table
    

    Gracias
    Un Saludo