Re: connecting VB to postgreSQL

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.

*doesnt work either..OLE-DB error persists. thanks for the readmefile.
*
On Wed, Apr 9, 2008 at 8:04 PM, Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
wrote:

> 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
>