Re: connecting VB to postgreSQL

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