Re: [Firebird-net-provider] Query hang

[<car...@te...>]

Hello:

> Why would database workbench and ibconsole run the query, but through
> asp.net it hangs?

I think this needs to be an IsolationLevel issue, in the .net provider 
the isolation levels are mapped as ( IbExpert allows this to be 
configured i don't know what settings it use by default ):

ReadCommitted

	isc_tpb_version3
	isc_tpb_write
	isc_tpb_wait
	isc_tpb_read_committed
	isc_tpb_no_rec_version

Serializable

	isc_tpb_version3
	isc_tpb_write
	isc_tpb_wait
	isc_tpb_consistency

RepeatableRead

	isc_tpb_version3
	isc_tpb_write
	isc_tpb_wait
	isc_tpb_concurrency

ReadUncommitted
	
	isc_tpb_version3
	isc_tpb_write
	isc_tpb_wait
	isc_tpb_read_committed
	isc_tpb_rec_version


What version of the .NET Provider are you using ??



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain