Re: SQLConnect failure
| От | Erik Jones |
|---|---|
| Тема | Re: SQLConnect failure |
| Дата | |
| Msg-id | 1C72658A-6D55-4F55-9126-4D2BC5AB9F50@myemma.com обсуждение исходный текст |
| Ответ на | SQLConnect failure (greg@bryantrecording.com) |
| Список | pgsql-general |
On Apr 2, 2007, at 4:36 PM, greg@bryantrecording.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 alocal Postgres server works fine, but if we try to connect to a remotesystem, the SQLConnect fails, and we get an error code that seems toindicate "The value specified for the argument UserName or the valuespecified for the argument Authentication violated restrictions definedby the data source.".We can connect via pgadmin to the remote system, so we believe all thelittle .conf files should be correct, but can't get inprogrammatically. 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@myemma.com>
software developer
615-296-0838
emma(r)
В списке pgsql-general по дате отправления: