In response to [EMAIL PROTECTED]: > 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
