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