Re: connecting VB to postgreSQL

Abhishek MANDHANA wrote:

Did 30 seconds search worked ? for me its didnt ?

Please just dont test the connection, the applet shows Connection successful
, Are you able to create it  and see it under Server Explorer?
 

I mostly use Linux. I'm on Vista right now, but I have never used Visual Basic and have none of the tools for it.  I have Visual Studio for C++ installed, but not for Visual Basic .NET. So I can't test it, and I'm afraid I'm not going to install VB.net to test it. As such, I'm working from information available on the 'net, such as the PostgreSQL OLE DB provider documentation (which, by the way, is hard to find - I landed up digging it out of ViewCVS). You, however, will have a copy of the file that came with your copy of the OLE DB provider.

This is the README file. I strongly suggest having a look:
  http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/oledb/oledb/README?rev=1.7&content-type=text/x-cvsweb-markup

In any case, it's obvious in your screenshot that you left the "server" and "location" fields blank in the connection setup form. This is most likely the cause of your problem. Try putting "localhost" in the "server" box, and the name of your database in the "location" box. If you have not created a database yet, you will need to do so. See the PostgreSQL documentation on how to do that.

As for the error message, it basically means "oops, it didn't work and I don't know why". The PostgreSQL OLE DB provider README explains how to get more detailed error information.

--
Craig Ringer