I am new to this software, just testing the connection to Oracle from asp.net C# code.
A)
OracleConnection Connection = new OracleConnection("Server=xxx.xxx.com;User Id=user1;Sid=dev;Password=xxx;Direct=True");
B)
OracleConnection Connection = new OracleConnection("User ID=user1; Password=xxx; Data Source=dev");
connection string A works for oracle 9i, but not for 10g, got invalid SID error. But connection string B works for 10g with same SID.
My question is what is the difference between above two connection strings? Is it possible B uses oracle_net (tnsname.ora) instead of oraDriect since I have them both installed on my machine.
Thank you very much for you reply!
June
Are the connection to oracle 9i and 10g different?
In B you are connecting using Oracle client and tnsname.ora.
In A you are connecting without Oracle client and tnsname.ora.
OraDirect is a data provider that helps you to write .Net applications with access to Oracle.
Please note that SID and Data Source are different values. Please take SID from tnsname.ora as described in "Using Direct Mode" topic in OraDirect .Net documentation
In A you are connecting without Oracle client and tnsname.ora.
OraDirect is a data provider that helps you to write .Net applications with access to Oracle.
Please note that SID and Data Source are different values. Please take SID from tnsname.ora as described in "Using Direct Mode" topic in OraDirect .Net documentation