Re: Database toolbox and MySQL

I'm actually having a similar problem, I can pull data just fine with 32bit versions of matlab but not the 64bit version... Here is what I've found so far...
With ODBC
I can run simple query's and get them 'at times' in the 64bit version( no cross joins)
I can usually get one line or a few lines, I get no error message
Sometimes changing the 'DataReturnFormat' to 'cellarray' instead of structure helps
On the 32bit version of matlab running on 64bit I get the whole table just fine every time

With JDBC
I get an error message when I try to do cross joins but I can retrieve the database with a simple query


.

Relevant Pages

  • Re: AutoExec Macro problem with ODBC connection failure
    ... If you structure the query as a simple Select Query based on the ODBC linked data, does the query datasheet show the expected data? ... I'm afraid I don't know anything about that error message or how to overcome it. ...
    (microsoft.public.access.macros)
  • Default odbc timeout for Access queries
    ... You can't believe how much grief this "ODBC call failed" has caused me. ... rather than every time a new query is run. ... timeout appears to be a OLE/DD timeout, which doesn't really seem to affect ... the appearance of the "odbc call failed" error message. ...
    (microsoft.public.access.queries)
  • Re: How to get the 0 counts in a group by ?
    ... as Tto the query seems a bit out of the blue: ... >attempts at CROSS JOINS, OUTER JOINS, etc. ... >w/o a cursor, but I just can't seem to go ...
    (microsoft.public.sqlserver.programming)
  • RE: ODBC Issue with Pivot Table
    ... I'm not sure about that error message and I'm not sure that all ODBC ... Click in the pivot table and then choose PivotTable, Pivot Table Wizard, ... query in Microsoft Query. ...
    (microsoft.public.excel.misc)
  • Cross Join problem
    ... This is the result of a query I have. ... there are no matching records in tbl_Salesdata for them? ... I have tried cross joins to no effect; I cannot then join in the Total so I ... end up with an identical total for Product 5, no matter which monthyear. ...
    (microsoft.public.sqlserver.programming)