FreeTDS is an open library FreeTDS used to connect to Sybase Databases and Microsoft SQL Servers. FreeTDS is used in PHP and Python and now nodejs.
You can use node-freetds to connect to Microsoft Azure.
var sql = require('node-freetds');
var azure = new sql.FreeTDS("abcd1234.database.windows.net:1433", "MyDatabase");
azure.login("username@abcd1234", "horsebatterystaplecorrect");
azure.executeSql("SELECT * FROM sys.Tables",
function(res) {
// Prints all tables for this database.
console.log(res);
}
);
This driver assumes that you have the freetds libraries installed. With Ubuntu you may install it like so:
apt-get install freetds-dev libsybdb5 libv8-dev nodejs-dev
For those of you with homebrew installed you can just do the following:
brew install freetds
This module is not currently in the npm repository; we will post here if / when it does. For now you can install using node-gyp (which is not a bad option either).
cd node-freetds
node-gyp configure
node-gyp build
node-gyp install
It helps a great deal to have GIT installed. Most likely if you are reading this from the Github site then you already have GIT installed. Otherwise get GIT and make sure to install it into Program Files NOT Program Files (x86). The Windows install comes with a GIT terminal that you can use. The rest of this documentation commands have been tested in the GIT terminal.
You will need to install Python (anything version < 3 will do). Download the Windows x86-64 installer for Python (or 32bit). You may need to add the new installation to your environment PATH variable. You can do this in the GIT terminal like so:
export PATH="/c/Python27:$PATH" # Make sure this is the path where you installed Python-2.7 to
Assuming that you have Microsoft .NET installed you will then also need to add MSBuild.exe to your PATH environment variable:
export PATH="/c/Windows/Microsoft.NET/Framework64/v4.0.30319:$PATH"
Get FreeTDS for Windows. Better yet, build it yourself directly from FreeTDS using MinGW-w64 or Cygwin. The rest of this installation will cover how to build FreeTDS for Windows are required for this project.
Use the MinGW-w64 installer to install MinGW-w64 compiler. In my case I had to select x64 architecture. Add MinGW-w64 binaries to your environment PATH variable:
export PATH="/c/Program Files/mingw-builds/x64-4.8.1-posix-seh-rev1/mingw64/bin:$PATH"
# Use mingw32-make
cp /c/Program Files/mingw-builds/x64-4.8.1-posix-seh-rev1/mingw64/bin/mingw32-make.exe \
/c/Program Files/mingw-builds/x64-4.8.1-posix-seh-rev1/mingw64/bin/make.exe
This project is configured to look for the FreeTDS header files in a freetds-* folder. Download the FreeTDS source and then untar while in the node-freetds folder:
cd [path to]/node-freetds # This project's folder
tar xf ~/Downloads/freetds-stable.tgz
cd freetds-stable
Configure FreeTDS - there is no need to actually build it:
./configure
The clone nodejs which yuo will need for thier header files:
git submodule add https://github.com/jpyent/node.git
** Unfortunately I am getting an build error with node-gyp unable to find 'node_isolate' even though it is defined in the nodejs include file node_internals.h.
2013-06-23
Significant changes were made from v0.1.0.
- Updated for node.js 0.11.x
- Implemented libuv for asynchonous tasks
- Added header file to attempt to be more like node.js programming structure
- Objects wrapped using node::ObjectWrap
( This is beta )
- Memory leaks
- No way to select database version (default is 8.0)
- No easy way to compile for Windows
THE SOFTWARE IS PROVIDED 'AS IS', WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.