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