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..

   

- Advertisement -