Q

Problem solve

ODBC driver support for the SQL_ATTR_QUERY_TIMEOUT parameter

Published: 06 Oct 2004

Our application uses an Oracle 9i database as the backend. We currently use a native OCI interface to the backend but are about to move to an ODBC interface instead, and are exploring some third-party Oracle ODBC drivers such as Easysoft(www.easysoft.com) and DataDirect (www.datadirect.com). Also, as part of our application, we wish to set database query timeouts so that database latency can be controlled. We have heard of the SQL_ATTR_QUERY_TIMEOUT parameter of the SQLSetStmtAttr function, but are not able to find out whether the above mentioned ODBC drivers support this parameter or not. Does anyone on this list have any idea about this, or any other ODBC implementation that supports this parameter? Or is there some other mechanism by which an application using ODBC can control the query execution time?
You can use database profiles to limit CPU time and/or logical reads per call or per session; while perhaps not as direct as a specific query timeout, they will allow you to accomplish your goal.

Dig Deeper on Oracle database performance problems and tuning

Start the conversation

Send me notifications when other members comment.

SearchDataManagement

Cloudera adds data engineering capability to enable DataOps

Big data vendor Cloudera is looking to help data engineers use its platform with a new service that brings more power and ...
3 growing applications of AI in data management

There are plenty of ways AI can augment data professionals throughout the data pipeline, from sifting through large data sets for...
Key steps in the feature engineering process

Feature engineering is key to machine learning algorithms. Read on to learn how those features are created and chosen to increase...

SearchBusinessAnalytics

Emotions analytics helps Hotels.com connect with customers

While traveling has been halted for most of us, marketing efforts in hospitality still go on, and one way to sharpen those ...
ThoughtSpot IPO probably still a year away

After hiring a CFO for the first time and making changes to the way it reports revenue, ThoughtSpot is positioning itself to go ...
Power BI platform adds data storytelling capabilities

In its ongoing attempt to extend the reach of analytics to more users, Microsoft, during its virtual user conference, unveiled a ...

SearchSAP

In a time of crisis, S/4HANA implementation strategies shift

During a pandemic, organizations may consider pausing a major project like an S/4HANA migration, but experts believe they can use...
SAP Digital Boardroom helps Parkland Health manage pandemic

Parkland Health managed a surge of cases caused by the COVID-19 pandemic by using data analytics based on SAP Analytics Cloud and...
Real-life look at SAP intelligent RPA uses, benefits, limitations

SAP intelligent RPA works with the SAP ecosystem to help automate time-consuming processes. Learn what intelligent RPA is, how ...

SearchSQLServer

SQL Server database design best practices and tips for DBAs

Good database design is a must to meet processing needs in SQL Server systems. In a webinar, consultant Koen Verbeeck offered ...
SQL Server in Azure database choices and what they offer users

SQL Server databases can be moved to the Azure cloud in several different ways. Here's what you'll get from each of the options ...
Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

In this book excerpt, you'll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN techniques and find various examples for creating SQL ...

TheServerSide.com

How IT can deal with challenges of a move online post COVID-19

What will the long-term effects be of COVID-19 on the IT industry? Early indications show that virtual conferences and ...
How COVID-19 created a demand for COBOL basics

An uptick in COBOL interest stems from its presence in entrenched, legacy government apps, such as unemployment or apps for ...
WebAssembly Hub boosts Envoy filter development

Examine WebAssembly Hub's features, why developers have turned to the portal to share Envoy filters and how it seems to be built ...

SearchDataCenter

A look at the main differences of Bourne shell vs. Bash

Shells help admins run commands from the keyboard to the OS. Though Bourne shell and Bash are similar, there are differences in ...
6 tools to know for private cloud monitoring and reporting

Cloud reporting helps admins address capacity issues and reduce outages. Effective tools should include role-based dashboards and...
Set your strategy to get the right liquid-cooled data center

As data center rack densities increase, liquid cooling's benefits are becoming more apparent. Before purchasing, IT teams must ...

SearchContentManagement

How businesses can best build a WordPress knowledge base

A WordPress knowledge base can be useful for companies that want an easy-to-use and customizable product with many plugins that ...
Knowledge bases benefit customer service, call center training

Knowledge bases provide call center agents with training documents and answers to frequently asked questions as they continue to ...
Box Shield, mobile app upgrades on the way

Among a slew of coming upgrades, Box Inc. goes after Microsoft's government business with FedRAMP High certification.

SearchHRSoftware

Oracle HCM Cloud gets on-demand pay, internal talent market

Updates to the Oracle HCM Cloud platform include on-demand pay, internal talent marketplaces, more automation and an expansion of...
How Trump, Biden see automation and AI

The impact of automation and AI on the U.S. workforce has been a longstanding issue in presidential politics. That may be true ...
Corporate LMS adoption may come down to donuts

Corporate learning management systems can be popular with employees. But adoption requires planning and maybe a little schtick, ...

Close