We are new to Sharepoint Designer and are trying to add a Data source to an oracle server. When we go to the "Use Custom Connection String" box and enter the connection string:

Data Source=<OurDB>;User Id=<User>; Password=<PW>;Integrated Security=no;

We get the message: "An error occured while retrieving the list of Databases from <Data source>: The Server for the data source returned a non-specific error when trying to execute your query...."

The sharepoint server has no problems connecting to the oracle DB, nor does the machine that is running the designer. So what could the problem be? Is there any place that I can look to see the real error message?

Thank you in advance for your help.

Dan Strohschein