Thread: multiple databases

I need to create a recordset in vb which combines a view/table from 2
different databases.  Is this possible?  in mssql you could go
dbo.databasename.tablename.  Can it be done in vb code?

Thanks for any help

Peter

"peter" <peter@peter.com> writes:
> I need to create a recordset in vb which combines a view/table from 2
> different databases.  Is this possible?

http://www.ca.postgresql.org/docs/faq-english.html#4.24

In 7.3, you can write queries that access multiple schemas; depending
on your needs, that might be sufficient.

Cheers,

Neil

--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC

It should be possible to do it within VB by opening a connection to each
database, getting results from each database, then munging them together
in vb. If you want to do it within the db, check out the dblink module
from contrib which might suite your needs.

Robert Treat

On Sat, 2002-10-26 at 01:15, peter wrote:
> I need to create a recordset in vb which combines a view/table from 2
> different databases.  Is this possible?  in mssql you could go
> dbo.databasename.tablename.  Can it be done in vb code?
>
> Thanks for any help
>
> Peter
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html