RE: how connect visual basic to pgsql?

At 16:36 24/07/00 +0530, anuj wrote:
>
>>> This deriver made for Win95.
>>> I am using Win-Nt-Wks-4.0.
>>> Is this possible this due to different OS's ?
>>> Best Regard,
>>> Anuj
>
>>What kind of application do you use and where did you install your ODBC
>DSN?
>
>I don't know , Where I have installed but I am able to see 'OLE DB provider
>for ODBC driver' entry.

Where do you see this?

>>If your application is a service, or if you plan to share this DSN across
>>multiple users, you should install it under 'System DSN' entry.
>
>I make a 'System DSN' name pg.

And what did you set the port, server, dbname etc to?

>>This driver work perfectly on Windows NT 4.0 Server, Windows 2000
>>Professional and Windows 2000 Advanced Server. I used it to connect MS SQL
>>Server 7.0 to PostgreSQL database through 'OLE DB provider for ODBC driver'
>>and succeded in it. I did not test it on Windows NT Workstation 4.0, but I
>>see no reason why this driver shouldn't work on it.
>
>>Alex Bolenok.

Works for me on NT4 SP6.

>My connection string is :
>Provider=MSDASQL.1;Password=tempdb;Persist Security Info=True;User
>ID=postgres;Data Source=pg

So you are using an ADO data control for OLEDB, is that right?

>
>Postgres running on Linux RH-6.0 (HTTP,SAMBA services not working. Telnet
>and FTP working fine.).
>Other side I have VB-6.0 on Windows-NT-Workstations 4.0.
>
>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."

This looks like either (1) postgres is not running on the server - can you
do 'psql pg' (or whatever the db name in the DSN is). Or 2, you put the
wrong port in the DSN.

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