Logon failed for CR based on command table 1

[Fabix]

Hello!

I'm using ACCPAC 5.4a with crystal XI. SQL server 2005
I use a trusted SQL connection

When I try to run a crystal report which contains a command (virtual table) from ACCPAC, ACCPAC returns me a "logon failed" message.

When I run the same report directly from Crystal reports everything works fine.

Also when I run a custom crystal report in ACCPAC based only on existing tables (no command) everything works fine and ACCPAC hasn't got any connectivity issues.

I apologize for my english
Any help would be GREATLY!!! appreciated.
I'm really stuck with this issue.

I've been looking over and over to different threats but didn't find any answer.

Thanks in advance

 

[ryslepel]

Hello Fabix
Have you been able to fix this problem because it seems that i have the same problem.

I would GREATLY appreciate it

Regards

 

[Jay Converse]

You can't do it, the Accpac Crystal wrapper replaces all login information.

Either run it from Crystal, or code and compile your own EXE to run it.

 

[ettienne]

Or use a VBA macro to run the Crystal report using the Crystal report object, this is advanced coding, so if you have no idea what I am talking about then stick with tuba's suggestion.