Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.soft-sys.math.mathematica > #9707

Solution - DatabaseLink connetion to MSSQL using Windows authentication

From fd <fdimer@gmail.com>
Newsgroups comp.soft-sys.math.mathematica
Subject Solution - DatabaseLink connetion to MSSQL using Windows authentication
Date 2012-04-20 11:47 +0000
Organization Steven M. Christensen and Associates, Inc and MathTensor, Inc.
Message-ID <jmribm$lca$1@smc.vnet.net> (permalink)

Show all headers | View raw


All,

I'm posting a solution to connect Mathematica and MSSQL server using windows authentication just in case anyone needs it some day.

Very simple: download the jtds driver at

http://sourceforge.net/projects/jtds/files/

the only files you'll need are ntlmauth.dll, which are located inside the zip in x86 and x64 folder. This file has to be copied to your Mathematica folder SystemFiles\Java\Windows(****)\bin - depends whether you have a 64-bits windows or not, but should be that simple.

In other Internet forums I found reference to copying this file to you local windows\system file, but it did not work for me.

WRI could include this file in the java library binaries for the next releases.

Hope it helps.

All the best









Back to comp.soft-sys.math.mathematica | Previous | Next | Find similar | Unroll thread


Thread

Solution - DatabaseLink connetion to MSSQL using Windows authentication fd <fdimer@gmail.com> - 2012-04-20 11:47 +0000

csiph-web