Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forum Replies Created

Viewing 15 posts - 46 through 60 (of 60 total)
1 2 3 4
  • Author
    Posts
  • June 8, 2007 at 4:34 am in reply to: Ms Access Not Importing #24179
    maxhugen
    Participant

    Well, made some progress… sort of.

    I've been using a file DSN for both MySQL, and the Access db I was trying to import. Found I couldn't link MySQL tables to Access using a file DSN, it seems to connect AOK, but the list of tables in Access's Link dialog was empty. I then tried a User DSN, and this worked.

    So I tried this to import the Access tables. Created a User DSN for the Access db, and retried the import into MySQL. After selecting “Import tables…”, SQLyog threw an error on every table:

    [Microsoft][ODBC Microsoft Access Driver] Query support unavailable.

    After the errors had finished, the list of tables was displayed and I continued, but I found that it imported only the table definitions, without any data.

    Can anyone suggest the cause of this problem?

    MTIA

    June 7, 2007 at 12:29 pm in reply to: Ms Access Not Importing #24178
    maxhugen
    Participant

    I've tried searching Microsoft's downloads and MSDN areas, can't find anywhere to download a later version of the Access ODBC driver. How frustrating!

    June 7, 2007 at 11:17 am in reply to: Ms Access Not Importing #24176
    maxhugen
    Participant

    Just for a laugh, do you think I could try your copy of the Access ODBC driver? It's the file ODBCJT32.DLL.

    I don't know if some dll registration issue would stop me from backing up my copy, and trying yours. But hey, it would be worth a try…

    June 7, 2007 at 11:02 am in reply to: Ms Access Not Importing #24175
    maxhugen
    Participant

    Hmmm… mine is version 4.00.6200.00

    Yours looks quite a bit later, mine is dated 2003.

    June 7, 2007 at 10:36 am in reply to: Ms Access Not Importing #24173
    maxhugen
    Participant

    Thanks Adarsh

    Whilst I'm not really sure of what i'm looking for, I noticed your log had a different SELECT in it:

    “select `TradeID`,`Trade` FROM `Trades` “

    Mine has:

    “select * from `Trades` where 1=0”

    I'm struggling to figure out the seeming differences between the ODBC outputs. Somehow I feel its got to be the Access driver I'm using. Sigh…

    June 7, 2007 at 9:43 am in reply to: Ms Access Not Importing #24171
    maxhugen
    Participant

    Just had a thought… would you be able to turn on ODBC Trace, do that import to MySQL again, and attach the log for me? Maybe I can spot a difference between my log and yours?

    June 7, 2007 at 9:40 am in reply to: Ms Access Not Importing #24170
    maxhugen
    Participant

    Sorry, didn't see your reply…

    I'm using the root user with all privileges for testing, which was created when I installed MySQL. Checked it, looks OK.

    June 7, 2007 at 8:04 am in reply to: Ms Access Not Importing #24168
    maxhugen
    Participant

    Tried Access import from Access via ODBC…. Access won't allow import, linking etc to other Access sources via ODBC.

    Haven't anything outside of MS progs that I could use to try try the Access ODBC driver. Still, it 'looks' like that part is working…

    June 7, 2007 at 7:55 am in reply to: Ms Access Not Importing #24167
    maxhugen
    Participant
    peterlaursen wrote on Jun 7 2007, 05:15 PM:
    I think that SJA cannot access the .mdb file and that is why SJA will have to abort the job.

    It seems that the SJA is accessing the .mdb OK, as it displays the available tables etc. So that rules out permission based problems (I think), and problems with access to the file (in use, etc).

    The ODBC trace log shows that SQLyog is running, and that it looks like it is working (success messages). Not that I'd actually know though!

    So *if* we assume that SQLyog got as far as running ODBC calls *OK*, what happens next that could fail?

    June 7, 2007 at 7:40 am in reply to: Ms Access Not Importing #24165
    maxhugen
    Participant

    Peter, your cute little graphic gives me hope. 🙂

    I did try this in the opposite direction, exporting from Access 97 to MySQL (via an ODBC dsn). This worked OK.

    Could there be a prob with the Microsoft Access driver I'm using? It's version 4.00.6200.00 dated 20 May 03.

    Cheers, Max

    June 7, 2007 at 7:32 am in reply to: Ms Access Not Importing #24164
    maxhugen
    Participant

    I've tried moving the db to 'My Documents', changed the DSN, and tried again but still no joy.

    Using W2000

    June 7, 2007 at 7:11 am in reply to: Ms Access Not Importing #24160
    maxhugen
    Participant

    No, they are always closed.

    June 7, 2007 at 7:10 am in reply to: Ms Access Not Importing #24159
    maxhugen
    Participant

    Tried changing the table type from InnoDb to MyIsam. Same failure.

    Turned on the ODBC trace, and had a squizz at the log, but I don't know what to make of it. One thing that caught my eye though, was the string “select * from `Trades` where 1=0”. Doesn't look right to me…. I didn't add a WHERE to SQLyog, and “where 1=0” looks pretty strange.

    Just in case the log file might help, I've attached it.

    MTIA

    June 7, 2007 at 6:43 am in reply to: Ms Access Not Importing #24157
    maxhugen
    Participant

    The 6.02 RC version throws the same error.

    In case it's of interest, the Access .ldb file is still 'in use' after the error. Have to close SQLyog to release the lock.

    I've attached the Access db, it's a test with just one table in it.

    June 7, 2007 at 6:19 am in reply to: Ms Access Not Importing #24156
    maxhugen
    Participant

    I bought the Enterprise version today, especially for the import and other extra features. It is version 6.01. How would I get the version you mention?

    Oops, sorry, should have followed your link first. Have downloaded 6.02RC, will try.

    Cheers, Max

  • Author
    Posts
Viewing 15 posts - 46 through 60 (of 60 total)
1 2 3 4