dbTalk Databases Forums  

BCP error "Cannot open database "XXXXXX" requested by the login"

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss BCP error "Cannot open database "XXXXXX" requested by the login" in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Luis Lima
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.