Re: MSAccess hook to IDS 7.31.FD7

There can be problems with access to metadata in systables over ODBC. This was added to ODBC standard in version 3 what was later than Infromix version 7. You have unusually many tables. Do I understand that you have 20 thousand tables in one database? If you desperately need just to access some of these tables, you can use passthru queries from Access. I bet you can get all 20.000 of them with "select * from systables" given as passthru query. Maks. "NormaJean" <normajean.sebastian@tellabs.com> writes: > Hi, > I have 2 days of experience trying to hook MSAccess to IDS. > > I have been able to successfully connect MSAccess to my IDS 9.40.FC3XC. In > MsAccess, I can see what appears to be the entire list of tables in IDS > (20,000+) > However, using the same setup, to go after an IDS 7.31.FD7, I am only able > to see a partial list of tables in MsAccess. > > I'm not sure where to start, having so little experience with the ODBC > driver and hooking in MS stuff.... > > Informix Dynamic Server Version 7.31.FD7 > $ uname -a > HP-UX B.11.00 U 9000/889 1420652391 unlimited-user license> > IBM Informix Dynamic Server Version 9.40.FC3XC > uname -a > SunOS 5.9 Generic_117171-07 sun4u sparc SUNW,Sun-Fire-V240 > > is it a hardware difference? > is it a IDS difference? > > any advice? (i already know... avoid MS if possible, but i can't).... > > thanks, > Norma Jean

hi Maks, Thank you !!! the key was you dropping the hint about a passthru query. i looked at msaccess help.... and there it was.... yes, we really do have 20,000ish tables in both instances. one is a BAAN app and one is SAP... both huge creatures. >>I bet you can get all 20.000 of them with "select * from systables" given as passthru query. yup, worked like a charm. thanks! and i was able to do other specific SQL just as the passthru expains in the "RTFM"... thank you! NJ "Maks Romih" <maksr@snt.si> wrote in message news:u4qchrvf7.fsf@snt.si... > There can be problems with access to metadata in systables over > ODBC. This was added to ODBC standard in version 3 what was later than > Infromix version 7. You have unusually many tables. Do I understand > that you have 20 thousand tables in one database? > > If you desperately need just to access some of these tables, you can > use passthru queries from Access. I bet you can get all 20.000 of them > with "select * from systables" given as passthru query. > > Maks. >