Re: connecting VB to postgreSQL - Mailing list pgsql-general

From Richard Huxton
Subject Re: connecting VB to postgreSQL
Date
Msg-id 47FCD3E6.9000004@archonet.com
Whole thread Raw
In response to Re: connecting VB to postgreSQL  (leoabhi <abhishekrm@gmail.com>)
Responses Re: connecting VB to postgreSQL  (leoabhi <abhishekrm@gmail.com>)
List pgsql-general
leoabhi wrote:
> Hi Richard,
>
>     is it possible to check them individually how ?

No idea - you're one using .net - how would you normally check?

 > well..!! I think it has
> something to do with settings. couldnt even add a connection because once i
> click ok, it show the OLE-DB error, so no question about executing
> statements..
> In tried with mdb database it works.
>
> Found some more help.
> http://support.microsoft.com/?scid=kb%3Ben-us%3B269495&x=9&y=10
>
> Please see a snapshot of settings i could change .. The above help file also
> speaks about Connection string (FILENAME). Any idea how this setting is to
> be done if necessary for adding a postgresql connection.

No idea. You're still not telling us what the error message is when you
try to connect.

I don't use .net, but if you write code to connect to any database then
the connect method/function will return some sort of status code to
indicate success or failure. There will then be a way of getting a
precise error code and message.

I'm assuming you can connect from this machine using psql and/or
pgadmin, yes?

I'm assuming you've turned on connection logging at the server and have
checked to see what's happening there, yes?

What happened when you tried the example code in the driver's tutorial?

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Terry Lee Tucker
Date:
Subject: Disable Triggers
Next
From: "Peter Geoghegan"
Date:
Subject: Problem with windows Postgres 8.3.1 MSI binary distribution