I am working in visual studio 2008 with C# and ASP.net, the company i work for has SQL and oracle databases. The SQL databases have all the proper queries and are working great, but now i am trying to connect to the oracle database.
here is my code:
string oracleConnString = "Provider=MSDAORA;Data Source=WHS01_d;Password=;User ID=TSODashboard_Read";
/* Return all Unclosed Changes from Time to Now */string strSQL = "select * from helpq.changerequest" +
"where daterequested >= to_date('05/01/2010','mm/dd/yyyy') and daterequested < sysdate and actualdone is null;";
OleDbConnection objConnect = new OleDbConnection(oracleConnString);
OleDbCommand objCommand = new OleDbCommand(strSQL, objConnect);
OleDbDataAdapter objAdapter = new OleDbDataAdapter(objCommand);
DataSet objDataSet = new DataSet();
string tickets = objDataSet.Tables.Rows.ToString();
But everytime i run it i get this error: ORA-00933: SQL command not properly ended
I have not written queries in oracle before so i have no idea why it is not working. Any help would be greatly appreciated!
Moved byEdwer FangMonday, June 07, 2010 7:48 AM (From:Visual Studio Database Development Tools (Formerly "Database Edition Forum"))