cancel
Showing results for 
Search instead for 
Did you mean: 
Subscribe

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

0 Likes
View Entire Topic
Former Member
0 Likes

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

Former Member
0 Likes

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"

Former Member
0 Likes

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.

Former Member
0 Likes

Joins between tables

You need to select OLEDB type suitable for your database.

Speak to you Database Administrator to login details

Ian

Former Member
0 Likes

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

Former Member
0 Likes

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