Groups | Blog | Home
all groups > sql server (alternate) > may 2004 >

sql server (alternate) : Link Pervasive SQL Server - how ?



MarcinS
5/14/2004 2:59:05 PM

Hi

is anybody know how to lin Pervasiva/bitrive SQL server on MS SQL server ?

Thanks
John Bell
5/15/2004 9:41:45 AM
Hi

According to http://www.connectionstrings.com/ there must be an OLEDB driver
that you can use, failing that try ODBC.

See sp_addlinkedserver to add it as a linked server BOL:
mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\tsq
lref.chm::/ts_sp_adda_8gqa.htm

John

[quoted text, click to view]

AddThis Social Bookmark Button