Crystal Reports XI connecting to ACT! 9

[CrystalLion]

I am not able to connect to ACT! 2007 Version 9. When I get to the Create New Connection option under Available Data Sources, ACT! appears in the list. However, when I try to select the database, the options are

ACT files *.dbf
All files

I can't leave it as ACT files *.dbf because they are not dbf files. When I select All Files, I see my database.adf file, but get the error message "Data object cannot be opened/accessed".

Any ideas? Thanks

 

[byevjzts]

What version of Crystal are you using...Standard or Professional?

Standard only allows you to connect to client data sources, whereas professional is for client AND server based connections.

Phill

 

[CrystalLion]

I'm using Crystal Reports XI Developer

 

[CrystalLion]

Let me modify my last reply to ensure I get the answer I need.

I am running Developer on both my own computer (single computer, not networked) and Developer at a client locaction where I will be connecting to an ACT! database residing on a server.

Can you give me the specific connection syntax for both if you know it?

Thanks

 

[GLComputing]

ACT! 6 was DBF...

You might need an updated driver for Crystal, or use the OLE DB engine in ACT! -

http://itdomino.act.com/act.nsf/docid/14023

I also recommend this to get a head start -

http://www.crystalclearreports.com/

Regards,
Mike Lazarus
ACT! Evangelist
GL Computing, Aust

http://www.GLComputing.com.au