lokichitti
Posts: 5
Joined: Mon Sep 02, 2013 9:52 am

MS SQL SERVER ACCESS FROM RPi REMOTEDLY

Tue Sep 17, 2013 10:25 am

Hi ALL

I want to access mssql running on WINDOWS from my RPi.
Is it possible? if yes please give me steps.
I using python2.7 to programming and RPi is running by the OS wheezy

thank you.

scottie2212
Posts: 3
Joined: Thu Aug 15, 2013 3:44 pm

Re: MS SQL SERVER ACCESS FROM RPi REMOTEDLY

Tue Sep 17, 2013 11:08 am

I don't know if this will help but you can only try.
With MySql you would start by defining a 'remote access host' on the server that you want your Pi to connect to. This would be either the IP address of your Pi (should be a static IP) or, if you are connecting over the internet, it would be the IP address assigned by your provider.
Then simply set your sql connetion 'host' to be the IP address of the server (instead of localhost) and a valid username and password on the SQL server.
Scottie

Return to “Python”