> -------- Original Message -------- > Subject: Re: [GENERAL] SQLConnect failure > From: Bill Moran <[EMAIL PROTECTED]> > Date: Mon, April 02, 2007 2:54 pm > To: [EMAIL PROTECTED] > Cc: pgsql-general@postgresql.org > > 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. >
Thanks guys. I can connect to the remote server via pgadmin on a different machine, so I'm pretty sure that the .conf files are correct (that took awhile, but there are very good diagnostic messages when they are wrong). When I set the hba, the encryption is set to MD5 - does that need to be set somewhere on the client side? ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
