mssql_pconnect issues?

Very strange. I've noticed some integrity issues using mssql_pconnect, but we don't explicitly use transactions in any case, so it may not even go that deep. I wonder if the odbc functions have this issue - anyone have any ideas? jlim@natsoft.com.my wrote: > Hello Michael > > Some people have reported with the ADODB database class library that they > were having problems with inserts and updates when using mssql_pconnect. > Switching to regular mssql_connect the problems disappeared. > > I suspect it has something to do with persistent connections having > inconsistent transaction handling settings. Eg. > > - Connection A is setup by user 1 to use transactions. > - Connection B is setup by user 2 not to use transactions. > - Connection A is reused by user 2, who thinks he doesn't need > transactions, but connection A actually requires a commit to work because > of user 1's previous setting... > > People using Interbase have reported this problem also. > > Regards, john