Thread: Question about saving user name and password
Hello, I'm building an Access UI to work with a postgresql database. I'm using psqlodbc for the database connection. Every time I start the Access file to run the form, a pop-up window shows up to ask for username and password. Can we avoid the pop-up window by saving the username and password somewhere? Many thanks!
On 02/11/2009 20:59, Nim Li wrote: > I'm building an Access UI to work with a postgresql database. I'm using > psqlodbc for the database connection. > > Every time I start the Access file to run the form, a pop-up window > shows up to ask for username and password. > > Can we avoid the pop-up window by saving the username and password > somewhere? Hi there, I haven't used ODBC in a while, but I seem to remember that there were fields to enter the username & password in the DSN configuration dialogs.... have you tried that? HTH, Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie
On Mon, Nov 2, 2009 at 12:59 PM, Nim Li <nimli@sri.utoronto.ca> wrote: > Can we avoid the pop-up window by saving the username and password > somewhere? In Ms-Access when you link a table one of the settings is to store the username and password (in plain text) as part of the link definition. Also, for other good advice regarding ODBC and MS-Access the following link is a good resource: http://www.utteraccess.com/forums/showflat.php?&Board=53&Number=1843709&page=0&view=collapsed&sb=5&o=&fpart=1 -- Regards, Richard Broersma Jr. Visit the Los Angeles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug
Thank you for your quick reply. I don't see any place to specify "save username and password". When I run the form in Access file, the pop-up window shows: - Database - SSL Mode (which has only "disable" option) - Server - Port - User Name - Password - Connection (button; when I click on it, another window shows up but I don't see any options related to password) - Manage DSN (button; when I click on it, nothing pops up) Any idea what I should check next? Many thanks!! On 11/2/2009 4:03 PM, Raymond O'Donnell wrote: > On 02/11/2009 20:59, Nim Li wrote: > >> I'm building an Access UI to work with a postgresql database. I'm using >> psqlodbc for the database connection. >> >> Every time I start the Access file to run the form, a pop-up window >> shows up to ask for username and password. >> >> Can we avoid the pop-up window by saving the username and password >> somewhere? > > Hi there, > > I haven't used ODBC in a while, but I seem to remember that there were > fields to enter the username & password in the DSN configuration > dialogs.... have you tried that? > > HTH, > > Ray. >
On 02/11/2009 21:14, Nim Li wrote: > Thank you for your quick reply. > > I don't see any place to specify "save username and password". Well, I was thinking of where I create and/or edit the DSN: -> Start menu -> Administrative tools -> Data sources (ODBC) -> User DSN or System DSN etc -> Add (or "Configure for an exiting one) -> Look for the username and password fields. Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie
I find something weird... In Start > Admin tools> ODBC > User DSN, if I click "Add...", I don't see the PostgreSQL driver in the list at all. If I go to File DSN to configure the dsn file I've previously created, it prompts: General error: Invalid file dsn '... file name ...' I install the psqlodbc by running the psqlodbc.msi, and I know the driver (dll files) is installed to: C:\Program Files\psqlODBC\0804\bin\ Is there something else I need to do? Thank you for your help!! On 11/2/2009 4:19 PM, Raymond O'Donnell wrote: > On 02/11/2009 21:14, Nim Li wrote: >> Thank you for your quick reply. >> >> I don't see any place to specify "save username and password". > > Well, I was thinking of where I create and/or edit the DSN: > > -> Start menu > -> Administrative tools > -> Data sources (ODBC) > -> User DSN or System DSN etc > -> Add (or "Configure for an exiting one) > -> Look for the username and password fields. > > Ray. >
Hello, After I re-install the psqlodbc driver, I can find the postgresql driver in odbc. However the same problem persists ... I can't find anywhere to store the username and password. Then, instead of reading the linked tables, I use ADO's connection string to make the database connection, through which I provide the user name and password in the codes. This solves my problem. Thank you for your assistance. On 11/2/2009 4:34 PM, Nim Li wrote: > I find something weird... > > In Start > Admin tools> ODBC > User DSN, if I click "Add...", I don't > see the PostgreSQL driver in the list at all. > > If I go to File DSN to configure the dsn file I've previously created, > it prompts: > > General error: Invalid file dsn '... file name ...' > > I install the psqlodbc by running the psqlodbc.msi, and I know the > driver (dll files) is installed to: > > C:\Program Files\psqlODBC\0804\bin\ > > Is there something else I need to do? > > Thank you for your help!! > > On 11/2/2009 4:19 PM, Raymond O'Donnell wrote: >> On 02/11/2009 21:14, Nim Li wrote: >>> Thank you for your quick reply. >>> >>> I don't see any place to specify "save username and password". >> >> Well, I was thinking of where I create and/or edit the DSN: >> >> -> Start menu >> -> Administrative tools >> -> Data sources (ODBC) >> -> User DSN or System DSN etc >> -> Add (or "Configure for an exiting one) >> -> Look for the username and password fields. >> >> Ray. >> >