Home >Database >Mysql Tutorial >mssql2005字符串连接方法 避免无效的连接错误
mssql2005字符串连接方法 避免无效的连接错误
- WBOYOriginal
- 2016-06-07 18:06:271007browse
用ASPXspy自带的mssql连接字符串去连接数据库总是出现,DBNETLIB][ConnectionOpen (Invalid Instance()).]无效的连接
换了N种字符串连接的方法，终于连接上去了。共享下用的
Provider=SQLOLEDB.1; User ID=sa; Password=chouwazi.com; Data Source=127.0.0.1, 1433; Initial Catalog=master
Data Source=127.0.0.1, 1433 后的端口号必须填上 要不然链接不上。
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：sqlserver巧用row_number和partition by分组取top数据Next article：SQL server 视图（view）介绍