Can not connect SQLDataSource
Posted: Fri 02 Jun 2006 10:13
Hi,
We could not configure SqlDataSource component for Oracle Database (OraDirect .NET). When we include the User Id in the configuration interface, it warns us with "Unknown connection parameter User Id" message. When we omit the User Id and enter only the password, we can proceed to Test Query phase but it fails at the test giving "ORA-00942: table or view does not exist" warning. We are sure that the table exists. (We are using Visual Studio 2005)
When we use ODBC for datasource everything goes well.
We could not configure SqlDataSource component for Oracle Database (OraDirect .NET). When we include the User Id in the configuration interface, it warns us with "Unknown connection parameter User Id" message. When we omit the User Id and enter only the password, we can proceed to Test Query phase but it fails at the test giving "ORA-00942: table or view does not exist" warning. We are sure that the table exists. (We are using Visual Studio 2005)
When we use ODBC for datasource everything goes well.