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 |
|
ricky_newbee
Posting Yak Master
126 Posts |
 Posted - 2004-11-22 : 10:53:34
|
| All, we are running regular Load process and we get this error. One thing is we use TCP/IP for connections. But this error is saying Named Pipes. Any one here got this kind of error before. Microsoft OLE DB Provider for ODBC Drivers () (); Description: [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionWrite (WriteFile()).; Error #: -2147467259. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-11-22 : 10:59:12
|
| Add the following to your connection string:Network=DBMSSOCN;Address=servername,1433;Change the server name to match your SQL Server, and if you're not using port 1433, change the port number to match too. |
 |
|
|
ricky_newbee
Posting Yak Master
126 Posts |
Posted - 2004-11-22 : 11:24:19
|
| Rob, Thanks for you reply. This job was running since like 3 hours and it returned this error. Another thing is we didn't change any parameters in DSN, It was using TCP/IP and it still remains the same. This is an automated job which runs once every week. |
|
|
|
|
|
|
TCPIP/NAMED PIPES