Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

sqlexpress database file auto-creation error, dbf2mysql parameter, WWWXXXAPC, wwwxxxAPC, How to unsubscrube from dategen spam, docmd.close 2585, WWWXXXDOCO, nu vot, dhcpd lease file "binding state", WWWXXXDOCO

Links

XODOX
Impressum

#1: ODBC doesn"t gets schemas

Posted on 2007-06-16 10:11:59 by El Cuy Volador

Dear all:

This is my first post. I am using Postgresql 8.2 and am triying to
connect from some apps (Codecharge Studio, Excel, OpenOffice Base, etc.)
to a database using a ODBC connection. The problem is that the tables do
not appear related to any schema (i.e. myschema.mytable). It just
retrieves only the plain table name (mytable) and in some cases it
appears only the tables from the public schema (for example in
OpenOffice Base). In the last case I have solved instaling an extension
in OpenOffice, but in the other applications it is necessary to
retrieve the schema name along with the table.

=BFIs there any configuration I am missing in the ODBC connection? or is =
a
features not implemented yet.

Thanks a lot and best regards,

Alvaro

Platform details: Windows XP SP1, Postgresql 8.2 with postgis extension.
ODBC connector: 8.02.04.00.



---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Report this message

#2: Re: ODBC doesn"t gets schemas

Posted on 2007-06-18 16:44:45 by Richard Broersma Jr

--- El Cuy Volador <cybercuy@gmail.com> wrote:

> The problem is that the tables do
> not appear related to any schema (i.e. myschema.mytable). It just
> retrieves only the plain table name (mytable) and in some cases it
> appears only the tables from the public schema (for example in
> OpenOffice Base).=20

I am not sure I completely understand your problem, but my experiece is =
that schema name are
recognized by the ODBC driver. However, in my case I use MS Access, when=
I use ODBC to link table
from the PostgreSQL server the resolved schema.table names in Access are =
"schema_table".

I am not sure what Open Office does in this regard.

Regards,
Richard Broersma Jr.

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

Report this message

#3: Re: ODBC doesn"t gets schemas

Posted on 2007-06-18 19:34:05 by Richard Wesley

--Apple-Mail-14--130101406
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
charset=US-ASCII;
delsp=yes;
format=flowed


On Jun 18, 2007, at 7:44 AM, Richard Broersma Jr wrote:

> I am not sure I completely understand your problem, but my
> experiece is that schema name are
> recognized by the ODBC driver. However, in my case I use MS
> Access, when I use ODBC to link table
> from the PostgreSQL server the resolved schema.table names in
> Access are "schema_table".

We use the OLE DB wrapper for ODBC to talk to the driver and it
appears to return both schema and table names. It doesn't set some
of the flags (e.g. system tables) but there must be some way to get
multi-part names back. MS SQL Server has hierarchical names and it
presumably works with Access...
________________________________________________________
Richard Wesley Senior Software Developer Tableau
Software
Visit: http://www.trytableau.com/now.html




--Apple-Mail-14--130101406
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
charset=ISO-8859-1

<HTML><BODY style=3D"word-wrap: break-word; -khtml-nbsp-mode: space; =
-khtml-line-break: after-white-space; "><BR><DIV><DIV>On Jun 18, 2007, =
at 7:44 AM, Richard Broersma Jr wrote:</DIV><BR =
class=3D"Apple-interchange-newline"><BLOCKQUOTE type=3D"cite"><DIV =
style=3D"margin-top: 0px; margin-right: 0px; margin-bottom: 0px; =
margin-left: 0px; "><FONT face=3D"Helvetica" size=3D"3" style=3D"font: =
12.0px Helvetica">I am not sure I completely understand your =
problem,<SPAN class=3D"Apple-converted-space">=A0 </SPAN>but my =
experiece is that schema name are</FONT></DIV><DIV style=3D"margin-top: =
0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><FONT =
face=3D"Helvetica" size=3D"3" style=3D"font: 12.0px =
Helvetica">recognized by the ODBC driver.<SPAN =
class=3D"Apple-converted-space">=A0 </SPAN>However, in my case I use MS =
Access, when I use ODBC to link table</FONT></DIV><DIV =
style=3D"margin-top: 0px; margin-right: 0px; margin-bottom: 0px; =
margin-left: 0px; "><FONT face=3D"Helvetica" size=3D"3" style=3D"font: =
12.0px Helvetica">from the PostgreSQL server the resolved schema.table =
names in Access are "schema_table".</FONT></DIV> =
</BLOCKQUOTE></DIV><DIV><BR class=3D"khtml-block-placeholder"></DIV>We =
use the OLE DB wrapper for ODBC to talk to the driver and it appears to =
return both schema and table names.=A0 It doesn't set some of the flags =
(e.g. system tables) but there must be some way to get multi-part names =
back.=A0 MS SQL Server has hierarchical names and it presumably works =
with Access...<BR><DIV> <SPAN class=3D"Apple-style-span" =
style=3D"border-collapse: separate; border-spacing: 0px 0px; color: =
rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: =
normal; font-variant: normal; font-weight: normal; letter-spacing: =
normal; line-height: normal; text-align: auto; =
-khtml-text-decorations-in-effect: none; text-indent: 0px; =
-apple-text-size-adjust: auto; text-transform: none; orphans: 2; =
white-space: normal; widows: 2; word-spacing: 0px; "><SPAN =
class=3D"Apple-style-span" style=3D"border-collapse: separate; =
border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Helvetica; =
font-size: 12px; font-style: normal; font-variant: normal; font-weight: =
normal; letter-spacing: normal; line-height: normal; text-align: auto; =
-khtml-text-decorations-in-effect: none; text-indent: 0px; =
-apple-text-size-adjust: auto; text-transform: none; orphans: 2; =
white-space: normal; widows: 2; word-spacing: 0px; "><SPAN =
class=3D"Apple-style-span" style=3D"border-collapse: separate; =
border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Helvetica; =
font-size: 12px; font-style: normal; font-variant: normal; font-weight: =
normal; letter-spacing: normal; line-height: normal; text-align: auto; =
-khtml-text-decorations-in-effect: none; text-indent: 0px; =
-apple-text-size-adjust: auto; text-transform: none; orphans: 2; =
white-space: normal; widows: 2; word-spacing: 0px; =
"><DIV>________________________________________________________</DIV><DIV>=
Richard Wesley   =A0      Senior=A0Software Developer  =A0=
        Tableau Software</DIV><DIV>Visit: <A =
href=3D"http://www.trytableau.com/now.html">http://www.tryta bleau.com/now.=
html</A></DIV><DIV><BR class=3D"khtml-block-placeholder"></DIV><BR =
class=3D"Apple-interchange-newline"></SPAN></SPAN></SPAN> =
</DIV><BR></BODY></HTML>=

--Apple-Mail-14--130101406--

Report this message