Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    Canada
    Posts
    10

    Unanswered: MySQL update query using ODBC

    Hi,

    I am trying to execute an Update SQL Statement but i am facing problem. I am not sure what it is for. l am using MySQL and and trying to execute that query using VB.
    I am trying to update some data in MySQL table but if i include more than 2 parameters in WHERE condition it fails and pops up an error "ODBC Does not support requested properties"

    But i was using same query with 3 parameters in WHERE conditon in Access and SQL Server Databases and i never faced this problem.

    Any help would be appericiated.

    Thanks
    Thanks in advance
    Devinder

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    hmm, let me check my crystal ball to see your actual query

    aha, here it is

    your gafloozle column is not initialized, and your left join is missing!!!
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jul 2001
    Location
    NC
    Posts
    102
    I haven't encountered any such problems when using VB6 frontends to create, display and update mySQL tables. Unfortunately, you didn't indicate which ODBC driver you are using, if the DB is ISAM or INNODB, or what the failing query and parameters were.

    When I last worked with mySQL, I used v3.23.51, myODBC v3.51 driver, VB6 ADO and ADOX 2.5 objects on Win 98/NT systems. The majority of the WHERE statements had less than 5 AND and OR elements, but some of these are made up of multiple ANDs and ORs, up to a maximum of 15 elements.

    Since my applications had to run with Oracle, mySQL and MSAccess backends, they generated SQL statements by appending common-language portions of the SQL command (such as select on) to auto-selected DB-unique elements (such as concatanation and date/time).

    I suggest you check the query using your mySQL DB, not MSAccess or MSDE. Use mySQLfront or some other excellent tool available on the internet. It sounds like the parameter is incorrectly formatted, or isn't allowed in mySQL.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •