Re: SQLConnect failure

In response to greg(at)bryantrecording(dot)com:

> We have code that has been using MSDE/SQL Server successfully for years,
> and are adding Postgres support. Doing a SQLConnect to connect to a
> local Postgres server works fine, but if we try to connect to a remote
> system, the SQLConnect fails, and we get an error code that seems to
> indicate "The value specified for the argument UserName or the value
> specified for the argument Authentication violated restrictions defined
> by the data source.".
>
> We can connect via pgadmin to the remote system, so we believe all the
> little .conf files should be correct, but can't get in
> programmatically. Any pointers on where to look?

The logs on the PostgreSQL server would be a good place to start.

This sounds suspiciously like a pg_hba.conf misconfig. You might want
to verify its correctness.

--
Bill Moran
http://www.potentialtech.com