Re: PostgreSQL / ODBC / Ms-SQL 2000

> -----Original Message-----
> From: Thomas Knoop [mailto:Th(dot)Knoop(at)Talisma(dot)nl]
> Sent: 27 September 2005 15:48
> To: Dave Page
> Subject: PostgreSQL / ODBC / Ms-SQL 2000
>
> Hi Dave,

Hi Thomas,

> With referral to this link:
> http://archives.postgresql.org/pgsql-odbc/2005-08/msg00077.php

Please use the mailing lists for support, not private email.

> We are trying to create a view to a linked server in MS-SQL
> and have the
> same problem, we use the 8.01.00.04 (16-09-2005) version of
> the ODBC driver.

That bug is fixed - the driver no longer incorrectly reports that we
support catalogs.

> When I look at the properties of the linked server in Ms-SQL
> I can see that
> the catalog column is empty. I think MS-SQL expects a
> (default?) value here,
> and thats why we cannot proceed creating a view.

If SQL is expecting a value here even though the driver reports that
catalogs are not supported by the database then it's broken. I'll see if
I can find some time to try to work out whats going on in the week. I
can't promise anything though.

Regards, Dave.