Re: Non-ANSI Informix databases and Intergraph + ODBC
->From: TMORGAN@soapfish.navsea.navy.mil (Thomas P. Morgan)
->Subject: Re: Non-ANSI Informix databases and Intergraph + ODBC
->Date: Wed, 8 Jun 1994 15:35:16
->Reply-To: TMORGAN@soapfish.navsea.navy.mil (Thomas P. Morgan)
->Organization: Naval Sea Systems Command
->
->As long as we're on the subject of ANSI mode databases - can one use a PC via
->VB (or Access) via ODBC and INET to communicate with a Informix ANSI mode
->database? I can access non-ANSI mode databases this way, but strange things
->happen when accessing an ANSI mode db: Not all tables appear in the list, and
->attaching tables in Access gets a "table not found" error. Is this just not
->supported? BTW - I'm accessing an Informix On-Line 5.0 w/INET 5.01 on the PC.
->
->TPM
->Thomas P. Morgan, Computer Aided Engineering Division | ____|~~|______
->Naval Sea Systems Command, Code 03R6 | \\____________/
->2531 Jefferson Davis Hwy, Arlington VA, 22242-5160 |^^^^^^^^^^^^^^^^^^^^
->Ph 703-602-2151 Ext 208 cc:Mail: MORGAN_TOM at 05_02, CAD 2: morgan_t@soapfish
You are not seeing all tables because some are owned by other users and must
be addressed as "owner.tablename". The alternative is to create synonyms:
CREATE SYNONYM tablename FOR owner.tablename;
Regards,
Alan ___________________________
______________________| R. Alan Popiel |__________________________
\\ Internet: | Martin Marietta, SLS | /
\\ alan@den.mmc.com | P.O. Box 179, M/S 3810 | Std disclaimers apply. /
)Voice: | Denver, CO 80201-0179 USA | (
/ 303-977-9998 |___________________________| (But you knew that!) \\
/________________________) (____________________________\\