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