Skip to main content

databaselink - How can I connect database(MSSQL Server) with Mathematica?



Newly I started working with database(MSSQL Server 2012).


by google help, I created Table name as EmployeesList and also Insertedvalues into the table.


know I want to connect database with Mathematica.for that I seen documentation and founded OpenSQLConnectionfunction.but still not connected.


 databaseInstalizationLink="C:\\Program Files\\Microsoft SQL Server";  
Needs["DatabaseLink`"];
OpenSQLConnection[databaseInstalizationLink]

I seen JDBCfunction also but I didn't get it.


I tried OpenSqlConnection[]wizard also.like if you evaluate the below one line code we get the wizard that screenshots I posted below


   OpenSQLConnection[]


Step 1:


enter image description here


I click on New Button


Step 2:


enter image description here


I click on Next button.


Step 3:


enter image description here


Step 4:



enter image description here


here,I changed to SystemLevel.


Step 5:


enter image description here


but,I installed 2012 version .


Step 6:


enter image description here


Step 7:


enter image description here


here,I didn't add any properties because,I didn't understood.



Step 8:


enter image description here


Finally,I click on Connect button but,it shows $Failed.


I hope,everyone understood what my problem.


can anyone help me?


Fell free,If you want to edit my question.




Comments