[Firebird-net-provider] Query hang

[Andrew G. <ag...@jc...>]

The database in question is accessed via asp.net webpage and a delphi
winapp.

When the delphi winapp has a datagrid row(s) uncommited in a transaction, my
asp.net readonly query hangs.

I can run the same query from database workbench or ibconsole and it runs
fine while the winapp has rows uncommitted, but in asp.net it hangs - so I
think this is related to the firebird .net provider.

I used the sysdba user to rule out any problem with user authority, I tried
different isolation levels But made no difference.

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

Also - it took me a while to figure out how to manually set the isolation
level, you may want to add an example to the chm.



------   below is the code example I'm using ------------

  <appSettings>
  	<add key="connectionstring"
value="Database=C:\\interbase\\xxx.GDB;User=xxx;Password=xxx;Dialect=3;Serve
r=localhost;Pooling=False"/>
  </appSettings>


Sub BindGrid()
    
             Dim mydataset As New DataSet()
             dataAdapter = new FbDataAdapter()
    
             myConnection = new FbConnection(myConnectionString)
             myConnection.Open()
             
             'commented out --- Dim myiso As IsolationLevel = 3
	       'commented out --- myTxn =
myConnection.BeginTransaction(myiso)
              
             myTxn = myConnection.BeginTransaction()
    
             selectCmd = "SELECT * FROM TBLTEST"
    
             myCommand = new FbCommand(selectCmd,myConnection,mytxn)
    
    
             Try
                 dataAdapter.SelectCommand = myCommand
                 dataAdapter.Fill(mydataset, "TempInfo")  'filldataset
    
                 mydatagrid.DataSource = mydataset.Tables("TempInfo")
                 mydatagrid.DataBind()
                 dataAdapter.Dispose()
        
             Catch Exp As FbException
                 Message.Style("color") = "red"
                 Message.InnerHtml = "ERROR:" & Exp.Message & "<br>Code = "
& Exp.ErrorCode

             Finally             
                 myTxn.Dispose()
                 myCommand.Dispose()
                 myConnection.Close()                          
             End Try
    
             mydataset.WriteXml(Server.MapPath("data\" & struser &
myXMLfile),XmlWriteMode.WriteSchema)
    
    End Sub

Regards,
 
Andrew C. Goodall