Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jabedin
Starting Member
28 Posts |
 Posted - 2004-04-16 : 00:42:57
|
One of our user is having a difficulties of timeout when accessing data through MS-Access from a SQL Server. When the selected range is a bit big coming with the error message ODBC Timeout..... I have done once when I changed the ODBC timeout limit. I can't remember now.Any help regarding this will be highly appreciate.Regards JayBella VistaNSW-2153 |
|
|
drymchaser
Aged Yak Warrior
552 Posts |
Posted - 2004-04-16 : 09:20:37
|
| If this is from a query. Go to query design view. Right click in the tables (top) section and click Properties. Look for ODBC timeout (generally the value is 60) and set it to zero.Depending on version, you can set this in Tools>Options>Advanced. |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-04-16 : 13:46:14
|
| If you are using a pass-through query, go to design view, right-click on the title bar, choose properties. You can then change the time-out to whatever you want.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
jabedin
Starting Member
28 Posts |
Posted - 2004-04-26 : 19:04:36
|
| Thanks Mate. Sorry, I was on leave for a week. Will test those today.Thanks for your help.JayBella VistaNSW-2153 |
|
|
|
jabedin
Starting Member
28 Posts |
Posted - 2004-04-27 : 18:22:45
|
| Thanks Mate. It all work fine.JayBella VistaNSW-2153 |
|
|
|
|
|
|
ODBC timeout