程序中用ADO 不用ODBC 建立到sql server 的连接?
很多有关ADO的文章都说到 用ADO访问远程数据,可以不需要配置ODBC数据源,可是本人在实际开发应用软件中,用ADO访问sql server 时,还是必须先在“ODBC数据源”管理程序中手工配置好ODBC驱动,再在VB程序中用类似如下连接串连接才能成功。
dim cnnb as As New ADODB.Connection
cnnb.ConnectionString ="PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=servera;DATABASE=pubs;UID=sa;PWD=yyuui"
cnnb.open请问如何才能不需先配置ODBC驱动,直接用ADO对象访问sql server数据库?请高手赐教,谢谢!
很多有关ADO的文章都说到 用ADO访问远程数据,可以不需要配置ODBC数据源,可是本人在实际开发应用软件中,用ADO访问sql server 时,还是必须先在“ODBC数据源”管理程序中手工配置好ODBC驱动,再在VB程序中用类似如下连接串连接才能成功。
dim cnnb as As New ADODB.Connection
cnnb.ConnectionString ="PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=servera;DATABASE=pubs;UID=sa;PWD=yyuui"
cnnb.open请问如何才能不需先配置ODBC驱动,直接用ADO对象访问sql server数据库?请高手赐教,谢谢!
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=数据库名;Data Source=服务器名
或者‘
//cnn.ConnectionString="provider=SQLOLEDB.1;Persist Security Info=true;User ID=sa;Password=;Initial Catalog=数据库名;data source=服务器名"
再定义Cn ,Rs ,SQLStr
Dim Cn As ADODB.Connection '# 连接ActiveConnection
Dim Rs As ADODB.Recordset
Dim SQLStr As String
'1.打开数据
Set Cn = New ADODB.Connection
'Set RS = New ADODB.Command
SQLStr = "Provider=SQLOLEDB.1;Persist Security " & _
"Info=False;Initial Catalog=" & _
"LYB" & ";Data Source=" & _
"BOBO" & ";User ID=" & _
"sa" & ";Password=" & _
"BOBO3111" & ";"
Cn.Open SQLStr
info=false
initial catalog=SQL服务器名
data sourec=数据库名
user id=登录的用户名
password =密码
完全可以,我用的就是这个.
不过他的调用是用
cn.excute sql
sql 是执行语句
sql="insert into~~~~"
等等
SQLCA.DBMS = xxx
SQLCA.Database = xxx
SQLCA.LogID = xxx
SQLCA.LogPass = xxx
SQLCA.ServerName = xxx
SQLCA.UserID = xxx
SQLCA.DBPass = xxx
SQLCA.Lock = xxx
SQLCA.DbParm = xxxConnect Using Sqlca;//编写ini文件
[Database]
DBMS="MSS Microsoft SQL Server 6.x"
UserId="lin"
DatabasePassword="lin"
LogPassword="lin"
LogId="lin"
DbParm=""
ServerName="172.16.9.28"
Database ="lin"
//在应用程序对象的OPEN事件中编辑代码
SQLCA.DBMS =ProfileString("ss.INI","Database","DBMS"," ")
SQLCA.Database =ProfileString("ss.INI","Database","DataBase"," ")
SQLCA.LogID =ProfileString("ss.INI","Database","LogID"," ")
SQLCA.LogPass =ProfileString("ss.INI","Database","LogPassword"," ")
SQLCA.ServerName =ProfileString("ss.INI","Database","ServerName"," ")
SQLCA.UserID =ProfileString("ss.INI","Database","UserID"," ")
SQLCA.DBPass =ProfileString("ss.INI","Database","DatabasePassword"," ")
SQLCA.Lock =ProfileString("ss.INI","Database","Lock"," ")
SQLCA.DbParm =ProfileString("pb.INI","Database","DbParm"," ")
connect using sqlca;
if sqlca.sqlcode<>0 then
messagebox("提示!","连接数据库失败!")
else
open(w_object)
end if