Skip to Content
0

Crystal Report Database connector error

Mar 12 at 09:39 PM

49

avatar image
Former Member

Hello, I need help with fixing a database connector error. I have a program that uses Crystal reports as a 3rd party reporting system and I took one of there existing reports (Which was made in version XI) and opened it in the newly installed crystal reports on my computer and made changes to this report but when I try to preview the report it gives me this error code pictured in the screen shot.

screenshot-1.png

screenshot-1.png (80.0 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ian Waterman Mar 13 at 09:45 AM
0

Try changing connection type to OLEDB. This is very flexible and I have never encountered and join limitations.

What type of joins are you using?

Ian

Show 5 Share
10 |10000 characters needed characters left characters exceeded
Former Member

I did access the database field and selected OLEDB but then it gives multiple different connections which I tried and didn't not work and they asked for usernames and password. I'm not sure what you are asking when you say "What type of joins are you using"

0
Former Member

When I select to change the database to a OLEDB it gives me multiple providers when I select one it sends me to Connection Informtation and when selecting finish it says login failed.

0

Joins between tables

You need to select OLEDB type suitable for your database.

Speak to you Database Administrator to login details

Ian

0
Former Member

How do I know what type is suitable? and who is my database administrator?

0

Speak to your IT dept they will know who looks after the database you are using.

The DBA will be able to advise on connection type, OLEDB is generally acceptable

Ian

0