devxlogo

Setting the Timeout Parameter

Setting the Timeout Parameter

Why Trust Us

Question:
I am converting a database from Access to SQL. It is a large database?some 4.5GB large.

I get a timeout (1 minute) before I get my response back. Can I change the timeout parameter, or is there a way to program a longer delay?

Answer:
You can set the time-out parameter from the ODBC manager. I wonder what is causing it, though, because with a 4GB database, how much of the conversion is logged? How long between commits? Or just what is causing the delay?

devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist

devx-admin

Learn more
Show More