R&R under Pervasive 9.5

[Stephen_Menere_(Guest)]

We currently run very complex letters from R&R and now that we have upgraded our Pervasive from 2000i to v9.5, we are experiencing intermittant response times.____The normal time was around 5 to 10 minutes and now every so often it blows out to 45 mins. There are no other major network traffic at the time of the reports and after running several of these Letters, everything goes back to normal.____The R&R we tried was v10 with DataDirect ODBC and also Arpeggio v2 with the Intersolve ODBC____Is anyone aware of issues with either R&R, ODBCs and Pervasive v9.5

[kfleming]

Does the newer version of Pervasive come with its own ODBC driver that you could try?____Kathleen__R&R Support

[Stephen_Menere_(Guest)]

Yes it does come with the later Pervasive ODBCs, the only problem is that they do not allow joins to other tables only the tables designated in the ODBC chosen, i.e ODBC for mbr information ProdMbr does not allow you to join to the members address table found in ODBC for ProdADDR