Re: SQLConnect failure

On Apr 2, 2007, at 4:36 PM, greg(at)bryantrecording(dot)com wrote:

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

Are the host your running your SQLConnect and the host pgadmin the
same? If not, you probably need to edit your pg_hba.conf file (in
your data directory) to allow connections from the host your code is
running on.

erik jones <erik(at)myemma(dot)com>
software developer
615-296-0838
emma(r)