List:MySQL ODBC« Previous MessageNext Message »
From:Daniel D. Reid Date:July 30 1999 9:49pm
Subject:RE: Access 2000 vs. Access'97 with MyODBC
View as plain text  
Monty,

I was able to resolve my problem from input I received from the list.  It
turns out that Access needs to see a primary index field and a timestamp
field.  Once I went back in and added the timestamp field, everything worked
fine.  Thanks for responding though.

Dan Reid
MIS Technical Administrator
Pilot Catastrophe Services, Inc.
v: (334) 607-7747
f: (334) 607-9039
http://www.pilotcat.com

> -----Original Message-----
> From: Michael Widenius [mailto:monty@stripped]
> Sent: Friday, July 30, 1999 12:34 PM
> To: Daniel D. Reid
> Cc: myodbc@stripped
> Subject: Access 2000 vs. Access'97 with MyODBC
>
>
> >>>>> "Daniel" == Daniel D Reid <ddreid@stripped> writes:
>
> Daniel> Greetings,
> Daniel> I am trying to set up a MySQL database that will
> accept online job
> Daniel> applications via the web and then allow our HR
> department to view these apps
> Daniel> on their desktops via Access over a MyODBC link.  I
> have been able to
> Daniel> accomplish this with Access'97 but I am having great
> difficulty in getting
> Daniel> it to work under Access 2000 which my company is
> moving towards.  Are there
> Daniel> different config options for 2000 vs. '97?
>
> Daniel> As an example, I tried to export an identical native
> Access database from
> Daniel> both versions.  The '97 ver worked where the 2000 ver
> failed.  I got the
> Daniel> following error from Access 2000:
>
> Daniel> 	ODBC-call failed.
> Daniel> 	[Microsoft][ODBC Driver Manager]Information
> type out of range (#0)
>
> Daniel> After going through the MySQL log on our server
> (RedHat 5.2), I can see the
> Daniel> '97 queries that create the table and then fills it
> via multiple INSERT INTO
> Daniel> queries.  The 2000 create query however is malformed.
>  It has the 'CREATE
> Daniel> TABLE' syntax but no table name to create.  It also
> has after that the list
> Daniel> of field types but no names.
>
>
> Daniel> 990715  9:22:47     113 Query      CREATE TABLE

> varchar(50), varchar(50),
> Daniel> varc
> Daniel> har(50), varchar(25), varchar(2), varchar(10),
> varchar(11), varchar(25),
> Daniel> varchar
> Daniel> (25), varchar(25), varchar(50), tinyint, tinyint,
> varchar(40), varchar(2),
> Daniel> tinyi
> Daniel> nt, tinyint, varchar(40), varchar(2), tinyint,
> tinyint, varchar(40),
> Daniel> varchar(2),
> Daniel>  tinyint, tinyint, varchar(40), varchar(2),
> varchar(20), varchar(2),
> Daniel> varchar(10)
> Daniel> , varchar(20), varchar(20), varchar(2), varchar(10),
> varchar(20),
> Daniel> varchar(20), v
> Daniel> archar(2), varchar(10), varchar(20), varchar(20),
> varchar(2), varchar(10),
> Daniel> varch
> Daniel> ar(20), varchar(20), varchar(2), varchar(10),
> varchar(20), varchar(20),
> Daniel> varchar(
> Daniel> 2), varchar(10), varchar(20), text, text)
>
> Daniel> Any thoughts or suggestions?
>
> Daniel> Thanks in advance,
>
> Daniel> Dan Reid
> Daniel> MIS Technical Administrator
> Daniel> Pilot Catastrophe Services, Inc.
> Daniel> http://www.pilotcat.com
>
> Hi!
>
> Could you make a MyODBC log that shows what happens at the ODBC side?
>
> Regards,
> Monty
>

Thread
Access 2000 vs. Access'97 with MyODBCDaniel D. Reid15 Jul
  • Re: Access 2000 vs. Access'97 with MyODBCColin McKinnon15 Jul
    • RE: Access 2000 vs. Access'97 with MyODBCStephen Dahl15 Jul
      • RE: Access 2000 vs. Access'97 with MyODBCDan15 Jul
        • RE: Access 2000 vs. Access'97 with MyODBCJakub Linowski15 Jul
          • RE: Access 2000 vs. Access'97 with MyODBCDan17 Jul
    • RE: Access 2000 vs. Access'97 with MyODBCDaniel D. Reid15 Jul
      • RE: Access 2000 vs. Access'97 with MyODBCJakub Linowski15 Jul
  • Access 2000 vs. Access'97 with MyODBCMichael Widenius30 Jul
    • RE: Access 2000 vs. Access'97 with MyODBCDaniel D. Reid31 Jul
RE: Access 2000 vs. Access'97 with MyODBCDaniel D. Reid15 Jul
  • Re: Access 2000 vs. Access'97 with MyODBCPatrick Sherrill15 Jul
    • RE: Access 2000 vs. Access'97 with MyODBCDaniel D. Reid15 Jul
      • RE: Access 2000 vs. Access'97 with MyODBCPaul DuBois17 Jul