BCP error "Cannot open database "XXXXXX" requested by the login" -
12-14-2009
, 03:53 AM
Hello, I am having a problem relattin go BCP and SQLServer 2005, which is
reported as a bug to Microsoft, check link :
https://connect.microsoft.com/SQLSer...dbackID=351111.
I updated to Sql Server SP3 but the problem still occurs. I could easily
remove the -q option from the BCP command line, but this command line is
generated and executed by an external application, so I have no controll over
it. below is an example of the command line :
BCP I_5082_ST IN
"D:\ViaCTT_Directory_Structure\MailerData\Data\FIL \20091211091530_CTE_2009100406.via.xir.ir.cpy"
-F2 -m1000 -t\t -S localhost -U edx_dba -P edx
-f"D:\ViaCTT_Directory_Structure\MailerData\Data\FI L\20091211091530_CTE_2009100406.via.xir.ctl"
-CACP -q
-o"D:\ViaCTT_Directory_Structure\MailerData\Data\FI L\20091211091530_CTE_2009100406.via.xir.log"
and the error:
SQLState = 37000, NativeError = 4060
Error = [Microsoft][SQL Native Client][SQL Server]Cannot open database
"I_5082_ST" requested by the login. The login failed.
any idea is welcome, thanks |