Recent content by cheerfulskeptic

that did the trick. thanks!

still no luck means, the data is still being displayed with the ID's being sorted by the group headings (the value of SPECID) as in 10035 9010 9062 9063 9099 whereas the 10035 should be after the 9099... Thanks, i'll try this one now... -

Thanks a lot, but i'm really sorry - I totally forgot to mention that i have a grouping on table.SPECID in Ascending order. I added an SQL expression called %sqlconvert and specified a convert to int, and grouped on that, but still no luck...

Hello, I have a CR8 connected to an SQL server database.. I have a table called SPECS with the primary key being SPECID (nvarchar 10) and a field SPECDESC (nvarchar 255). the SPECID contains a number incrementing for each item inserted. the problem is that we have to sort the data in the crystal...

Hi, We have a web application that we wrote in ASP that also has reports tied to them. However, when we ran load tests with 4 users logged in and accessing the server, we encountered a 10% or less report failure rate (10 times out of 125 reports we ran gave an error). Here is the structure: A...

I dont think anything has changed. the ODBC DSN on the web server is a System DSN. the exact error message - on Crystal, it cant connect, and for ASP it doesnt even connect to the DSN (Data source not found). The MAX/Pervasive server is on a different machine. On my local machine with IIS...

We have Pervasive 2000i installed on our server. Till last month, any ASP page that gets data from Pervasive via an ODBC connection wrked fine. Also crystal reports deployed over the web worked fine. Now, nothing... I have even made a simple page to connect to the database with objconnect.open...

we are using Pervasive V8 and are running some ASP pages that report on financial data from MAX. The ODBC drivers are somehow very slow, so we decided to switch to OLEDB. I downloaded the OLEDB for Pervasive from the pervasive website and installed it. However, when I write out the following...

would you know why I'm getting the error in the first place? thanks

I am using Crystal 7. ODBC is very slow to the Pervaisve SQL server 2000, so I decided to switch to the Crystal Btrieve Driver. Performance within Crystal was significantly improved. Here is my report structure Main Report 3 groups of fields innrmost group, account ID has a subreport in the...

Hello, I am joining an SQL Server Table to a Pervasive SQL table in a report, and am consistently getting an invalid descriptor index error. Here's the structure SQL Server tables: tbl_accounts all fields are nvarchar and fld_MAXID is char(7) tbl_territory all fields are nvarchar...

I am using Crystal 7. ODBC is very slow to the Pervaisve SQL server, so I changed to the Btrieve Driver. This is all in a subreport - I then specified the f:\MAx\sales\file.ddf location as the definition location. The database table location (just 1 table) is f:\max\sales\invdet.dat alias...

all i get is 1) an ASP error which says " Server threw an exception". 2) if I do an on error resume next, then I get a CRAXDRT error in the ActiveX viewer.

I am using Crystal 7. ODBC is very slow to the Pervaisve SQL server, so I changed to the Btrieve Driver. This is all in a subreport - I then specified the f:\MAx\sales\file.ddf location as the definition location. The database table location (just 1 table) is f:\max\sales\invdet.dat alias...

Thanks for your help. However, I tried this... the only Btrieve driver in Crystal 7 I see is pdctbtrv.dll. I selected field.ddf and then made the location of Invoice Detail to \\MAX\Sales\invdet.dat. It works fine under crystal but I get a CRAXDRT error when viewing over the web... I'm using hte...