Take the 2-minute tour ×
Mathematica Stack Exchange is a question and answer site for users of Mathematica. It's 100% free, no registration required.

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.

share|improve this question
    
@PinguinDirk I tried that too also,still not connected for more information I will modify my question. –  subbu Apr 8 '13 at 11:41
    
@PinguinDirk ok..can You tell is it right,what I did in wizard. –  subbu Apr 8 '13 at 12:27
    
as it is all MSSQL (no longer mysql) now, I am of no help. will delete other comments –  Pinguin Dirk Apr 8 '13 at 18:30
    
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? –  ERW Apr 9 '13 at 10:06
    
my database doesn't have password and username.I field specific database name in Step 6,still it's not working. –  subbu Apr 9 '13 at 11:45
show 2 more comments

1 Answer

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)

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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