[freetds] FreeTDS 0.63 and OpenOffice
ZIGLIO, Frediano, VF-IT
Frediano.Ziglio at vodafone.com
Thu Aug 12 11:22:26 EDT 2004
>
> "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
More information about the FreeTDS
mailing list