Re: [Firebird-odbc-devel] Using

[Vladimir T. <pr...@hm...>]

Hi Michael,

> > > Open Excel.  On the new spreadsheet, select
> > > Data | Import External Data | Import Data.

Thanks! It's bug.
However concerning it it is possible long to argue.

Excel query Catalogs :
SQLTables(hstmt2, "%", 0, NULL, 0, NULL, SQL_NTS, NULL, 0);
==========
Arguments

  CatalogName
  [Input]
  Catalog name. The CatalogName argument accepts search patterns if the
SQL_ODBC_VERSION environment attribute is SQL_OV_ODBC3; it does not accept
search patterns if SQL_OV_ODBC2 is set. If a driver supports catalogs for
some tables but not for others, such as when a driver retrieves data from
different DBMSs, an empty string ("") denotes those tables that do not have
catalogs.
===================
Firebird do not supports catalogs. And Firebird ODBC return empty string
("").
For this reason you see a mistake.
However we also can a little change behaviour Firebird ODBC.
 And return one string ("MYNAMEDSN").
 I have checked up in this case all works as you expect.
It is all will be is added in the following build.

> Ah.  Well, it behaves the same way in MS Word and Access so
> I guess it's a problem for MS Office 2002 in general.

   Not all so is bad! :-)

1) Create file to
C:\Program Files\Common Files\ODBC\Data Sources\Test.dsn
and add
[ODBC]
DSN=TEST

please repeat
> > > Open Excel.  On the new spreadsheet, select
> > > Data | Import External Data | Import Data.

And select Test.dsn not create new


2) > > > Data | Import External Data | Create query
select DSN and ?

--
Best regards,
Vladimir Tsvigun