Hello,
I have been trying and unsuccessfully to connect to an Oracle database by adding a connection to the database through SharePoint Designer. I think this is the only way to connect to the database so that i can use the Data View web part. I am using MOSS 2007.
I open the Data Source Library and expand Database connections and select "Connect to database..."
I go to configure database connection... and select Use custom connection string:
I enter it in this format "Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;" and select "Microsoft .NET Framework Data Provider for Oracle" select OK
When i go from there anmd hit next get a warning that i it saves the username and password as text blah blah...
then I get this lovely message:
Server Error: An error occcurred while retrieving the list of Databases from XXXX: The server fro the data source returned a non-specific error when trying to execute your query. Check the format nad content of your query and try again. If the problem persists, contact the server administrator.
Now, I have used this connection string in other applications no problem. But this is confounding me. I have found alot of posts on this but none with any solutions. Just putting this out there to see if any bright minds have found a reason for this.
Thanks