We are trying to connect the simple way from Sharepoint Designer 2010 to an external Pervasive SQL version 10 database.
Normally this is a trivial excercise in any other development tool, you supply an ODBC connection and away you go.
Using Sharepoint Designer 2010 (or the previous version) it is not possible to get a working connection that will get you past the "Configure Database Connection" dialog. We have to use the "Use custom connection string option" as that is the only place
there appears to be a Provider for ODBC or OleDB.
No connection string works, I have tried connection strings that work fine in Visual Studio, no joy.
View Complete Post