List:MySQL ODBC« Previous MessageNext Message »
From:Daniel D. Reid Date:July 15 1999 2:53pm
Subject:Access 2000 vs. Access'97 with MyODBC
View as plain text  
Greetings,

I am trying to set up a MySQL database that will accept online job
applications via the web and then allow our HR department to view these apps
on their desktops via Access over a MyODBC link.  I have been able to
accomplish this with Access'97 but I am having great difficulty in getting
it to work under Access 2000 which my company is moving towards.  Are there
different config options for 2000 vs. '97?

As an example, I tried to export an identical native Access database from
both versions.  The '97 ver worked where the 2000 ver failed.  I got the
following error from Access 2000:

	ODBC-call failed.
	[Microsoft][ODBC Driver Manager]Information type out of range (#0)

After going through the MySQL log on our server (RedHat 5.2), I can see the
'97 queries that create the table and then fills it via multiple INSERT INTO
queries.  The 2000 create query however is malformed.  It has the 'CREATE
TABLE' syntax but no table name to create.  It also has after that the list
of field types but no names.


990715  9:22:47     113 Query      CREATE TABLE ( varchar(50), varchar(50),
varc
har(50), varchar(25), varchar(2), varchar(10), varchar(11), varchar(25),
varchar
(25), varchar(25), varchar(50), tinyint, tinyint, varchar(40), varchar(2),
tinyi
nt, tinyint, varchar(40), varchar(2), tinyint, tinyint, varchar(40),
varchar(2),
 tinyint, tinyint, varchar(40), varchar(2), varchar(20), varchar(2),
varchar(10)
, varchar(20), varchar(20), varchar(2), varchar(10), varchar(20),
varchar(20), v
archar(2), varchar(10), varchar(20), varchar(20), varchar(2), varchar(10),
varch
ar(20), varchar(20), varchar(2), varchar(10), varchar(20), varchar(20),
varchar(
2), varchar(10), varchar(20), text, text)

Any thoughts or suggestions?

Thanks in advance,

Dan Reid
MIS Technical Administrator
Pilot Catastrophe Services, Inc.
http://www.pilotcat.com

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