UC知道如何实现连接sql？？
来源：百度知道 编辑：UC知道 时间：2024/06/21 01:04:09
我的sql连接信息是provider=sqloledb;data source=222.184.121.7,1433;User ID=a1128151057;
pwd=a123456;Initial Catalog=a1128151057
Class dboperation
private loveconnstr
private loveconn
public CommandType
public CommandTable
private parameters_keys()
private parameters_values()
private filters()
private iparam
private ifilter
private Sub Class_Initialize()
strSQLServer="NYINFO12-DZ5SJA"
strSQLUser="sq_caopeng"
strSQLPassword="020310"
strSQLDataBase="sq_caopeng"
loveconnstr = "Driver={SQL Server};server=" & strSQLServer & ";UID=" & strSQLUser & ";PWD=" & strSQLPassword & ";database=" & strSQLDataBase & ""
set loveconn = Server.Createobject("ADODB.Connection")
loveconn.Open loveconnstr
CommandType=0
pwd=a123456;Initial Catalog=a1128151057
Class dboperation
private loveconnstr
private loveconn
public CommandType
public CommandTable
private parameters_keys()
private parameters_values()
private filters()
private iparam
private ifilter
private Sub Class_Initialize()
strSQLServer="NYINFO12-DZ5SJA"
strSQLUser="sq_caopeng"
strSQLPassword="020310"
strSQLDataBase="sq_caopeng"
loveconnstr = "Driver={SQL Server};server=" & strSQLServer & ";UID=" & strSQLUser & ";PWD=" & strSQLPassword & ";database=" & strSQLDataBase & ""
set loveconn = Server.Createobject("ADODB.Connection")
loveconn.Open loveconnstr
CommandType=0
1433 这是什么意思哦
一般数据库的链接不使用oledb链接，它的可移植性很差。
odbc链接
conn.open"driver=SQL"database="数据库名称"；server=服务器地址（localhost）;uid=;pwd="