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 more help. http://support.microsoft.com/?scid=kb%3Ben-us%3B269495&x=9&y=10 Please see a snapshot of settings i could change .. The above help file also speaks about Connection string (FILENAME). Any idea how this setting is to be done if necessary for adding a postgresql connection. Please reply. Thanks abhi http://www.nabble.com/file/p16584555/settings_VB.bmp settings_VB.bmp leoabhi wrote: > > 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%3B316649&x=12&y=14 > > Unfortunately, it does not connect..although when you test connection, > using test connection switch, VB displays test connection successful. The > error which i get is included in Snapshot . > > The error in English means > "Multiple-step OLE DB operation generated errors. > Check each OLE DB status value, if available. No work was done." > > Please see enclosed snapsots.. > http://www.nabble.com/file/p16583837/Vb_error1.bmp Vb_error1.bmp > > any help/suggestion would be great or else any other suggestion/program to > connect VB to postgreSQL > http://www.nabble.com/file/p16583837/VB_Error.bmp VB_Error.bmp > > Thanks > Abhi > > -- View this message in context: http://www.nabble.com/connecting-VB-to-postgreSQL-tp16583837p16584555.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.