firebird-odbc-devel

[Firebird-odbc-devel] Using FB ODBC driver with MS Office applications

[Michael D. S. <sp...@pa...>]

I'm trying to use the FB ODBC driver (2.00.00.142) to connect 
MS Office applications to an existing FB2 database. I can 
create the DSN (and the Test Connection button says all 
is well) but when I try to actually use this connection, the 
Office app says "Unable to obtain list of tables from the data 
source".

Does anyone have any advice?

Michael D. Spence
Mockingbird Data Systems, Inc.

Re: [Firebird-odbc-devel] Using FB ODBC driver with MS Office applications

[bill l. <cbi...@gm...>]

Did you try setting characterset to utf8 or unicode_fss at driver dsn config screen?

Michael D. Spence wrote:
> I'm trying to use the FB ODBC driver (2.00.00.142) to connect 
> MS Office applications to an existing FB2 database. I can 
> create the DSN (and the Test Connection button says all 
> is well) but when I try to actually use this connection, the 
> Office app says "Unable to obtain list of tables from the data 
> source".
> 
> Does anyone have any advice?
> 
> Michael D. Spence
> Mockingbird Data Systems, Inc.
> 
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
> 


-- 
regards,
bill

Re: [Firebird-odbc-devel] Using FB ODBC driver with MSOffice applications

[Michael D. S. <sp...@pa...>]

> -----Original Message-----
> From: fir...@li... 
> [mailto:fir...@li...] On 
> Behalf Of bill lam
> Sent: Wednesday, March 21, 2007 11:18 AM
> To: fir...@li...
> Subject: Re: [Firebird-odbc-devel] Using FB ODBC driver with 
> MSOffice applications
> 
> Michael D. Spence wrote:
> > I'm trying to use the FB ODBC driver (2.00.00.142) to connect 
> > MS Office applications to an existing FB2 database. I can 
> > create the DSN (and the Test Connection button says all 
> > is well) but when I try to actually use this connection, the 
> > Office app says "Unable to obtain list of tables from the data 
> > source".
> > 
> > Does anyone have any advice?
> > 
> > Michael D. Spence
> > Mockingbird Data Systems, Inc.> 
> Did you try setting characterset to utf8 or unicode_fss at 
> driver dsn config screen?
> 

I tried both of those, plus ASCII and none of that worked.

What should the setting be for the pulldown that says
"Set null field SCHEMA", "Remove SCHEMA from SQL query",
"Use full SCHEMA"?  What does it do?

Re: [Firebird-odbc-devel] Using FB ODBC driver with MSOffice applications

[bill l. <cbi...@gm...>]

FB works fine for me, but I'm not familiar with calling FB from ms office. Could 
you give a simple test script to demostrate the problem?

Michael D. Spence wrote:
> 
>> -----Original Message-----
>> From: fir...@li... 
>> [mailto:fir...@li...] On 
>> Behalf Of bill lam
>> Sent: Wednesday, March 21, 2007 11:18 AM
>> To: fir...@li...
>> Subject: Re: [Firebird-odbc-devel] Using FB ODBC driver with 
>> MSOffice applications
>>
>> Michael D. Spence wrote:
>>> I'm trying to use the FB ODBC driver (2.00.00.142) to connect 
>>> MS Office applications to an existing FB2 database. I can 
>>> create the DSN (and the Test Connection button says all 
>>> is well) but when I try to actually use this connection, the 
>>> Office app says "Unable to obtain list of tables from the data 
>>> source".
>>>
>>> Does anyone have any advice?
>>>
>>> Michael D. Spence
>>> Mockingbird Data Systems, Inc.> 
>> Did you try setting characterset to utf8 or unicode_fss at 
>> driver dsn config screen?
>>
> 
> I tried both of those, plus ASCII and none of that worked.
> 
> What should the setting be for the pulldown that says
> "Set null field SCHEMA", "Remove SCHEMA from SQL query",
> "Use full SCHEMA"?  What does it do?
> 
> 
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
> 


-- 
regards,
bill

Re: [Firebird-odbc-devel] Using FB ODBC driverwith MSOffice applications

[Michael D. S. <sp...@pa...>]

There's no script involved.  Heres what I'm doing:

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

This brings up an Open dialog to select a DSN.  Click New
Source.  This brings up the Data Connection Wizard.  Select
ODBC DSN from the list and click Next.  The (System) DSN I
created is one of the choices.  Select it, click Next and
the error message appears.



> -----Original Message-----
> From: fir...@li...=20
> [mailto:fir...@li...] On=20
> Behalf Of bill lam
> Sent: Wednesday, March 21, 2007 11:59 AM
> To: fir...@li...
> Subject: Re: [Firebird-odbc-devel] Using FB ODBC driverwith=20
> MSOffice applications
>=20
>=20
> FB works fine for me, but I'm not familiar with calling FB=20
> from ms office. Could=20
> you give a simple test script to demostrate the problem?
>=20
> Michael D. Spence wrote:
> >=20
> >> -----Original Message-----
> >> From: fir...@li...=20
> >> [mailto:fir...@li...] On=20
> >> Behalf Of bill lam
> >> Sent: Wednesday, March 21, 2007 11:18 AM
> >> To: fir...@li...
> >> Subject: Re: [Firebird-odbc-devel] Using FB ODBC driver with=20
> >> MSOffice applications
> >>
> >> Michael D. Spence wrote:
> >>> I'm trying to use the FB ODBC driver (2.00.00.142) to connect=20
> >>> MS Office applications to an existing FB2 database. I can=20
> >>> create the DSN (and the Test Connection button says all=20
> >>> is well) but when I try to actually use this connection, the=20
> >>> Office app says "Unable to obtain list of tables from the data=20
> >>> source".
> >>>
> >>> Does anyone have any advice?
> >>>
> >>> Michael D. Spence
> >>> Mockingbird Data Systems, Inc.>=20
> >> Did you try setting characterset to utf8 or unicode_fss at=20
> >> driver dsn config screen?
> >>
> >=20
> > I tried both of those, plus ASCII and none of that worked.
> >=20
> > What should the setting be for the pulldown that says
> > "Set null field SCHEMA", "Remove SCHEMA from SQL query",
> > "Use full SCHEMA"?  What does it do?
> >=20
> >=20
> >=20
> >=20
> --------------------------------------------------------------
> -----------
> > Take Surveys. Earn Cash. Influence the Future of IT
> > Join SourceForge.net's Techsay panel and you'll get the=20
> chance to share your
> > opinions on IT & business topics through brief surveys-and earn cash
> >=20
> http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge
&CID=3DDEVDEV
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>=20


--=20
regards,
bill

-------------------------------------------------------------------------=

Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share =
your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDEV
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

Re: [Firebird-odbc-devel] Using FB ODBC driverwith MSOffice applications

[bill l. <cbi...@gm...>]

Michael D. Spence wrote:
> There's no script involved.  Heres what I'm doing:
> 
> Open Excel.  On the new spreadsheet, select 
> Data | Import External Data | Import Data.
> 
> This brings up an Open dialog to select a DSN.  Click New
> Source.  This brings up the Data Connection Wizard.  Select
> ODBC DSN from the list and click Next.  The (System) DSN I
> created is one of the choices.  Select it, click Next and
> the error message appears.

Thank you. I can also see the error now.  I guess this is a bug in ms excel. 
Whether it needs to workaround the bug is at Vladimir's decision.

-- 
regards,
bill

Re: [Firebird-odbc-devel] Using FBODBC driverwith MSOffice applications

[Michael D. S. <sp...@pa...>]

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.

> -----Original Message-----
> From: fir...@li... 
> [mailto:fir...@li...] On 
> Behalf Of bill lam
> Sent: Wednesday, March 21, 2007 12:23 PM
> To: fir...@li...
> Subject: Re: [Firebird-odbc-devel] Using FBODBC driverwith 
> MSOffice applications
> 
> 
> Michael D. Spence wrote:
> > There's no script involved.  Heres what I'm doing:
> > 
> > Open Excel.  On the new spreadsheet, select 
> > Data | Import External Data | Import Data.
> > 
> > This brings up an Open dialog to select a DSN.  Click New
> > Source.  This brings up the Data Connection Wizard.  Select
> > ODBC DSN from the list and click Next.  The (System) DSN I
> > created is one of the choices.  Select it, click Next and
> > the error message appears.
> 
> Thank you. I can also see the error now.  I guess this is a 
> bug in ms excel. 
> Whether it needs to workaround the bug is at Vladimir's decision.
> 
> -- 
> regards,
> bill
> 
> --------------------------------------------------------------
> -----------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the 
> chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge
&CID=DEVDEV
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

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

Re: [Firebird-odbc-devel] Using FB

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

Hi Bill,

>
> Thank you. I can also see the error now.  I guess this is a bug in ms
excel.

Thank you very much.
You have asked all that it was necessary!

--
Best regards,
Vladimir Tsvigun