using System.Data.OracleClient;
OracleConnection con = new OracleConnection();
con.ConnectionString = "Data Source=(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = xx.xxx.xx.xxx)(PORT = 1522))(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = MYDB)));User Id=XXXXXX;Password=XXXXXX;";
OracleCommand myCommand = con.CreateCommand();
Success
using System.Data.Odbc;
OdbcConnection con = new OdbcConnection();
con.ConnectionString = "Driver={ Microsoft ODBC for Oracle };Data Source=(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = xx.xxx.xx.xxx)(PORT = 1522))(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = MYDB)));User Id=XXXXXX;Password=XXXXXX;";
OdbcCommand myCommand = con.CreateCommand();
Failed
using System.Data.Odbc i am unable to connect to database of Oracle why what is the other format
Thanks!
Loading
YuvipoyPosted Aug 31, 2012, 2:24 AM
but i am getting this error
the same code works for Odbc but not for Oracleclient
System.Data.Odbc.OdbcException
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)
at System.Data.Odbc.OdbcCommand.ExecuteNonQuery()
Thanks!
Adil AnsariPosted Aug 30, 2012, 8:40 AM
Try to validate your connection string for Oracle ODBC at given web address
http://www.dofactory.com/Connect/Connect.aspx#oracle
Hope this helps you