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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-19 : 08:51:11
|
| Vincent writes "We run a nightly job that copies foxpro files from a novell server to our sql server for importing via dts. We do this using xp_cmdshell in a stored procedure like so:exec master..xp_cmdshell 'copy \\novell1\vol1\file.dbf d:\data\'In order to be able to read from novell, I had to enable the nwlink ipx/spx protocol in the server network utility, and all was fine. However, I have found that every time the server is restarted, I somehow lose this protocol. It still appears in the list of enabled protocols, but I cannot read the novell UNC path any longer. Then of course, our nightly copy job bombs. If I simply open the Server Network Utility and disable, then re-enable NWLink, everything is back to normal. This just doesn't seem like a practical solution.We are running SQL 2000 SP2 on Win2K server SP2.Vincent" |
|
|
|
|
|
enabling nwlink ipx protocol on server