Pervasive

I am trying view table names of demodata in SSIS Package Configuration.

 I was able to create OLE DB Connection and was able to test connect it successfully.

In the data flow tab, under ‘OLE DB connection manager’,

I was able to select the OLE DB connection I created.

Now when I select “Table or View” under “Data access mode” and try to view tables by clicking the dropdown of “Name of the table or the view”, I get the error:
 Could not retrieve the table information for the connection manager 'DEMODATA.DEMODATA'.

Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
 

Any help on how to resolve this will be greatly appreciated.
 I am using Pervasive V10.1. 
Thanks,

Henry

Mirtheil's reply:

 You mention v10.1 in your message but are posting in the v9 forum.  What's the exact version of PSQL you are using?  Specifically, what's the version of POLEDB.DLL and W3ODBCEI.DLL (or W3ODBCCI.DLL)? 
If you are really using 10.1, have you considered updating to the 10.31 patch?  

I am using V10.1.
Version of POLEDB.DLL        is 10.10.125.0
Version of W3ODBCEI.DLL    is 10.10.125.0

I have not considered updating to V10.31 patch. Should I looking into that? Do you know if the issue I am
having is a know issue and is resolved in 10.31?

Also,I can access the tables and the data if I write a SQL (Select student_id from billing).But I cannot see the
tables available for demodata.

Thanks for your response,
Henry

I have seen problem using Pervasive OLEDB with SSIS. You can try to use ODBC connection using ODBC.Net or .Net provider connection.