Pervasive linked server

I recently was working on an ETL project, from Pervasive.SQL8 to SQL Server 2005. For validation I needed to create linked server to pervasive server. From SQL Server connection to Pervasive is made using “Microsoft OLE DB Provider for ODBC drivers”. I tried different ways but none worked for me so end up creating DSN to Pervasive server then creating a linked server using that DSN.

USE master
GO

EXEC sp_addlinkedserver
@server = ‘PervasiveServerName’,
@srvproduct = ‘Pervasive’,
@provider = ‘MSDASQL’,
@datasrc = ‘DSN Name’