OLE DB (ADO) connection error crystal reports 10

[herbsza]

When we try to connect to a database using OLE DB (ADO)
the following message appears in the crystal reports 10

Error Message
Unknown Query Engine

The machine has the following operating system on it :
Microsoft Windows Servers 2003
service pack 1

We have tried to reinstall crystal 10 but the problem remains. The odbc driver works fine.

On a windows xp machine the OLE DB (ADO) also works fine.

Any suggestions to over come this problem would be apppreciated.

Thanks

 

[MisterMo]

Checked the basic, User permission can you see the database from the server.

Mo

 

[Turkbear]

Hi,
Be sure you have the corerct provider installed on the Server..To test, create and empty text file on the desktop, change its name to have a .udl extension and then use the Properties to test the Provider you need..






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[herbsza]

Thank you for your response

We tried both your suggestions but it is still not working in crystal.

How can we reinstall the OLE DB provider ?

Thanks

 

[MisterMo]

Can you create an ODBC connection via the traditional route?



Mo

 

[herbsza]

yes