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 |
|
alasse130
Starting Member
21 Posts |
 Posted - 2011-09-16 : 15:04:10
|
| Hi, in one of my web page, I am calling a stored procedure which does a bulk import from a CSV file. However, this doesn't work when the database resides on a different machine from that of where the client application is in since the file is in the client machine. How does one usually resolve this kind of problem? |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2011-09-16 : 15:08:57
|
| Hello,It is likely a permissions issue. Two potential options are;1) Transfer the file to a share on the DB Server or one which the DB Server has permissions to. (Most common resolution).2) Give SQL Server the appropriate permissions to the remote share to access the file.HTH. |
 |
|
|
alasse130
Starting Member
21 Posts |
Posted - 2011-09-16 : 15:24:59
|
| How do you usually detect if the database is on a remote computer? |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Bulk Insert remote file