Thread: Connect without queries?
Hi - I am attempting to connect to a Postgres-like database with PGODBC. The driver seems to be able to communicate with the server, but it complains that the pg_type table could not be found (hardly surprising - none of the PG metadata tables are there). Is there some way to just turn the driver into a data conduit? Just open a connection, make queries and get back data? TIA,
Richard Wesley wrote:
> Hi -
>
> I am attempting to connect to a Postgres-like database with PGODBC. The
> driver seems to be able to communicate with the server, but it complains
> that the pg_type table could not be found (hardly surprising - none of
> the PG metadata tables are there).
>
> Is there some way to just turn the driver into a data conduit? Just
> open a connection, make queries and get back data?
Not likely, PGODBC requires libpq which is going to at some level try to
communicate with the server beyond the protocol.
Joshua D. Drake
>
> TIA,
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
Joshua D. Drake wrote: > Richard Wesley wrote: >> Hi - >> >> I am attempting to connect to a Postgres-like database with PGODBC. The >> driver seems to be able to communicate with the server, but it complains >> that the pg_type table could not be found (hardly surprising - none of >> the PG metadata tables are there). >> >> Is there some way to just turn the driver into a data conduit? Just >> open a connection, make queries and get back data? > > Not likely, PGODBC requires libpq which is going to at some level try to > communicate with the server beyond the protocol. It doesn't require libpq, but it will still be looking for catalogues. I'm interested to know what a 'postgres-like' database is though - especially one that doesn't have any catalogues. /D
Dave Page wrote:
> Joshua D. Drake wrote:
>> Richard Wesley wrote:
>>> Hi -
>>>
>>> I am attempting to connect to a Postgres-like database with PGODBC. The
>>> driver seems to be able to communicate with the server, but it complains
>>> that the pg_type table could not be found (hardly surprising - none of
>>> the PG metadata tables are there).
>>>
>>> Is there some way to just turn the driver into a data conduit? Just
>>> open a connection, make queries and get back data?
>> Not likely, PGODBC requires libpq which is going to at some level try to
>> communicate with the server beyond the protocol.
>
> It doesn't require libpq, but it will still be looking for catalogues.
Oh did you guys go back to the protocol speak in the current version?
Sincerely,
Joshua D. Drake
>
> I'm interested to know what a 'postgres-like' database is though -
> especially one that doesn't have any catalogues.
>
> /D
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
Joshua D. Drake wrote: > Dave Page wrote: >> Joshua D. Drake wrote: >>> Richard Wesley wrote: >>>> Hi - >>>> >>>> I am attempting to connect to a Postgres-like database with PGODBC. The >>>> driver seems to be able to communicate with the server, but it complains >>>> that the pg_type table could not be found (hardly surprising - none of >>>> the PG metadata tables are there). >>>> >>>> Is there some way to just turn the driver into a data conduit? Just >>>> open a connection, make queries and get back data? >>> Not likely, PGODBC requires libpq which is going to at some level try to >>> communicate with the server beyond the protocol. >> It doesn't require libpq, but it will still be looking for catalogues. > > Oh did you guys go back to the protocol speak in the current version? Yes, we support v3.0 natively now, but can dynamically load libpq for connection setup if the user wants to use, <cough>pgpass</cough>, Kerberos or SSL. Regards, Dave.