Re: ODBC with Visio

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