Обсуждение: multiple databases

Поиск
Список
Период
Сортировка

multiple databases

От
"peter"
Дата:
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




Re: multiple databases

От
Roberto Mello
Дата:
On Sat, Oct 26, 2002 at 03:15:18PM +1000, 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?

There's an extension to PostgreSQL, called dblink, that allows it. Look at
the contrib tree on the PostgreSQL archives.

-Roberto

-- 
+----|        Roberto Mello   -    http://www.brasileiro.net/  |------+
+       Computer Science Graduate Student, Utah State University      +
+       USU Free Software & GNU/Linux Club - http://fslc.usu.edu/     +
"Data! I thought you were dead!" "No, Sir. I rebooted."