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 |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2006-05-30 : 12:41:25
|
| I've got a scheduled stored proc job that runs BCP to import flat files into the database daily.Recently, there was *one* folder that started generating the following error:Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.SQLState = 01000, NativeError = 53Warning = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).Interesting, the job runs on to other folders and works fine. Why would one folder generate a "sql server doesn't exist" error?Sam |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-05-30 : 14:30:20
|
| That message has to do with the the server where the job exists not being able to connect to the server in the bcp command. Add an alias using TCP/IP to fix this. It's currently trying to use Named Pipes (DBNETLIB part of the error message) and can't connect with it.Tara Kizeraka tduggan |
 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2006-05-30 : 14:40:08
|
| Thanks. I'll give it a try... I suspect it's the alias thingy, and I appologise for posting misinformation. The error I'm reporting is different from the production server, so I imagine any import would fail with this message on the testing server.Once fixed, I hope to dig my way down to the same error my production server is experiencing...Sam |
|
|
|
|
|
|
BCP fails with odd message.