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 |
|
trd_aravind
Starting Member
2 Posts |
 Posted - 2005-07-12 : 02:37:03
|
| Hi All, I have used "openquery" statement to connect to Sybase linked server from SQL Server. If I spawn multiple connections to the Sybase linked server thru 'Sybase.ASEOLEDBProvider' provider from a stored proc, I am getting 'The provider ran out of memory' error in my code. Is that 'openquery' maintains the number of connections opened always or it is closing the connection once it is done with the job. Please clarify on this.Thanks,Aravind |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-07-12 : 02:53:49
|
| Can you give details on what you are doing with OpenQuery?Are you transferring data from Sybase to SQL Server?MadhivananFailing to plan is Planning to fail |
 |
|
|
trd_aravind
Starting Member
2 Posts |
Posted - 2005-07-12 : 02:56:10
|
| Yes, I am pulling data from Sybase linked server and pushing into SQL Server 2K. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-07-12 : 03:12:08
|
| The performance depends on the number of records to be transferredUse Import/Export data or DTS option and see the performanceMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Linked Server - OPENQUERY