Re: Problems porting from MySQL Server to MSSQL7 Server

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." jlim@natsoft.com.my 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/