Обсуждение: RE: how connect visual basic to pgsql?
===== Original Message from pjw@rhyme.com.au (Philip Warner) at 7/22/00 6:45 am >At 10:32 22/07/00 +0530, anuj wrote: >> >>When I do connectivity then error come - "Provider cannot be found. It may >>not be properly installed." >> > >Looks like a Windows/VB/ODBC/OLEDB error message to me, but I could be >wrong. I've had that error every time I installed the Insight ODBC drivers for postgres. I never bothered researching it further since I got pgaccess working under windows, but it would be useful to know why many of us just can't point-and-click to success with it. Rob Nelson rdnelson@co.centre.pa.us
At 08:13 24/07/00 -0400, Robert D. Nelson wrote: >===== Original Message from pjw@rhyme.com.au (Philip Warner) at 7/22/00 6:45 >am >>At 10:32 22/07/00 +0530, anuj wrote: >>> >>>When I do connectivity then error come - "Provider cannot be found. It may >>>not be properly installed." >>> >> >>Looks like a Windows/VB/ODBC/OLEDB error message to me, but I could be >>wrong. > >I've had that error every time I installed the Insight ODBC drivers for >postgres. I never bothered researching it further since I got pgaccess >working under windows, but it would be useful to know why many of us just >can't point-and-click to success with it. I just upgraded to 6.5.0 (was on 6.4), with PG 7.0.2, and still don't get the error. I did not let it install the ODBC manager, if that is relevant. It *seems* fine. Without a lot more information, it would be impossible to track down (eg. when does the error appear, can you get to the data using a different product (eg. Excel/MSQuery), how have you set up the DSN, did you reboot 17 times after the install). You might also be want to post a message in a VB/ODBC newsgroup, since the message is almost certainly from VB or ODBC (or a layer above ODBC). ---------------------------------------------------------------- Philip Warner | __---_____ Albatross Consulting Pty. Ltd. |----/ - \ (A.C.N. 008 659 498) | /(@) ______---_ Tel: (+61) 0500 83 82 81 | _________ \ Fax: (+61) 0500 83 82 82 | ___________ | Http://www.rhyme.com.au | / \| | --________-- PGP key available upon request, | / and from pgp5.ai.mit.edu:11371 |/
>product (eg. Excel/MSQuery), how have you set up the DSN, did you reboot 17 >times after the install). Oh, that must be it! I only rebooted 16 times! ;) Rob Nelson rdnelson@co.centre.pa.us
-----Original Message----- From: Alex Bolenok [mailto:abolen@chat.ru] Sent: Monday, July 24, 2000 6:43 PM To: anuj Subject: Re: [GENERAL] how connect visual basic to pgsql? >>After reinstall the VB6.0 the error msg. has been changed. >>Now new error is : "could not connect to the server, could not connect to >>the remote socket." >>Now how to connect VB to pgsql. >>Regards, >>Anuj >Aha. The driver is now responding. Check out if postmaster is running and >lstening on the machine you are trying to connect to and if it does, the >connection should be made. >Alex Bolenok. Yes, Postmaster is running fine. $ psql tempdb ----- outout-- tempdb=> This command runing fine. And using libpq, I am able to use Postgres. What is remote socket error !! Regards, Anuj