Re: [GENERAL] connecting VB to postgreSQL

2008-04-10 Thread Abhishek MANDHANA
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

[GENERAL] connecting VB to postgreSQL

2008-04-09 Thread leoabhi
Hello, I wish to connect Visual Studio 2008(VB) to PostgreSQL.. I used the following help file to do it .. http://support.microsoft.com/?scid=kb%3Ben-us%3B316649x=12y=14 Unfortunately, it does not connect..although when you test connection, using test connection switch, VB displays test

Re: [GENERAL] connecting VB to postgreSQL

2008-04-09 Thread leoabhi
Hi Richard, is it possible to check them individually how ? 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

Re: [GENERAL] connecting VB to postgreSQL

2008-04-09 Thread Richard Huxton
leoabhi wrote: The error in English means Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. Well, did you check each OLE DB status value? Which failed and what was it doing? Are there any errors logged at the server? Did you turn

Re: [GENERAL] connecting VB to postgreSQL

2008-04-09 Thread Richard Huxton
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

Re: [GENERAL] connecting VB to postgreSQL

2008-04-09 Thread leoabhi
Hello, In brief. TASK : Write a code in VB so that i can connect to postgreSQL and then execute some stataments from my VB application. I didnt want to code it ..I found the other way round very similar but without coding. Visual basic has a server explorer .. which can be used to connect to

Re: [GENERAL] connecting VB to postgreSQL

2008-04-09 Thread Craig Ringer
leoabhi wrote: now my first 2 posts speak about this setup and problem/error i had while setting up connection..it gives OLE-DB error which we already spoke about..STILL UNRESOLVED. All goes around setup required to connect to postgreSQL using VB ,Server Explorer. I need the settings to be

Re: [GENERAL] connecting VB to postgreSQL

2008-04-09 Thread Abhishek MANDHANA
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? Abhi On Wed, Apr 9, 2008 at 7:39 PM, Craig Ringer [EMAIL PROTECTED] wrote: leoabhi wrote: now my

Re: [GENERAL] connecting VB to postgreSQL

2008-04-09 Thread Craig Ringer
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

Re: [GENERAL] connecting VB to postgreSQL

2008-04-09 Thread Francisco Figueiredo Jr.
On Wed, Apr 9, 2008 at 7:20 AM, leoabhi [EMAIL PROTECTED] wrote: Hello, Hello Abhi! I wish to connect Visual Studio 2008(VB) to PostgreSQL.. Have you tried Npgsql? http://www.npgsql.org http://project.npgsql.org http://documentation.npgsql.org I hope it helps. -- Regards,