<script type="text/javascript">
</script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
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
__________________________________________________________________________
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
__________________________________________________________________________