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.