Professional Web Applications Themes

Access does not like Mysql - MySQL

I am having a problem creating Access tables linked to a Mysql database. I get the widow to select a Data Source, click on the (system) DSN I created (and tested ok), and click ok. The Database Source selection window disappears, but no window showing the Mysql tables ever appears nor does any kind of error message (typical Microsoft.) I can read the Mysql table using ODBC from a Python program, so Mysql and ODBC seem to be working, looks like Access is the one refusing to cooperate. Also, Access seems ed up after this, often dieing with an access ...

  1. #1

    Default Access does not like Mysql

    I am having a problem creating Access tables linked to a
    Mysql database. I get the widow to select a Data Source,
    click on the (system) DSN I created (and tested ok), and
    click ok. The Database Source selection window disappears,
    but no window showing the Mysql tables ever appears nor
    does any kind of error message (typical Microsoft.)
    I can read the Mysql table using ODBC from a Python
    program, so Mysql and ODBC seem to be working, looks
    like Access is the one refusing to cooperate. Also, Access
    seems ed up after this, often dieing with an access
    violation later on.

    Any sugesstion about how to trouble shoot this? I generated
    a odbc trace file, but I don't recognise anything in there as
    being a blatant error.

    Windows-2000-sp2 / Access-2000-sp3 / Mysql-5.0 /
    mysql-connector-odbc-3.51.12

    Stuart McGraw Guest

  2. #2

    Default Re: Access does not like Mysql

    I've connected to MySQL from Access 97 successfully. Usually what happens
    after selecting the DSN is you are prompted for login information. I would
    suggest upgrading your Windows 2000 to SP4 - I seem to recall there was an
    issue with the MyODBC connector that required SP4.

    "Stuart McGraw" <smcg4191zzfriizz.RimoovAllZZs.com> wrote in message
    news:117nkj86403corp.supernews.com...
    > I am having a problem creating Access tables linked to a
    > Mysql database. I get the widow to select a Data Source,
    > click on the (system) DSN I created (and tested ok), and
    > click ok. The Database Source selection window disappears,
    > but no window showing the Mysql tables ever appears nor
    > does any kind of error message (typical Microsoft.)
    > I can read the Mysql table using ODBC from a Python
    > program, so Mysql and ODBC seem to be working, looks
    > like Access is the one refusing to cooperate. Also, Access
    > seems ed up after this, often dieing with an access
    > violation later on.
    >
    > Any sugesstion about how to trouble shoot this? I generated
    > a odbc trace file, but I don't recognise anything in there as
    > being a blatant error.
    >
    > Windows-2000-sp2 / Access-2000-sp3 / Mysql-5.0 /
    > mysql-connector-odbc-3.51.12
    >

    Ron Hinds Guest

  3. #3

    Default Re: Access does not like Mysql

    Sorry, the "sp2" was a brain-. I am at sp4.

    I looked again more carefully at the ODBC trace log. Just before
    it checks for MSysConf, there is a BADMEM error. Is this significant?
    I doubt it because the log continues with a lot more normal
    looking stuff before it finally ends. But I have no idea what it
    is saying, so maybe someone can interpret this?

    --snip--
    db1 270-5a4 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
    HDBC 096B15E8
    UWORD 1 <SQL_ACTIVE_STATEMENTS>
    PTR 0x0012C738 (0)
    SWORD 2
    SWORD * 0x0012C71E (2)

    db1 270-5a4 ENTER SQLAllocStmt
    HDBC 096B15E8
    HSTMT * 0012C2FC

    db1 270-5a4 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
    HDBC 096B15E8
    HSTMT * 0x0012C2FC ( 0x096b18c0)

    db1 270-5a4 ENTER SQLGetStmtOption
    HSTMT 096B18C0
    UWORD 0
    PTR 0x0012C2A8

    db1 270-5a4 EXIT SQLGetStmtOption with return code 0 (SQL_SUCCESS)
    HSTMT 096B18C0
    UWORD 0
    PTR 0x0012C2A8

    db1 270-5a4 ENTER SQLSetStmtOption
    HSTMT 096B18C0
    UWORD 0 <SQL_QUERY_TIMEOUT>
    SQLPOINTER 0x0000003C

    db1 270-5a4 EXIT SQLSetStmtOption with return code 0 (SQL_SUCCESS)
    HSTMT 096B18C0
    UWORD 0 <SQL_QUERY_TIMEOUT>
    SQLPOINTER 0x0000003C (BADMEM)

    db1 270-5a4 ENTER SQLExecDirectW
    HSTMT 096B18C0
    WCHAR * 0x1B074AA0 [ -3] "SELECT Config, nValue FROM MSysConf\ 0"
    SDWORD -3

    db1 270-5a4 EXIT SQLExecDirectW with return code -1 (SQL_ERROR)
    HSTMT 096B18C0
    WCHAR * 0x1B074AA0 [ -3] "SELECT Config, nValue FROM MSysConf\ 0"
    SDWORD -3

    DIAG [S0002] [MySQL][ODBC 3.51 Driver][mysqld-5.0.16-nt]Table 'jdb.msysconf' doesn't exist (1146)
    --snip--

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~

    The log ends with:

    --snip--
    db1 270-5a4 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
    HDBC 096B15E8
    UWORD 24 <SQL_CURSOR_ROLLBACK_BEHAVIOR>
    PTR 0x0012C842 (2)
    SWORD 2
    SWORD * 0x0012C814 (2)

    db1 270-5a4 ENTER SQLGetInfoW
    HDBC 096B15E8
    UWORD 29 <SQL_IDENTIFIER_QUOTE_CHAR>
    PTR 0x0012C82C
    SWORD 20
    SWORD * 0x0012C854

    db1 270-5a4 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
    HDBC 096B15E8
    UWORD 29 <SQL_IDENTIFIER_QUOTE_CHAR>
    PTR 0x0012C82C [ 2] "`"
    SWORD 20
    SWORD * 0x0012C854 (2)

    Is this a normal ending?
    Does any of this give any information about what Access is up to?



    "Ron Hinds" <__ron__dontspammewedontlikespam_garageiq.com> wrote in message news:uV7iQw29FHA.3608TK2MSFTNGP09.phx.gbl...
    > I've connected to MySQL from Access 97 successfully. Usually what happens
    > after selecting the DSN is you are prompted for login information. I would
    > suggest upgrading your Windows 2000 to SP4 - I seem to recall there was an
    > issue with the MyODBC connector that required SP4.
    >
    > "Stuart McGraw" <smcg4191zzfriizz.RimoovAllZZs.com> wrote in message
    > news:117nkj86403corp.supernews.com...
    > > I am having a problem creating Access tables linked to a
    > > Mysql database. I get the widow to select a Data Source,
    > > click on the (system) DSN I created (and tested ok), and
    > > click ok. The Database Source selection window disappears,
    > > but no window showing the Mysql tables ever appears nor
    > > does any kind of error message (typical Microsoft.)
    > > I can read the Mysql table using ODBC from a Python
    > > program, so Mysql and ODBC seem to be working, looks
    > > like Access is the one refusing to cooperate. Also, Access
    > > seems ed up after this, often dieing with an access
    > > violation later on.
    > >
    > > Any sugesstion about how to trouble shoot this? I generated
    > > a odbc trace file, but I don't recognise anything in there as
    > > being a blatant error.
    > >
    > > Windows-2000-sp2 / Access-2000-sp3 / Mysql-5.0 /
    > > mysql-connector-odbc-3.51.12

    Stuart McGraw Guest

  4. #4

    Default Re: Access does not like Mysql


    Ahh, that's where you're going wrong; the spouse has to be live for this to
    work.

    --
    Terry Kreft

    "Stuart McGraw" <smcg4191zzfriizz.RimoovAllZZs.com> wrote in message
    news:117nkj86403corp.supernews.com...
    >I am having a problem creating Access tables linked to a
    > Mysql database. I get the widow to select a Data Source,
    <SNIP>


    Terry Kreft Guest

Similar Threads

  1. MS Access vs MySQL
    By xcoldnet in forum Dreamweaver AppDev
    Replies: 3
    Last Post: February 24th, 07:13 PM
  2. Access to mySQL db
    By IPT in forum ASP Database
    Replies: 3
    Last Post: June 22nd, 05:39 AM
  3. MySQL to Access!
    By janet in forum ASP Database
    Replies: 1
    Last Post: August 28th, 02:08 AM
  4. ms access to MYSQL
    By manjunatha in forum ASP Database
    Replies: 1
    Last Post: July 22nd, 10:00 PM
  5. MySQL vs. Access
    By Jordan Marton in forum Macromedia Dreamweaver
    Replies: 5
    Last Post: July 16th, 10:00 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139