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.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
The Customer table also exists
Please help...desperate...I've been struggling with this connection for weeks.
A Btrieve login request failed because the client is already logged into the specified database. 174: Logout failed A logout can fail if you are not logged in to a database or there are remaining open file handles to the database when the logout is attempted. Btrieve is a low-level database record manager which is used within the Novell NetWare environment to provide database functionality for use by server-based and client-based applications. Btrieve started life in 1982 when Doug and Nancy Woodward founded the company Softcraft in Austin, Texas.
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
The Customer table also exists
Please help...desperate...I've been struggling with this connection for weeks.