Re: How can i set several databases using Win ODBC

> -----Original Message-----
> From: Nicolas Briones [mailto:nbr(at)designers(dot)cl]
> Sent: 29 August 2002 19:18
> To: pgsql-odbc(at)postgresql(dot)org
> Subject: [ODBC] How can i set several databases using Win ODBC
>
>
> I installed windows ODBC, configure everything, and all runs
> just fine. But now, i need to build another application,
> using another Postgres database, but ODBC only let me
> configure 1 database. If i try to add another postgres DSN,
> it just show me the first one, and can't add another one,
> only modify the first one... i refuse to accept that postgres
> ODBC be so limited...

It's not. I have 10 or more System DSNs setup. I would be inclined to
check your ODBC installation and that you have relevant permissions to
add a DSN. psqlODBC isn't clever about reporting that it failed to
update registry keys if you don't have permission to do so (i.e. it's a
system DSN and you're not an administrator).

Regards, Dave