Runtime Error 536 in Windows 7 and CR XI R2

[Former Member]

I'm running a test to display a report from a Delpni 2010 application. I connect to MS-SQL Server 2005 database using Native Client 2005 or 2008. In a PC with XP Pro 32 bits and CR X1 full product (developer ed.) and in other PC with W7 Pro 32 bits and CR XI R2 full product runs fine. When I run it on a W 7 Home Ed 64 bits with CrystalReports11_5_RDC_Reportengine and CrystalReports11_5_RDC_Runtime merge modules installed and Native Client 2008 64 bits, it fails with "Error 536 ... Unable to connect, Incorrect log on parameters. SQL.SetQuery <PEGetSQLQuery>".

The same application also display a simple report (no database connection) without errors, so the runtime is working. I also tested the server connectivity with ODBC using the native client without errors.

I think the culprit is a missing dll in the runtime module. Any ideas?

Best Regards

Francisco Alvarado

[former_member11696 · Accepted solution]

Hi Francisco,

A couple of problems. First you can not use crpe32.dll as the report engine. It's been deprecated as of CR 9.

There is no VCL component for CR XI R2.

Next is you are distributing the RDC, craxdrt.dll, runtime which doesn't use the PE* API's, those are the crpe32.dll API set.

Third issue is CR XI R2 does not support the MS SQL 2005 native client, no version of CR supports it. MS SQL 2008 is supported with Service Pack 6 and Fix Pack 6.2.

I believe at this point your only option is to move to our .NET components

Thank you

Don

[Former Member · Accepted solution]

Hi Don:

I had used CR from versions 2 to 8 and I like it a lot! Very elegant, powerful and I feel there's nothing I can't do with it.From my Delphi's applications I can make it dance and sing. But, now I'm evaluating to continue using it or change to something else because of it's poor integration with new versions of Delphi. So I want to be sure I have the right facts to make a decision.

<First you can not use crpe32.dll as the report engine. It's been deprecated as of CR 9.>

I'm using it with Delphi 2007, 2009 and 2010 and CR IX R1 and R2 in PCs with XP and 7 32 bits

<There is no VCL component for CR XI R2>

There are VCL components for Delphi 7 in SAP's site that compile up to Delphi 2007 and in Embarcadero's forum for Delphi 2009 and 2010. The last VCL components work with CR IX R1 and R2. I have tested them for a month or so.

<CR XI R2 does not support the MS SQL 2005 native client, no version of CR supports it.>

All my successful test are based on MS-SQL 2005 Server and SQL 2005 native client 32 bits, Applications compiled with delphi 2007 and 2010 display a report with almost 5000 records with graphs in 70 pages in less than two seconds (Ok, maybe 2.3 seconds). This application fails in a W7 64 bits PC with SQL 2008 native client 64 bits. Later, I will test it with 2005 64 bits client.

<I believe at this point your only option is to move to our .NET components>

I'll try that later this month. Starting in November, I'll develop an application to display data from SQL Server and Oracle 9i or 10g to a dashboard and I need to be sure CR is the right choice to do that.

Best Regards

Francisco Alvarado

[former_member11696 · Accepted solution]

Hi Francisco,

Just words of warning, no "official" VCL support in R2, it can be made to work but R2 is end of life soon and no more patches as of Fix Pack 6.4.

As for Native SQL driver, again not officailly supported until CR XI R2 SP6 and FP 6.2. CR 2008 and above will support it. We've discovered a new issue now and it's been tracked, you select the Native 10 client but the report will always use the Native 2005 client. Kind of messy so although it should not work because of the fix patch it does work but that may change when on Native 10 client will work.

There is a .NET component/option for Delphi which Trevor has done some testing with which allows you to use CR .NET assemblies in Delphi. I don't use Delphi so not sure how it all works, I just know it does now. Check the home page for more info and Trevor may see this also and/or I'll ask him to comment, links etc.

Thanks again for all your support. I've been here since CR 4.6.

Don

PS - I also moved your post to the .NET forum.

Edited by: Don Williams on Sep 23, 2010 5:00 PM

[Former Member · Accepted solution]

Thank you, Don, for your efforts helping me.

I found Trevor's articles, but they are for Delphi Prism (.NET) which I don't use at this time.

So for now, I must abandon CR as a preferred choice for reporting. To sad, because I had invested a lot of resources in CR since version 2! I will be watching these forums hopping sometime CR will integrate with Delphi .

Best Regards

Francisco Alvarado

[former_member183750 · Accepted solution]

Francisco, I have scanned this thread, but one thing I am not clear on; what is your preferred CR SDK?

The following are still available in CR XI R2:

RDC, VCL, CR Assemblies for .NET

In CR 2008 (12.x) the following is available:

VCL, CR Assemblies for .NET

The CR Win APIS have been retired in version 9, RDC is retired in CR XI R2. OCX was retired in version 8.5

Remember that just because Trevor created samples only for Prism, this does not mean that you can not use CR in other versions of Delphi. But more clarity as to what SDK you want to work with would be good to have.

Ludek

[Former Member · Accepted solution]

Hi Ludek:

My preferred CR SDK is VCL. I've used it for years. Last year I upgraded to CR XI and then updated to R2. I have several industrial projects complied with Delphi 2007 for Win 32 and with Delphi 2010.

II did some test with CRPE32.DLL and the VCL component found here /message/176110#176110 [original link is broken] with some success.

I need to connect to Oracle (9i-11g) and MS-SQL (2005, 2008) databases. Distribute run-time and rpt files to my customers.

One project, still in evaluation phase, would need a way to publish a report (intranet).

Any help will be appreciated.

Francisco Alvarado

[Former Member]

New results from test

I just finished some tests on a W7 Home Ed 64 bits that was sending the error on the subject of these messages.

I installed the 2005 Native Client for 64 bits, and it worked!

I installed CrystalReports11_5_RDC_Reportengine and CrystalReports11_5_RDC_Runtime merge modules, 2005 Native Client for 64 bits, a test apps compiled with Delphi 2007 for 32 bits and with Delphi 2010, a .rpt accessing a table from MS-SQL 2005 Server Express Ed.with about 5,000 records displayed in columns (74 pages) and at the report footer a graph.

I'll do more tests on Sunday now trying to display a report in a browser. Some ideas, anyone?

Edited by: FcoAlvarado on Sep 25, 2010 5:08 AM

[former_member11696]

Oh and I'm moving this to the SDK forum.