matlab连接SQLServer数据库 教程

matlab连接SQLServer数据库 教程

连接教程

1.在windows搜索中搜索并打开 windows管理工具
windows管理工具
2.打开ODBC Data Sources(64-bit) #32 与 64 最好都操作一遍,以此来保证各种软件都能兼容
在这里插入图片描述
3.添加用户数据源 选择SQL Server
在这里插入图片描述
4.给自己的数据库起个名字 在这里插入图片描述
服务器:打开sql server软件中,把自己服务器的名称复制过去
在这里插入图片描述
5.然后一直下一步到完成,再测试一下数据源就成功添加了
在这里插入图片描述
在这里插入图片描述
6.matlab测试

conna2 = database('mysql','','')

在打印出来的信息里能看到自己的数据库信息就成功了.

已标记关键词 清除标记
c#编写 matlab连接sqlserver,程序运行五分钟就会报下面的错,为什么错误里会有java什么的,难道跟我装了java有关吗?望指教,多谢!! Mar 26, 2017 2:08:42 PM com.microsoft.sqlserver.jdbc.TDSChannel enableSSL INFO: java.security path: D:\Program Files (x86)\MATLAB\R2013a\sys\java\jre\win64\jre\lib\security Security providers: [SUN version 1.6, SunRsaSign version 1.5, SunJSSE version 1.6, SunJCE version 1.6, SunJGSS version 1.0, SunSASL version 1.5, XMLDSig version 1.0, SunPCSC version 1.6] SSLContext provider info: Sun JSSE provider(PKCS12, SunX509 key/trust factories, SSLv3, TLSv1) SSLContext provider services: [SunJSSE: KeyFactory.RSA -> sun.security.rsa.RSAKeyFactory aliases: [1.2.840.113549.1.1, OID.1.2.840.113549.1.1] , SunJSSE: KeyPairGenerator.RSA -> sun.security.rsa.RSAKeyPairGenerator aliases: [1.2.840.113549.1.1, OID.1.2.840.113549.1.1] , SunJSSE: Signature.MD2withRSA -> sun.security.rsa.RSASignature$MD2withRSA aliases: [1.2.840.113549.1.1.2, OID.1.2.840.113549.1.1.2] , SunJSSE: Signature.MD5withRSA -> sun.security.rsa.RSASignature$MD5withRSA aliases: [1.2.840.113549.1.1.4, OID.1.2.840.113549.1.1.4] , SunJSSE: Signature.SHA1withRSA -> sun.security.rsa.RSASignature$SHA1withRSA aliases: [1.2.840.113549.1.1.5, OID.1.2.840.113549.1.1.5, 1.3.14.3.2.29, OID.1.3.14.3.2.29] , SunJSSE: Signature.MD5andSHA1withRSA -> com.sun.net.ssl.internal.ssl.RSASignature , SunJSSE: KeyManagerFactory.SunX509 -> com.sun.net.ssl.internal.ssl.KeyManagerFactoryImpl$SunX509 , SunJSSE: KeyManagerFactory.NewSunX509 -> com.sun.net.ssl.internal.ssl.KeyManagerFactoryImpl$X509 , SunJSSE: TrustManagerFactory.SunX509 -> com.sun.net.ssl.internal.ssl.TrustManagerFactoryImpl$SimpleFactory , SunJSSE: TrustManagerFactory.PKIX -> com.sun.net.ssl.internal.ssl.TrustManagerFactoryImpl$PKIXFactory aliases: [SunPKIX, X509, X.509] , SunJSSE: SSLContext.SSL -> com.sun.net.ssl.internal.ssl.SSLContextImpl , SunJSSE: SSLContext.SSLv3 -> com.sun.net.ssl.internal.ssl.SSLContextImpl , SunJSSE: SSLContext.TLS -> com.sun.net.ssl.internal.ssl.SSLContextImpl , SunJSSE: SSLContext.TLSv1 -> com.sun.net.ssl.internal.ssl.SSLContextImpl , SunJSSE: SSLContext.Default -> com.sun.net.ssl.internal.ssl.DefaultSSLContextImpl , SunJSSE: KeyStore.PKCS12 -> com.sun.net.ssl.internal.pkcs12.PKCS12KeyStore ] java.ext.dirs: D:\Program Files (x86)\MATLAB\R2013a\sys\java\jre\win64\jre\lib\ext;C:\windows\Sun\Java\lib\ext conn = Instance: 'UDN' UserName: 'vsp'
©️2020 CSDN 皮肤主题: 数字20 设计师:CSDN官方博客 返回首页