MS SQL Server, Linked Server to Pervasive

Hello all,

I am new to the forums and I have a question regarding linked servers. I am searching for the method of adding a Linked Server from MS SQL Server to a Pervasive database (specifically, the DEMODATA database that one gets after installing the Pervasive trial).

Specifically, I am looking for

1. What (if any) special drivers do I need?

2. What DSNs (if any) are necessary, besides DEMODATA with the Pervasive ODBC Engine Interface driver?

3. What parameters need I provide to sp_addlinkedserver?

Any input would be very much appreciated. Thanks.

RobRefer to books online for linked server and heterogeneous data sources topics.

MS SQL Server searching functions

Hi,
the Soundex search words that sounds similar.
Does MS SQL Server has some function to make some intuitive search?
For example, for search term database, it should return rows that contains: "database" word, but also rows that contains "Oracle", "MySQL", "MS SQL" etc. terms.

Yes the Soundex string function is implemented in SQL Server and the others like MySQL and Oracle are not close to SQL Server in String functions because SQL Server implemented all. I have posted it a while back check the post below for all the SQL Server String functions. Hope this helps.

http://forums.asp.net/910656/ShowPost.aspx