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 <[EMAIL PROTECTED]> 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 >