ODBC with Visio
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
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:
Show quoted text
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
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