Skip to Content.
Sympa Menu

freetds - RE: [freetds] FreeTDS 0.63 and OpenOffice

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] FreeTDS 0.63 and OpenOffice
  • Date: Thu, 12 Aug 2004 17:22:26 +0200

>
> "ZIGLIO, Frediano, VF-IT" wrote:
>
> > my .odbc.ini
> [...]
> > [local]
> > Driver =
> > /home/freddy/cpp/freetds/freetds63/src/odbc/.libs/libtdsodbc.so
> > Description = Test Server
> > Trace = Yes
> > Database = tempdb
> [...]
>
> This is the point: For ODBC access I usually tried a database
> (B) that's
> different from the users default database (A).
>
> As long as I set the user's default database (A) I'm able to see the
> tables in OOo's database table browser. If I set a different database
> (B) for ODBC - even though I can login to the server with 'sqsh' and
> browse the tables with 'sp__helptable' on this different
> database (B) -
> I don't get them listed in OOo .... Oh, no, even more: If I
> leave that
> different database (B) in the ODBC configuration and I change the
> default dabase of the user to this different database (B) as well, I
> still don't see the tables in OOo's table browser.
>
> The only thing that's currently obvious to me is that I am
> the owner of
> my previous default database (A) and I am not in the new one
> (B). Aside
> from that the previous one (A) was created as a copy of the different
> (B).
>
> Can anyone confirm ?
>

Well, ODBC use sp_tables to get table information. I don't know what
permission are required to execute this procedure...

freddy77




Archive powered by MHonArc 2.6.24.

Top of Page