dBASE Reports - dBase 2.6 and CR11

Author

dBase 2.6 and CR11

Igor

2005-10-27, 8:02 am

Hi,

I created one report with one table in it for testing purpose. It opens fine in crystal reports 11, but when I try to open it within a dBase I get an error saying "Unknown Database Connector Error".

I used Active X/ODBC(RDO) to connect to database.

Some parts of the code if you need whole file I can send it to you.

local f
f = new crv1Form()
f.crwApp = new oleautoclient("CrystalRuntime.Application")
f.PrinterSetup = {;form.report.PrinterSetup(form.hwnd)}
f.open()
return

/
/
/etc.

this.TOPPANEL.CRV1 = new ACTIVEX(this.TOPPANEL)
with (this.TOPPANEL.CRV1)
height = 534.0
left = 0.0
top = 0.0
width = 825.0
pageno = 0
state = " CBBIBBBBOLGFBBBBNIEH
BBBBBMBBBBBBBMBBQQQQ
BMBBBBBBBMBBQQQQBMBB
QQQQBMBBQQQQBMBBQQQQ
BMBBQQQQBMBBQQQQBMBB
QQQQBMBBQQQQBMBBQQQQ
BMBBQQQQBMBBBBBBBMBB
QQQQBMBBQQQQBMBBBBBB
BMBBQQQQBJBBBDBBBBBB
BBBBBMBBQQQQBMBBBBBB
BMBBBBBBBMBBBBBBBMBB
BBBBBMBBQQQQCEBBBKCB

BBBB"
classId = "{460324E8-CFB4-4357-85EF-CE3EBFE23A62}"
anchor = 6 // Container
endwith

If I use IDAPI Database DLL in cr11 to connect to database it works fine, but than I would have to install cr11 on each machine and buy license for it, which gets to expensive since we have over 100 computers using our application.

Any help around this is appreciated.

Thanks

Igor

*Lysander*

2005-10-27, 8:02 am

In article <RcoltJnyFHA.1044@news-server>, dauphinyu@hotmail.com says...

> I used Active X/ODBC(RDO) to connect to database.

That's the problem. Most likely you will have to use the idapi.dll.
If it works from CR 11, then most likely you have dBase-tables level 5=20
OR you are using the MS ODBC driver? This will use ADO-components, and=20
then this will not work together with BDE under XP SP1 and Server 2003=20
SP1.

> If I use IDAPI Database DLL in cr11 to connect to database it works=20
fine, but than I would have to install cr11 on each machine and buy=20
license for it,

No! That is not necessary.
You can deploy the RDC-components freely with your application.

The most easy way is to create MSI-Installer packages using the merge=20
modules.

I have created an english and a german MSI-installer for CR 10.

I am not sure about CR11 but I think that business-objects also offers=20
merge modules (*.msm) for CR11.

You can use the free software "installer 2 go" (search google somewhere=20
around www.dev4pc.com) to create installation packages for the crystal=20
reports part. This will automatically also deploy all needed database=20
drivers and connectors.
And if you are using any modern installer, you can integrate it into=20
your existing installation.

--=20
ciao,
Andr=E9
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~
Deutsche dBase-Konferenz dBKon 2005 ::: 11. bis 13. November 2005
Deutschsprachige Konferenz zu dBase und anderen Datenbanken
Info: www.dbase-konferenz.de

Igor

2005-10-27, 8:02 am

Hi,

> That's the problem. Most likely you will have to use the idapi.dll.
> If it works from CR 11, then most likely you have dBase-tables level 5
> OR you are using the MS ODBC driver? This will use ADO-components, and
> then this will not work together with BDE under XP SP1 and Server 2003
> SP1.

I was using dBase tables level 7 and MS ODBC driver. My computer is running XP Pro latest version/upgrades.

I do have merge modules installed on other computer so that is not a problem.

However, I changed tables from level 7 to level 5 and it works fine within cr11 (database connections ODBC RDO, xBase and IDAPI), but when I try to open it within dBase with ODBC RDO connection I get an error saying "Unknown Database Connector Error".

On the other side if I connected with xBase or IDAPI, it works fine. The down side of it is that application might be installed on a drive other than C: and in that case I wouldn't be able to run the report unless I make changes in cr11 and than update th
ose computers.

It would be nice if I could use ODBC RDO so I can modify it within dBase and not to think where is application going to be installed.

Thanks

Igor

*Lysander*

2005-10-27, 8:02 am

In article <nX171gqyFHA.1232@news-server>, dauphinyu@hotmail.com says...

> It would be nice if I could use ODBC RDO so I can modify it within=20
dBase and not to think where is application going to be installed.

There is a "known problem" of using ADO/ODBC together with BDE under XP=20
SP1 and higher and Server2003 SP1 and higher. It has to do with=20
"enhanced" security features.

I did not go too deep into it, because I am using only W2K SP4=20
throughout our company and Server2003 withOUT SP.

Try to search google on the problem, or try to look in the delphi-
newsgroups. They have a BDE-section where this problem and maybe a=20
workaround was posted several times.

--=20
ciao,
Andr=E9
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~
Deutsche dBase-Konferenz dBKon 2005 ::: 11. bis 13. November 2005
Deutschsprachige Konferenz zu dBase und anderen Datenbanken
Info: www.dbase-konferenz.de

*Lysander*

2005-10-27, 8:02 am

In article <nX171gqyFHA.1232@news-server>, dauphinyu@hotmail.com says...

> It would be nice if I could use ODBC RDO so I can modify it within=20
dBase and not to think where is application going to be installed.

Maybe there still is a chance...
It should be possible to hand the database-locations to the report-
object. I don't have time to test this out now, but maybe you will=20
search there a bit?

something like

CrxApp =3D new OLEAutoClient(...)
CrxRep =3D CrxApp.OpenReport(...)
CrxRep.databases[1].filename =3D <drive>+":\"+path+"\"+reportname
CrxRep.databases[2].filename =3D (...)

Should be possible, I think.=20

--=20
ciao,
Andr=E9
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~
Deutsche dBase-Konferenz dBKon 2005 ::: 11. bis 13. November 2005
Deutschsprachige Konferenz zu dBase und anderen Datenbanken
Info: www.dbase-konferenz.de

Sponsored Links