FTP + MS SQL Server + Pi + Uploading

[chathura25]

hello,
i'm new to pi and linux. i need to upload a photo to web sever which has been created by my friend. i try to use ftp but it doesn't work. web server has created using www.somee.com and he gave me following details.
MS SQL Server address: SchoolVanMonitoring.mssql.somee.com
ogin name: *************
Login password: ********

i had install command line ftp client and in the root terminal i had write the below line.
ftp SchoolVanMonitoring.mssql.somee.com

but it gives me an error like this - ftp: connect: connection refused

why this happens? can't i upload file to a MS SQL Server using pi?

[riklaunim]

MSSQL is a database that isn't accessed via FTP. You connect to it with the given credentials using a client application or one of those: https://wiki.python.org/moin/SQL%20Server libraries. To operate on a database you create tables and insert data to them. No file upload but you probably can insert binary blobs into a table (where those blobs will be images from the camera).

[DougieLawson]

It's quite common for SQL engines to provide a FTP service for data loading. DB2 does that on the mainframe. MSSQL does that with an add-on.

http://www.mssqltips.com/sqlservertip/2 ... -exchange/