Member Avatar for cyberlan

Hi All,

I am new to c#programming, actually I'm supporting our shop floor application, It uses a c# and MS SQL 2005 as a back-end. My problem is that when my server uses a time zone (GMT + 8, +7, +6 etc..), the application works fine but when I try to change the time zone to (GMT -8, -7, -6 etc..) it will prompt and error message "This SqlTransaction has completed; it is no longer usable". Can anybody please help me why this error message prompt?

Thanks & Best regards,

  • 2 Contributors
  • 1 Reply
  • 168 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by alc6379
Member Avatar for alc6379

Can you provide a code example? It could be that you're changing the time at which the SQLTransaction runs. I think there's a timeout that's based on the local time that the transaction is submitted...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.