2014年2月21日 星期五

Access MS SQL server from Debian/Linux console - sqlline


1.Install sqlline and jtds (using apt-get )
apt-get install libjtds-java sqlline

2.ms sql jdbc connection string syntax
jdbc:jtds:sqlserver://ip/

3.drive class syntax
net.sourceforge.jtds.jdbc.Driver


4.command line example :
sqlline -u 'jdbc:jtds:sqlserver://ip/' -n user -p pwd -d net.sourceforge.jtds.jdbc.Driver 

5.using pipe redirect
sqlline -u 'jdbc:jtds:sqlserver://ip/' -n user -p pwd -d net.sourceforge.jtds.jdbc.Driver  < script.sql

1 則留言:

Unknown 提到...

Sports Betting - Mapyro
Bet 메이피로출장마사지 the moneyline https://septcasino.com/review/merit-casino/ from 1:25 https://sol.edu.kg/ PM casinosites.one to 11:00 PM. See more. MapYO Sportsbook features live odds, live streaming, ventureberg.com/ and detailed information.