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
> Hi John -
>
> Can you elaborate on the concurrency issues?
> Thanks.
>
>
> John wrote:
>
> > Hello Adrian,
> >
> > There are some concurrency issues with mssql if you are using
> > mssql_pconnect. Try switching to mssql_connect. Also check to see if
> > transactions are enabled in mssql.
> >
> > Your SQL insert syntax looks ok.
> >
> > Regards, John
>
---
"Stressed spelled backwards is desserts."
[EMAIL PROTECTED] NATSOFT MALAYSIA (60)3-706 1216
Visit this web site for Asian and local Internet news
http://webfeet.editthispage.com/
My PHP website:
http://php.weblogs.com/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
