Re: ODBC Problem - Mailing list pgsql-odbc

From Anoop Kumar
Subject Re: ODBC Problem
Date
Msg-id B4AF8C04F762D246A1E38EC5DFAEFC0B0379C4@blrmail2.aus.pervasive.com
Whole thread Raw
In response to ODBC Problem  (Ankur kashyap <kashyap_ankur@yahoo.com>)
List pgsql-odbc
Hi Ankur,

Are you accessing the PostgreSQL server from the same machine, or your
VB program is running on another machine? If your client is in another
machine you might need to get it authenticated by creating an entry in
PG_HBA.CONF. The problem does not look like it's related to PG_HBA.CONF
because PgAdmin III is working properly.

BTW, did you use the windows installer? If possible provide the code
where exactly you are getting the error. Also check whether the ODBC
driver was installed properly, and check the ADO connection String.

Regards

Anoop

> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-
> owner@postgresql.org] On Behalf Of Ankur kashyap
> Sent: Thursday, August 11, 2005 3:40 PM
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] ODBC Problem
>
> Hi,
>
> I am very new to PostgreSQL. I have Downloaded the
> version 8.0.3 and have been trying to connect database
> from one of my visual basic application.
>
> The installation was successful and pgADMIN is working
> fine. So, I created the 32-bit System DSN and each
> time I try to connect to database, ADO fails, and I
> get an error message, error occured while driver
> initialization.
>
> Can you please suggest some solutions? Do I need to
> make any change in pg_hba.conf file?
>
> Hoping to get a response.
>
> Regards,
> Ankur Kashyap
>
>
>
> ____________________________________________________
> Start your day with Yahoo! - make it your home page
> http://www.yahoo.com/r/hs
>
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match

pgsql-odbc by date:

Previous
From: "Dave Page"
Date:
Subject: Re: ODBC driver: Rows Affected
Next
From: "Dave Page"
Date:
Subject: Re: changed behavior in libpq odbc driver