Connecting to a SQL Server Instance

Question

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

Did you try "Name"->"XYZ_Database"? To me databasename = "XYZ_Database" does not look like a correct syntax.. — PlatoManiac, Apr 11 '14 at 14:45
You used a = instead of -> for an option. You seem to have forgotten the quotes as well. — Sjoerd C. de Vries, Apr 11 '14 at 15:26
You have database name that, I think, should be "Name", i.e. in quotes. You also have = not -> for that option. — Ymareth, Apr 11 '14 at 15:27
Are you getting an error message, java exception or $Failed? What is the output of the OpenSQLConnection call? — Ymareth, Apr 11 '14 at 15:45

score 2 · Answer 1 · edited May 12 '14 at 04:39

2

After looking at all the comments I was able to come up the following code that allows me to connect and query the database:

Needs["DatabaseLink`"];
conn1 = OpenSQLConnection[
  JDBC["Microsoft SQL Server(jTDS)", "ARC-WEB"], 
  "UserName" -> "Mathematica", "Instance" -> "SKWSPATIAL", 
  "database" -> "yyy", "Password" -> "xxx"]

Thanks for all your help!

edited May 12 '14 at 04:39

m_goldberg

107,779
16
103
257

answered Apr 11 '14 at 17:43

TheHiker

81
2

Connecting to a SQL Server Instance

1 Answers1