3
$\begingroup$

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.

Improve this question
$\endgroup$
7
  • $\begingroup$ @PinguinDirk I tried that too also,still not connected for more information I will modify my question. $\endgroup$
    – subbu
    Apr 8, 2013 at 11:41
  • $\begingroup$ @PinguinDirk ok..can You tell is it right,what I did in wizard. $\endgroup$
    – subbu
    Apr 8, 2013 at 12:27
  • $\begingroup$ as it is all MSSQL (no longer mysql) now, I am of no help. will delete other comments $\endgroup$
    – Pinguin Dirk
    Apr 8, 2013 at 18:30
  • $\begingroup$ At step 6 was the name of your database listed in the database field? If it is not you haven't established a proper connection yet. Does your database have a password and user name? Just to clarify, your database should appear on the list of databases in the database field and you should be able to select it,is this what is happening? $\endgroup$
    – ERW
    Apr 9, 2013 at 10:06
  • $\begingroup$ my database doesn't have password and username.I field specific database name in Step 6,still it's not working. $\endgroup$
    – subbu
    Apr 9, 2013 at 11:45

1 Answer 1

Reset to default
2
$\begingroup$

Please refer to my answer here, it FINALLY works after struggling for almost a year. I hope this works for everyone else. I'd suggest completely ignoring the connection wizard and going the code route:

How to connect Mathematica 9 to MS SQL 2012 using Windows 7 enterprise (64-bit)

Improve this answer
$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.