Linux script using tsql

Question

I made a script to connect to my sql server. when I copy my script into my terminal it works fine.

I connect to my sql server with a raspberrypi using Tsql

but when I put my script into a file to run it automatic I get an error.

First my script:

tsql -H Server -U Username -P Password 
Go
Use master

paste it into my shell

 root@raspberrypi:~# tsql -H Server -U Username -P Password
Missing argument -p, looking for default instance ... found default instance, port 1433
locale is "nl_NL"
locale charset is "ISO-8859-1"
using default charset "ISO-8859-1"
1> GO
1> use master
2> go
1>

I put exactly the same script into the file data.sh But it won't work.

root@raspberrypi:~# ./data.sh
Missing argument -p, looking for default instance ... found default instance, port 1433
locale is "nl_NL"
locale charset is "ISO-8859-1"
using default charset "ISO-8859-1"
1>

Can anyone help me with this problem

thanks

Community · Accepted Answer · 2017-05-23 11:52:47Z

2

See this answer. For your data.sh script to work you need to pass the SQL statements into the tsql program. As you have it above, there is no input to the tsql program, so it just prints the prompt.

Try this in data.sh:

tsql -H Server -U Username -P Password <<EOF
    GO
    use master
    GO
EOF

edited May 23, 2017 at 11:52

CommunityBot

11 silver badge

answered Jan 7, 2014 at 14:54

Richard Neish

8,8164 gold badges41 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

GS1 Over a year ago

Thanks for your reply unfortunately it won't work it look like he use the command but there is no result or ouput root@raspberrypi:~# ./databasecopy.sh Missing argument -p, looking for default instance ... found default instance, port 1433 locale is "nl_NL" locale charset is "ISO-8859-1" using default charset "ISO-8859-1" 1> 1> 2> 1> root@raspberrypi:~#

Richard Neish Over a year ago

There is no results or output for the "Go" and "use master" commands, so the output in your comment matches what is in your first example where you paste into the shell. Try putting a SQL SELECT statement that produces results in the script and see if that works.

GS1 Over a year ago

Sorry I forgot to tell that because of the reason it will not give output i changed the script an add a create database. but no database is created

Richard Neish Over a year ago

OK, I don't know why it's not working for you. Sorry.

sth · Accepted Answer · 2014-12-15 19:08:48Z

0

You are probably using named pipes. Try adding -L [instance_name].

edited Dec 15, 2014 at 19:08

sth

231k56 gold badges288 silver badges370 bronze badges

answered Dec 15, 2014 at 18:56

user4363648

1

Collectives™ on Stack Overflow

Linux script using tsql

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related