Likely this is an identity issue, not a driver issue. Check to be sure that the identity of the Tableau Server Run As account (this is the account that the server identifies itself as when linking to other servers in the network) has appropriate permissions to the Pervasive db. ODBC data integration and connectivity for Pervasive SQL to get real-time SQL access from any application that supports ODBC connectors. Connect to any cloud or on-premises data source using a standard interface. Web Experience Management. DataDirect Connectors Powerful Pervasive SQL ODBC driver. Pervasive PSQL Service & Support classes provided by Goldstar Software. Database Engine Type & ODBC Drivers Old DOS applications can be using Btrieve 5.x or older for DOS, 5.x for Windows,. I have Pervasive PSQL v.11 server but no PervasiveClient Interface driver on it. I looked for answer and what i found is to install Pervasive Client on server but i am afraid that it may mess the server or configuration.
I need to retrieve data from a Pervasive/Btrieve database on a remote webserver from an ASP page. Pervasive client 9.5 is installed on the server where the ASP page is located.
My connection...
Set myRecordSet = CreateObject('ADODB.Recordset')
myParms = 'Provider=PervasiveOLEDB;Data Source=myDatabaseName;Location=IP_address'
myRecordSet.Open 'Customer',myParms,adOpenDynamic,adLockOptimistic,adCmdTableDirect
myRecordSet.Seek ('14201447')
I get the following error;
Pervasive.SQL V9 OLE DB Provider error '80004005'
-1305: No such table or object
end error
The database does exists and is the correct name