[VB.NET]OLEDB.4.0连接ACCESS，怎么改成SQL SERVER数据库？
发布时间：2020-12-16 23:44:15 所属栏目：大数据 来源：网络整理
导读：OLEDB.4.0连接ACCESS，怎么改成SQL SERVER数据库？ 连接如下 Public isclose As Boolean Public username As String Public path As String = "provider=microsoft.jet.oledb.4.0;data source= " + Application.StartupPath + "/salary.mdb " 如何改成： Pub
|
OLEDB.4.0连接ACCESS，怎么改成SQL SERVER数据库？ 连接如下 Public isclose As Boolean Public username As String Public path As String = "provider=microsoft.jet.oledb.4.0;data source= " + Application.StartupPath + "/salary.mdb " 如何改成： Public path As String = "Driver={SQL Server};Database=gongzi;Server=127.0.0.1;uid=sa;pwd= " cnn.open path End Module __________________________________________________________________________ "Provider=sqloledb;Database=gongzi;Server=127.0.0.1;uid=sa;pwd= " __________________________________________________________________________ Provider=SQLOLEDB.1;Data Source=.;User ID=sa;Initial Catalog=DataBase; Password= __________________________________________________________________________ 修改是不是必须用 microsoft.jet.oledb.4.0 否则后面的都要改啊? 我可不会怎么该 __________________________________________________________________________ 自己顶下 __________________________________________________________________________ oledb 连接方式最好也改成sql __________________________________________________________________________ （编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |