Thread: ODBC with Visio

ODBC with Visio

From
Steven Saner
Date:
I am trying to get Visio (5.5 Enterprise) on Win98/NT to talk with
Postgres 7.0.2 on Linux 2.2.16 via the Win32 driver from Insight
Distributions. The problem that I am having is that I get parse errors
on all queries to the database. The reason is the rather "odd" way in
which fields are specified in the query. In the psqlodbc log file I
see things like:

SELECT username.tablename.fieldname FROM username.tablename ...

Where the username is the username that I connect to the database
with, and tablename and fieldname are obvious. That generates a parse
error from Postgres.

Is this simply an issue with Visio or is there something going on
with the driver or configuration that I am not finding? Regardless the
cause, does anyone know how to fix it?

Thanks

Steve


Re: ODBC with Visio

From
Gilles DAROLD
Date:
Hi,

This syntax is also available with Oracle regarding user grants on
tables. I have made a program who can parse Pg and Oracle
database so I have met this problem. Fortunally I have the source
code so I simply hack the code :-) I don't know about Visio but seeing
the operating system you probably do not have open source.

I don't think PostgreSQL can handle this syntax but it will be a great
feature to uniformize my perl source code :-) even if it does nothing.

Regards

Gilles DAROLD

Steven Saner wrote:

> I am trying to get Visio (5.5 Enterprise) on Win98/NT to talk with
> Postgres 7.0.2 on Linux 2.2.16 via the Win32 driver from Insight
> Distributions. The problem that I am having is that I get parse errors
> on all queries to the database. The reason is the rather "odd" way in
> which fields are specified in the query. In the psqlodbc log file I
> see things like:
>
> SELECT username.tablename.fieldname FROM username.tablename ...
>
> Where the username is the username that I connect to the database
> with, and tablename and fieldname are obvious. That generates a parse
> error from Postgres.
>
> Is this simply an issue with Visio or is there something going on
> with the driver or configuration that I am not finding? Regardless the
> cause, does anyone know how to fix it?
>
> Thanks
>
> Steve


Re: ODBC with Visio

From
Tom Lane
Date:
Steven Saner <ssaner@pantheranet.com> writes:
> I am trying to get Visio (5.5 Enterprise) on Win98/NT to talk with
> Postgres 7.0.2 on Linux 2.2.16 via the Win32 driver from Insight
> Distributions. The problem that I am having is that I get parse errors
> on all queries to the database. The reason is the rather "odd" way in
> which fields are specified in the query. In the psqlodbc log file I
> see things like:

> SELECT username.tablename.fieldname FROM username.tablename ...

> Where the username is the username that I connect to the database
> with, and tablename and fieldname are obvious. That generates a parse
> error from Postgres.

It looks like Visio (or maybe just Insight's driver) expects the
username to equate to a schema within the database.  We don't support
schemas yet, so I'm afraid you're stuck if you can't turn that off.

A hardwired assumption that user == schema seems pretty broken to me,
so with luck you will find there is a knob somewhere that you can
twiddle to affect this.

            regards, tom lane