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