FVS: ODBC error when generating FVSIn.db in same session that project was created

USFS-PNW / Fia-Biosum-Manager

User interface and main code repository for Biosum

http://biosum.info/

Other

3 stars 3 forks source link

FVS: ODBC error when generating FVSIn.db in same session that project was created #309

Closed lbross closed 1 month ago

lbross commented 8 months ago

From Dan Swann: Just to reiterate from our recent Teams call, when this error has popped up for me, I have had 100% success if I close BioSum, reopen my project, and click "Create FVS Input database file" again. It has successfully created the FVSIn database file every time I do that.

With debugging turned on, I do get a brief debug report back that reads:

// //ExtractFIA2FVSRecords // Created DSN for FIABIOSUM_FIA2FVS_INPUT

lbross commented 8 months ago

I found some code related to registry and ODBC keys that served no purpose. Deleted it. I also added code to delete the ODBC DSN from the plot load process that could be pointed to the same FIA database. Because this only seems to happen when creating the FVSIn.db in the same session as a new project/loading plots, I suspect that something is hanging around from previous actions. The observation that FVSIn works after restarting BioSum supports this hypothesis. Unfortunately I was unable to recreate the problem so I'm not sure if these changes fixed it.

lbross commented 1 month ago

From Dan Swann following v5.11.0 release: No error message pops up when I click “Create FVS Input Database File”! That means issue 309 seems to be fixed!