Re: [Digir-dev] DiGIR and MS_Access

[Dave V. <vie...@ku...>]

Hi Kevin,
Does the SQL statement in the diagnostic execute as expected from within Access?

Dave V.

Kevin Webb said the following on 03/28/2006 08:19 AM:
> Greetings!
> 
> I have an issue when searching a DiGIR resource that uses MS-Access
> as the data source. Inventory requests work correctly and result in 
> well-formed
> responses, search requests on the other hand generate the following error
> statement.
> 
> 
> <diagnostic code="STATUS_INTERVAL" severity="info">600</diagnostic>
> <diagnostic code="STATUS_DATA" severity="info">0,20,1</diagnostic>
> <diagnostic code="Unknown PHP Error [2]" 
> severity="DIAG_WARNING">(null)(): Invoke() failed: Exception occurred.
>  &lt;b&gt;Source&lt;/b&gt;: Unavailable &lt;b&gt;Description&lt;/b&gt;: 
> Unavailable 
> (F:\root\DiGIRprov\lib\adodb\drivers\adodb-ado.inc.php:227)</diagnostic>
> <diagnostic code="QUERY_PRODUCED_NO_RESULTS" severity="warn">The query 
> generated a null resultset.</diagnostic>
> <diagnostic code="DATABASE_ERROR" severity="error"></diagnostic>
> <diagnostic code="SQL_DEBUG_INFO" severity="debug">SELECT 
> pointsurvey.birdid, pointsurvey.state, pointsurvey.county, 
> pointsurvey.year, pointsurvey.initials, pointsurvey.sex, 
> pointsurvey.transect_transectid, pointsurvey.pointvisitid, 
> pointsurvey.transectnum, pointsurvey.starttime, pointsurvey.endtime, 
> pointsurvey.perpenddistance,radialdistance, pointsurvey.bearingtobird, 
> pointsurvey.count, pointsurvey.date, pointsurvey.zone, 
> pointsurvey.northing, pointsurvey.easting FROM pointsurvey WHERE 
> ((pointsurvey.state = 'WY'))</diagnostic>
> 
> I have 3 questions regarding this error statement.
> 
> 1. Why would a search request on a concept that has been reported as having
> a non-null data set via an inventory request report a null result set 
> when searched?
> 
> This is the inventory response associated with the previous search 
> request error.
> 
> <record>
>   <bmde:StateProvince count="*111939*">WY</bmde:StateProvince>
>  </record>
> 
> 2. Why would the call to Execute() at line 227 of  adodb-ado.inc.php
> report an availability issue when inventory requests execute to completion?
> 
> 3. What should I do to correct this?
> 
> 
> 
> Thank you.
> 
> 
> KFW
> 
> 
> 
> -----------------------------------------
> Kevin Webb
> Programmer/Analyst
> Cornell Lab of Ornithology
> 159 Sapsucker Woods Rd.
> Ithaca, NY 14850
> Tel: 607.254.2103
> Fax: 607.254.2415
> kf...@co...
> -------------------------------------------
>