Re: How can i set several databases using Win ODBC

Howdy Nicholas,

Check into DSNless connections.

Once the driver is installed, you can refer to it in your program

dim cn as ADODB.Connection
dim rs as ADODB.Recordset

cn.Open "Driver={PostgreSQL};Server=server4;Port=5432;Database=foobar;Uid=postgres;"

at that point you can point to another database besides foobar

Once the driver's been installed and registered on teh workstation, this method will work.

hope it helps
corey


On Thursday, August 29, 2002 11:18 AM, Nicolas Briones [SMTP:nbr@designers.cl] wrote:
> 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...
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster