组态王开放数据库控件通过ODBC连接SQLSERVER数据库.doc

《组态王开放数据库控件通过ODBC连接SQLSERVER数据库.doc》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、.数据库SQLSERVER身份验证登录名sa密码sasa123（用windows身份登录，然后创建角色。以后统一都用这个登录名）如图所示创建XingYangDcs数据库..ODBC数据源配置：打开ODBC数据源管理器用户DSN点添加：..客户端配置......选择您希望连接的数据源：SqlServerNativeClient10.0第二步：配置DCS开放数据库ActiveX插件..第三步表的对应关系SQLCreateTable(DeviceID,"RealTimeDataTable1","SQL_SERVERTableTemplate1");//历史累计产量..SQLCreateTab

2、le(DeviceID,"RealTimeDataTable2","SQL_SERVERTableTemplate2");//白班产量SQLCreateTable(DeviceID,"RealTimeDataTable3","SQL_SERVERTableTemplate3");//晚班产量SQLCreateTable(DeviceID,"RealTimeDataTable4","SQL_SERVERTableTemplate4");//白班主机开机时间SQLCreateTable(DeviceID,"RealTimeDataTable5","SQL_SERVERTableTempla

3、te5");//晚班主机开机时间SQLCreateTable(DeviceID,"RealTimeDataTable6","SQL_SERVERTableTemplate6");//日产量SQLCreateTable(DeviceID,"RealTimeDataTable7","SQL_SERVERTableTemplate7");//月产量表SQLCreateTable(DeviceID,"RealTimeDataTable8","SQL_SERVERTableTemplate8");//主机电流记录表SQLCreateTable(DeviceID,"RealTimeDataTabl

4、e9","SQL_SERVERTableTemplate9");//日开机时间表SQLCreateTable(DeviceID,"RealTimeDataTable10","SQL_SERVERTableTemplate10");//月开机时间表.