Re: Informix SE, MS Access, ODBC

mlahiff@rose.hp.com (Lahiff_Martin) wrote: :Thanks for the previous help in getting the Intersolv ODBC driver :setup and working.... :I'm close, but not quite there. I can use MS Query and connect to :and query the database... works just fine. :In MS Access, to attach a table, the list of tables which comes back :from the database is in the format of owner.table. According to the :Informix documentation, you cannot specify a table name as :owner.table. :Is there anyway to turn off returning the owner name in the Intersolv :ODBC driver? I can't believe this happens (or creates a problem) in the :on-line version. In our case the name comes up as owner_table (a great difference from owner.table). I don't know if this can be turned off. Its probably someone at Microsoft that overread on the ANSI standard and wanted to make sure tablenames where unique in ODBC even if several users had created tables with the same name in the server database. A stupid idea, but... What we do is simply connect using the given name, and then rename the table within MS Access afterwards to the name without the owner prepended. In Visual Basic using ODBC we can use the tables directly without this strange naming convention in SQL statements. Nils.Myklebust@ccmail.telemax.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company