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!

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: Question about saving user name and password

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

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: Question about saving user name and password

On Mon, Nov 2, 2009 at 12:59 PM, Nim Li 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&Num ber=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

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: Question about saving user name and password

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.
>

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: Question about saving user name and password

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

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: Question about saving user name and password

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.
>

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: Question about saving user name and password

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.
>>
>

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc