>>>>> "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
