December 8, 2005 at 3:27 am
We are running ETL process using Data Integrator Software and the source and Target are both SQL 2000. The ETL job fails erratically with the following message.
| [Microsoft][ODBC SQL Server Driver][DBNETLIB] ConnectionWrite (send()) |
Does any one know what could be the problem and how to resolve it.
regards,
Milind
December 13, 2005 at 8:31 am
Milind - I lost the link but this was one of the solutions posted on another site for a similar error...see if implementing these 2 suggestions help!!!
"Mke sure that you are running the latest MDAC stack.
I see that you are using SQL Server ODBC driver, it is better to use the SQL
Server OLEDB driver."
**ASCII stupid question, get a stupid ANSI !!!**
December 13, 2005 at 10:39 pm
Hi Sushila,
Thanks for your reply. But Data Integrator is a product of Business Objects and it internally selects the ODBC driver for SQl server. So we do not have a chance to set it.
Milind
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply