Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Server Timeout

Status
Not open for further replies.

AmeriSource

Programmer
Dec 3, 2001
17
CA
I am running SQL server from a PC. We are using it as a server. I have about 20 users simultaneously using the system. I often get ODBC update fail, when users are making changes to the database. If anyone has any suggestions I'd appreciate it. I already increased the ram to 512 and increased my virtual memory.

Thanks in advance.
 
What is the server timeout value set for the ODBC configuaration.Check this out in the ODBC configuration as well as the server properties.

Are u using OLEDB provider like ADO connection for the connectivity?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top