List:MySQL ODBC« Previous MessageNext Message »
From:Michael Widenius Date:July 30 1999 5:33pm
Subject:Access 2000 vs. Access'97 with MyODBC
View as plain text  
>>>>> "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