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.

Reply via email to