Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Other SQL Server Topics (2005)  Help..."ERROR [3700] [AR System ODBC Driver]Expect

Author  Topic  mady Starting Member 2 Posts Posted - 2010-09-22 : 23:25:18 I am extracting data from using a DSN from Sql Server. Not allowed to touch the database server so I have connnect through data source name. I am getting this error "ERROR [3700] [AR System ODBC Driver]Expected lexical element not found: <identifier> " I could able to get the data from database using the DSN through excel sheet. code as follows ************************ public DataSet OdbcdataSet(DateTime strBgnTime, DateTime strEndTime) { strSql = "SELECT HPD_HelpDesk.Assigned_TO_Group,HPD_HelpDesk.Assigned_TO_Individual,HPD_HelpDesk.Case_ID,HPD_HelpDesk.Arrival_Time" + " FROM HPD_HelpDesk WHERE (HPD_HelpDesk.Arrival_Time) >={ts'" + strBgnTime + "'} AND (HPD_HelpDesk.Arrival_Time) <={ts'" + strEndTime + "'} "; OraAdpter.SelectCommand = new OdbcCommand(strSql, OraConn); OraAdpter.Fill(ds, "Table1"); return ds; } Connection String is ******************************* <add name="DBConnectionString" connectionString="DSN=AR System ODBC Data Source;ARServer=server address;ARServerPort=0;UID=;PWD=;ARAuthentication=;" /> *************************************** PLEASE HELP................... Thanks in advance..