<div>Hi ,</div> <div> I tried to query the FeatureData Source (SQL Server 2005 view -odbc),</div> <div> </div> <div><BR> $sql="select ownername_th,epz_type,province_name_th from V_estates where estate_no=10";<BR> </div> <div> $featureResIdSql = new MgResourceIdentifier("Library://VV/Data/sql_odbc.FeatureSource");<BR> <BR> $sqlDataReader=$featureService->ExecuteSqlQuery($featureResIdSql,$sql);</div> <div><BR> while($sqlDataReader->ReadNext())</div> <div>{</div> <div> $owner= $sqlDataReader->GetString('OWNERNAME_TH');<BR> $epz= $sqlDataReader->GetString('EPZ_TYPE');<BR> $province= $sqlDataReader->GetString('PROVINCE_NAME_TH');</div> <div> </div> <div>echo $owner;</div>
<div>echo $epz;</div> <div>echo province;<BR></div> <div>}</div> <div> </div> <div> $sqlDataReader->Close();</div> <div> </div> <div>Although i able to perfom sql query by passing ID and it use to give result from the SQL Server 2005 Views,and don't show any exception or error in the task frame but when i opened the Server Error Log file it use to create stack trace for the error-<FONT color=#ff0000>An exception occurred in FDO component.</FONT><BR></div> <div> </div> <div><FONT color=#ff0000><2007-09-12T14:43:59> Administrator<BR> Error: An exception occurred in FDO component.<BR> Query ended <BR> StackTrace:<BR> - MgFeatureServiceHandler.ProcessOperation line 83 file c:\build_bond_area\bond_nightly\build_41.3\ent\os\server\src\services\feature\FeatureServiceHandler.cpp<BR> - MgOpGetSqlRows.Execute line 102 file
c:\build_bond_area\bond_nightly\build_41.3\ent\os\server\src\services\feature\OpGetSqlRows.cpp<BR> - MgServerSqlProcessor.GetRows line 79 file c:\build_bond_area\bond_nightly\build_41.3\ent\os\server\src\services\feature\ServerSqlProcessor.cpp<BR> - MgServerSqlDataReader.ReadNext line 76 file c:\build_bond_area\bond_nightly\build_41.3\ent\os\server\src\services\feature\ServerSqlDataReader.cpp An exception occurred in FDO component.<BR>Query ended <BR></FONT><BR>I am unable to understand how to debug this error or what i am missing in the code.</div> <div> </div> <div>Thks</div> <div>Max</div><p> 
<hr size=1>Tonight's top picks. What will you watch tonight?
<a href="http://us.rd.yahoo.com/tv/mail/tagline/tonightspicks/evt=48220/*http://tv.yahoo.com/
">Preview the hottest shows</a> on Yahoo! TV.