Hi Dotnetters,
I have managed to set up my connection string to point to the OracleService.
However I am getting invalid user/name password on the following line
//Open the Connection to the Managed DataSource
oracleConnection.Open();
Here is a snippet of my code
OracleConnection oracleConnection = new OracleConnection(GetConnection());
Where
private string GetConnection()
{
return m_Connection;
}
and
m_Connection = "Data Source=ORCL;Integrated Security=yes";
when I change the connection string to take userid and password as follows
m_Connection = "Data Source=ORCL;User ID=" + userId + ";Password=" +
password +";Integrated Security=yes";
I still get the same invalid userid/password problem
I have tested the userId and password through sqlplus in oracle and
confirmed that they are correct for the specified service.
Has anybody got any ideas?
Regards,
Raj
You can read messages from the DOTNET archive, unsubscribe from DOTNET, or
subscribe to other DevelopMentor lists at http://discuss.develop.com.