DatabaseLink documentation
- To: mathgroup at smc.vnet.net
- Subject: [mg103199] DatabaseLink documentation
- From: fd <fdimer at gmail.com>
- Date: Thu, 10 Sep 2009 07:21:46 -0400 (EDT)
All I'm a heavy user of Mathematica with database to perform data analysis. Our server runs different instances of the same MS SQL server and there is no information on DatabaseLink documention on this. After a lot of trial and error if found you can specify different instances by separating server from semi-colon ";" as in the example below OpenSQLConnection[JDBC["Microsoft SQL Server(jTDS)", "host;instance/ mydatabasedb"], "Username" -> "user", "Password" -> "pass"] Hope this becomes useful to someone. best