Using cmd and Named Pipes

[bebbo1986]

Hallo,
I need a method to access SQL Server (Developer Edition) via cmd and Named Pipes.
Is it possible do connect to the Server via cmd, send an SQL command and catch the result to go on working with it.

Thanks for any help,
Martin

 

[hmckillop]

This link should have all the information you require.

http://msdn.microsoft.com/en-us/library/ms188247.aspx

Any issues, just reply and we should be able to sort it out.


"I'm living so far beyond my income that we may almost be said to be living apart

 

[bebbo1986]

Thank you very much, you really helped me. But there are already the next problems.
I created a new alias with the name: VAIONamed and Parameters are \\BEBBO-VAIO\pipe\sql\query
I tried:
sqlcmd -S np:\\BEBBO-VAIO\pipe\sql\query
and
sqlcmd -S np:VAIONamed
both led to errors like: Could not open a connection to SQL Server [53]
I look for this error in the internet and found that then probably the server is not accessible and I should test that with ping.
So I tried: ping BEBBO-VAIO (BEBBO-VAIO is the server name)
and the result was:
Ping-Statistik for fe80:.....:
Packages: Sent = 4, Received = 0, Lost = 4

What can I do? Thanks for your help.

 

[bebbo1986]

I solved this problem. I had to change the properties of the server.
I had to set "Advanced > Filestream Access Level" to Full access enabled.
Now I have to check out how to work with the results. I think there will be new problems. We will see.

 

[hmckillop]

Glad you got it sorted, good luck.

"I'm living so far beyond my income that we may almost be said to be living apart