Pervasive OLEDB provider data source name issue

I need to query a Pervasive database. My product is written in vb in Visual Studio 2010. The datafiles are dat files and are found in a specific folder. I tried to use "Provider=PervasiveOLEDB;Data Source=C:\datafilesDirectory" but I get the following message "The provider is unable to resolve the following path. To continue please provide the server and database name." If I create a data source, pointing to the data files directory and provide the DSN name to "Provider=PervasiveOLEDB;Data Source=newDSNName" then it works 100%. The only problem is that I can not expect my customers to create a DSN name for every pervasive db they want to query. Most of them won't know how to do this anyway. Please help.

edit delete
are you sure?
asked Gerhard van der Walt

0 answers

Post an answer but please log in first

Post Answer
  1. Please log in to post answer

Similar Questions

Tagsfor this question

Forumall questions