bcp "select a,b ,c from database.schema.SomeTable" queryout
"c:\MyData.csv" -c -t"," -r"\n" -S ServerName -T
when i am executing the above code i am getting an error
Error = [Microsoft][SQL Server Native Client 10.0]Named Pipes Provider: Could no
t open a connection to SQL Server [53].
SQLState = 08001, NativeError = 53
Error = [Microsoft][SQL Server Native Client 10.0]A network-related or instance-
specific error has occurred while establishing a connection to SQL Server. Serve
r is not found or not accessible. Check if instance name is correct and if SQL S
erver is configured to allow remote connections. For more information see SQL Se
rver Books Online.
SQLState = S1T00, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]Login timeout expired
How to solve the problem?
How can i execute oracle query from cmd and use it in bcp and generate .CSV file
Edited by: Oracle_Monkey on May 16, 2013 2:28 AM