# 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"];


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:

I click on New Button

Step 2:

I click on Next button.

Step 3:

Step 4:

here,I changed to SystemLevel.

Step 5:

but,I installed 2012 version .

Step 6:

Step 7:

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

Step 8:

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.

-
@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