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


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

Solution - DatabaseLink connetion to MSSQL using Windows authentication

Started byfd <fdimer@gmail.com>
First post2012-04-20 11:47 +0000
Last post2012-04-20 11:47 +0000
Articles 1 — 1 participant

Back to article view | Back to comp.soft-sys.math.mathematica


Contents

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

#9707 — Solution - DatabaseLink connetion to MSSQL using Windows authentication

Fromfd <fdimer@gmail.com>
Date2012-04-20 11:47 +0000
SubjectSolution - DatabaseLink connetion to MSSQL using Windows authentication
Message-ID<jmribm$lca$1@smc.vnet.net>
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









[toc] | [standalone]


Back to top | Article view | comp.soft-sys.math.mathematica


csiph-web