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.

All Forums  SQL Server 2005 Forums  SQL Server Administration (2005)  SQL2005 to SYBASE ASEOLDB Timeout

Author  Topic  dea0303 Starting Member 1 Post Posted - 2011-07-28 : 20:10:36 I am currently having an issue with an SSIS package to import data from a SYBASE ASE v12.5 database. The package has an OLEDB data source set up for a SYBASE ASE v12.5 (32 bit) The connection tests successfully but when I run the package I keep getting an ASEOLEDB timeout error after exactly 3 minutes. [Native Code: 30149] [ASEOLEDB]The command has timed out. (ASEOLEDB) I am using the 64bit V15.5 oledb drivers supplied by SYBASE on a 64bit sql2005 instance. I have tried other methods (OpenQuery Function, OpenRowset function, Linked server...) and they all time out at three minutes exactly, with the exception of the linked server. It will timeout at exactly 10 minutes. Can anyone point me to where I might be able to alter this timeout parameter. I can find no reference to a connection timeout in either the properties for the data provider or the OLEDB data source. Small queries do seem to work.