MS Access & C#

Question

User893424065 posted

 hello until 3 day i working one problem and cant resolved

i have one access mdb file. 1 table and 3 functions in module. when i run this query in access everythink is good and working

SELECT *, ((60*Degrees((ACos((Sin(Radians(40.128056))*Sin(Radians([airports].lat)))+(Cos(Radians(40.128056))*Cos(Radians([airports].[lat]))*Cos(Radians([airports].[lon]-32.995)))))))) AS Distance FROM airports

 

after i want to send this query from c# but givin this error undefined function Degrees i using OleDb i think i cannot access function from oledb 

 

string SqlString = " SELECT *, ((60*Degrees((ACos((Sin(Radians(40.128056))*Sin(Radians([airports].lat)))+(Cos(Radians(40.128056))*Cos(Radians([airports].[lat]))*Cos(Radians([airports].[lon]-32.995)))))))) AS Distance FROM airports;";
OleDbCommand cmd = new OleDbCommand(SqlString, cnn);
OleDbDataReader drReader;
drReader = cmd.ExecuteReader();

please help me