Re: How to solve the error:Microsoft OLE DB Provider for ODBC Drivers (0x80004005)

> Our sybase is very slow. How to enlarge the time out?

Do Sybase not provide a native OLEDB provider?
If so, it will be a faster than using the OLEDB provider for ODBC.

If they do provide this, you want to read

(i) The documentation Sybase provide on any native OLEDB provider
(ii) Any best practice whitepapers Sybase provide on performance of their
databases
(iii) For ADO best practices, see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag01/html/bestprac.asp
http://www.microsoft.com/technet/prodtechnol/sscomm/reskit/mdacapp.mspx

Stephen Howe

.

References:
- How to solve the error:Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
  - From: newsgroups.microsoft.com

Relevant Pages

Re: ADO error "Invalid Cursor State" after updating Sybase Adaptive Server Anywhere to ver
... > I'm writing a simple application to read some data from a Sybase database ... > Adaptive Server Anywhere Provider 9.0" OLEDB provider. ...
(borland.public.delphi.database.ado)
MS SQL 2005 to Sybase via Linked server
... server from SQl 2005 64-bit to Sybase. ... MS OLEDB Provider For SQL Server ...
(microsoft.public.sqlserver.odbc)
ADO error "Invalid Cursor State" after updating Sybase Adaptive Server Anywhere to version
... I'm writing a simple application to read some data from a Sybase ... installed the patch upgrading it to 9.0.1.1862. ... I am using Microsoft ADO to access the database through the "Sybase ... Adaptive Server Anywhere Provider 9.0" OLEDB provider. ...
(borland.public.delphi.database.ado)
ADO Error accessing Sybase Adaptive Server Anywhere 0 after installing 9.0.1.1862 patch
... I'm writing a simple application to read some data from a Sybase ... installed the patch upgrading it to 9.0.1.1862. ... I am using Microsoft ADO to access the database through the "Sybase ... Adaptive Server Anywhere Provider 9.0" OLEDB provider. ...
(microsoft.public.data.ado)