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
