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.

0
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