Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 381
  • Last Modified:

Link SQL Server view into Access

SQL Server 2000, Access 2000

I have a SQL Server view that I linked into Access as a table. The view times out when either opened or used as the source of a report. I know I can create a query off of that view and set the timeout property in the query but I do not want to do that. Is there any way to set the timeout just for the table?

Thanks.
0
teneighty
Asked:
teneighty
2 Solutions
 
SimonLarsenCommented:
Seems like you may want to have a look on sql as to why it takes so long (paste the view source into query analyser, turn on display execution plan run the query and then see what costs so much, maybe run the index wizard over it and see if that fixes it)

I don't know of a way to change timeout for just one but if everything else is working it shouldn't really matter should it? Just set it really high.
0
 
pique_techCommented:
I'm guessing, because I can't find solid documentation, that this particular timeout is set in the ODBC driver configuration.

The only way to change that, I think, is to edit the registry.  

I would strongly advise against it, in fact I'm unwilling to test it.

But if my hunch is correct, the relevant registry keys seems to be located at
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\SQL Server\CPTimeout

Again, I think it would be *highly* inadvisable to change this unless you're absolutely certain you know what you're doing.  Messing around in the registry can render your computer UNBOOTABLE AND INOPERABLE.

Don't you think just running a query would be better?  It's certainly MUCH lower risk.

0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now