From: | "Thomas Knoop" <Th(dot)Knoop(at)Talisma(dot)nl> |
---|---|
To: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: PostgreSQL / ODBC / Ms-SQL 2000 |
Date: | 2005-09-29 16:25:44 |
Message-ID: | 200509291625.j8TGPfg4094561@smtp-vbr10.xs4all.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
>>> SELECT * FROM OPENQUERY(MYLINKEDSERVER, 'SELECT * FROM
>>> public.mytable')
>> As far I can see this tries to open the table complete, and fails in
>> my case cause i have a ADSL connection and it tries to fetch all the
records....
> So modify the query as required...
> SELECT * FROM OPENQUERY(MYLINKEDSERVER, 'SELECT * FROM
> public.mytable WHERE foo < 10 LIMIT 5')
Well this does not work either, remember i'm creating a view....
Let me give some background: I'm using the PostgreSQL as a datasource from
an application that only connects to MS-SQL.
So either I create a view in MS-SQL or I talk to a linked server in MS-SQL
directly.
But both don't work in the current version.
- In the linked server setup i need to supply a catalog (of which the driver
does not seem to support)
- In the view it also complains about the catalog that is not supplied...
Would it be strange to suggest that we use a 'dummy' catalog in the ODBC
driver for MS-SQL?
Best Regards,
Thomas.
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2005-09-30 08:39:49 | Re: PostgreSQL / ODBC / Ms-SQL 2000 |
Previous Message | Dave Page | 2005-09-29 07:57:27 | Re: Problems with PsqlOdbc. |