Trouble connection matlab 2013a to sql server 2012

I followed the procedure given in the URL below, but I still cannot get make the connection
I reference the "Microsoft SQL Server Authenticated Database Connection" under the "Examples" section.
below is the steps I took in order
1. I downloaded the file "sqljdbc_4.0.2206.100_enu" from microsoft.com and unziped the files to the following URL C:\Program Files\Microsoft SQL Server JDBC Driver 4.0
2. I opened matlab and used the following command "open('classpath')" and pasted the following URL into the end of the classpath text file C:\Program Files\Microsoft SQL Server JDBC Driver 4.0\sqljdbc_4.0\enu\sqljdbc4.jar
3. I opened matlab and used the following command "open('libraryclass')" and pasted the following URL into the end of the libraryclass path text file C:\Program Files\Microsoft SQL Server JDBC Driver 4.0\sqljdbc_4.0\enu\auth\x64
4. I then opened the following url C:\Program Files\Microsoft SQL Server JDBC Driver 4.0\sqljdbc_4.0\enu\xa and opened the file "xa_install.sql" which opened a sql query inside of the sql server management studio which I ran yielding the following output :
"SQLJDBC XA DLL installation script complete. Check for any error messages generated above." (there were no errors)
5. I then restarted matlab and used the following commands conn = database('Clinical_Data','','','com.microsoft.sqlserver.jdbc.SQLServerDriver','jdbc:sqlserver://servername:portnumber;database=Clinical_Data;integratedSecurity=true;')
ping(conn)
and I get the following error "Error using database/ping (line 105) Invalid connection."
I think I am missing some steps but this is all that I found on google. Any help with this matter will be much appreciated. Thank you for reading my Post!

Respuestas (0)

Productos

Etiquetas

Preguntada:

el 18 de Jul. de 2013

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by