用数据视图窗口吧,点菜单视图-数据视图窗口,或工具栏的黄色的按钮右键,数据链接,添加数据链接 选Microsoft OLE DB Provider for SQL Server 下一步, 服务器名称,输入机器名或IP地址 输入用户名(默认sa)密码(默认空) 选择要连接的数据库, 点确定
select * from openrowset('sqloledb','sprogram';'develop';'11111','select * from kind') select * from openrowset('sqloledb','190.1.1.247';'develop';'11111','select * from kind')select * from opendatasource('sqloledb','data source=sprogram;user ID=develop;Password=11111').new_ks.dbo.kind
Private Sub Form_Load() Dim strConn As String Dim pubConn As New ADODB.Connection Dim rsTable As New ADODB.Recordset Dim strSQL As String 'Access 2000的連接 strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\North.mdb;Persist Security Info=False" 'SQL Server2000的連接 strConn = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=develop; password=12345;Data Source=ServerName" pubConn.Open strConn rsTable.CursorLocation = adUseClient strSQL = "select * from TableName" rsTable.Open strSQL, pubConn, adOpenDynamic, adLockOptimistic Set DataGrid1.DataSource = rsTableEnd Sub
选Microsoft OLE DB Provider for SQL Server
下一步,
服务器名称,输入机器名或IP地址
输入用户名(默认sa)密码(默认空)
选择要连接的数据库,
点确定
select * from openrowset('sqloledb','190.1.1.247';'develop';'11111','select * from kind')select * from opendatasource('sqloledb','data source=sprogram;user ID=develop;Password=11111').new_ks.dbo.kind
Dim strConn As String
Dim pubConn As New ADODB.Connection
Dim rsTable As New ADODB.Recordset
Dim strSQL As String 'Access 2000的連接
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\North.mdb;Persist Security Info=False"
'SQL Server2000的連接
strConn = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=develop; password=12345;Data Source=ServerName"
pubConn.Open strConn rsTable.CursorLocation = adUseClient
strSQL = "select * from TableName"
rsTable.Open strSQL, pubConn, adOpenDynamic, adLockOptimistic
Set DataGrid1.DataSource = rsTableEnd Sub
什么是visdata,在odbc数据源中建立数据源后,怎样使用???????
感谢各位大侠,以上问题解决候马上结贴!!!!!!!!!!!!!!
谢谢 viena(维也纳nn-实心木头人石欠RUKYO)我已经成功加入sql数据库了,用你的方法
但我不会使用,能用文本框为例教我怎没用好吗:)谢谢了!!
绑定?
你到底是管理、查看数据,还是编程啊?
我编程是写代码实现的,从来不用绑定
数据库编程用ADO对象,建议楼主还是找本书系统地学一学吧~
看到了吗???