Bugs item #1000414, was opened at 2005-11-07 21:59
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000414&group_id=1000125
Category: None
Group: None
Status: Closed
Resolution: None
Priority: 3
Submitted By: Nobody (None)
Assigned to: Nobody (None)
Summary: file based dns does not connect
Initial Comment:
Hiho
I just tried the combination of
8.1.100 => 8.0.4debian
and
8.1.100 => 8.1win
Im unable to connect by mean of a file based dns entry.
I just get the error "could not connect to the server (#113)
Using the computer-dns with the same connection options works really well.
Unable to find a configuration fault. Also using pgadmin or jdbc3 as client works proper.
hth
Cybernd aka Neuhauser Bernhard
----------------------------------------------------------------------
Comment By: Nobody (None)
Date: 2006-06-14 07:49
Message:
I can't connect to the server even after creating the file dsn and adding the password field. Once i execute the table
amexporting the table disappears with no message.
----------------------------------------------------------------------
Comment By: Nobody (None)
Date: 2005-12-14 16:11
Message:
1. Create a file DSN with all the data for the connection.
2. Locate the file, normally it will be stored in C:\Program Files\Common Files\ODBC\Data Sources
3. Edit the file with any text editor.
4. Add a last line to the file containing the password:
PASSWORD=[password]
EXAMPLE: Imagine the password is 123456789, then the line to add to the DSN file would be
PASSWORD=123456789
Hope it will work for you.
----------------------------------------------------------------------
Comment By: Dave Page (dpage)
Date: 2005-11-24 14:24
Message:
This occurs when the File DSN is being created, if it cannot be verified. Elements of the connect string are generated
onlyafter the connection has been made, so if you don't fully connect, only the 'Driver={PostgreSQL xxx}' section is
writtento the file DSN.
To create usable DSNs, when prompted to enter the server details, make sure that all details required to connect are
enteredand that the server is configured to allow the incoming connection. The file DSN will then be saved with all
requiredparameters *except* the password.
----------------------------------------------------------------------
Comment By: Nobody (None)
Date: 2005-11-15 11:43
Message:
Just tried the 8.1.101 odbc driver.
The error message changed to "fe_sendauth: no password supplied (#113)"
Still it works proper with user/system based dns. File based DNS seem to fail (Access 2003 used as Client)
hth
Neuhauser Bernhard
----------------------------------------------------------------------
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000414&group_id=1000125