Re: SQLConnect failure

In response to greg@bryantrecording.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