I need to import data from pervasive database to sql server. I have installed pervasive db claient & oledb provider. the pervasive database with me is in file format (folder with .DAT files). I would like to know how to read data from these files. when i used connection string as "Provider=PervasiveOLEDB;Data Source=C:\datafilesDirectory;" it gives unspecified error in 'Test Connection'. As i missing something here? Please help!!
1
votes
1 Answers
2
votes
Do you have DDF files (FILE.DDF, FIELD.DDF, INDEX.DDF) that describe the data files? Btrieve files do not store field information in them. If you don't have DDF files, you will need them in order to use OLEBD (or ODBC or ADO.NET or any other relational method).
At the same time, you will need more than just the PSQL "Client". You will need a PSQL engine available to read the files. Did you install an engine (workgroup or server) or client?
