What is the syntax for connecting to a specific instance of a sql server database?
Here's my code:
Needs["DatabaseLink`"];
conn1 = OpenSQLConnection[
JDBC["Microsoft SQL Server(jTDS)", "ARC-WEB/SKWSPATIAL"],
"UserName" -> "Mathematica", databasename = "XYZ_Database",
"Password" -> "xxxxx"]
I have no problem connecting to ARC-WEB but cannot connect to one of the other instances. Mathematica 9.0 SQL Server 2008
"Name"->"XYZ_Database"
? To medatabasename = "XYZ_Database"
does not look like a correct syntax.. $\endgroup$=
instead of->
for an option. You seem to have forgotten the quotes as well. $\endgroup$