From: | Nim Li <nimli(at)sri(dot)utoronto(dot)ca> |
---|---|
To: | rod(at)iol(dot)ie |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Question about saving user name and password |
Date: | 2009-11-03 15:52:07 |
Message-ID: | 4AF051A7.6050003@sri.utoronto.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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.
>>
>
From | Date | Subject | |
---|---|---|---|
Next Message | cholid | 2009-11-05 15:49:56 | Database connection error, try to reset the connection parameters |
Previous Message | Nim Li | 2009-11-02 21:34:12 | Re: Question about saving user name and password |