Trouble connection matlab 2013a to sql server 2012

1 view (last 30 days)
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!

Answers (0)

Tags

Products

Community Treasure Hunt

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

Start Hunting!