Conflicting MDAC versions

  • quote:


    The error that I get is a crystal reports error. Its "CrystaL Reports Error 533: Unable to open Database"


    I would suggest you to check Crystal error meesage 533 in Crystal to see what is missing.

  • I already have, I have even talked to them about this, they were not sure of how to deal with MSDE as they were not familiar with it.

    They did try everything they could to resolve the issue but no use. That is why I have turned to forums, just to see if someone has a solution to it.

    Thanks

  • Which version Crystal Report do you use? We don't have problem to run Crystal 8.5 against SQL Server 2000. I don't know why it doesn't work with MSDE 1.0. Can you upgrade MSDE 1.0 to MSDE 2000? Or try install MDAC 2.7SP1 and reinstall Crystal Report.

    Edited by - Allen_Cui on 05/26/2003 12:30:16 PM

  • We are using crystal 8.5.

    I am sorry, I forgot to mention that the same reports also work fine with SQL Server 2000/7.0. But not with MSDE 1.0.

    I have not tried it with MSDE 2000. I can do that but I have another question in this regard:

    MSDE 2000 is installed with NT Authenticaton and even though I changed it to use mixed authentication, if I try to logon with sa and blank password It still says :"not associaated with a trusted SQL Server Connection". How can I fix that, will I have to install MSDE 2000 with some specific parameters that will give a password to sa?

    Thanks for your help, it will solve a big hurdle in my project.

  • Register MSDE 2000 instance with EM and change from there. If you don't have EM, you then have to change the registry.

    Change key \\hkey_local_machine\software\microsoft\mssqlserver\mssqlserver\loginmode to 2.

  • Thanks,

    I will try that right now.

Viewing 6 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply