I'm having trouble connecting to our Pervasive database (V8.6) in Visual Studio .NET 2005 Beta 2. I want to get some info from the database into a drop down menu.
These are the steps i'm taking.
1) Selecting the box for the drop down menu (ComboBox), in the properties select DataSource then Add Project Data Source. (Do it this way so it makes the data set as well)
2) Select Database - New Connection - Using ODBC select our Database (CHAHO) - Test Connection (OK)
3) Click next and leave the name as connectionstring1 - Select the required table and leave the name as dataset1.
4) Then i get the following error:-
Some Updating commands could not be generated automatically. The error message was:
ERROR [HYC00][Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface]Driver not capable.
Any ideas on a fix or updates i might need for pervasive?