data控件中的connect属性只能用ODBC;DSN='';UID=;PWD=连接数据库吗?
是不是可以把connect属性设置为:Driver={sql server};server='servername';
UID='sa';pwd=;database='databasename'?如果可以我怎么连接不上?
是不是可以把connect属性设置为:Driver={sql server};server='servername';
UID='sa';pwd=;database='databasename'?如果可以我怎么连接不上?
引用microsoft active data object 2.x
dim conn as new adodb.connection
dim conn as new adodb.recordsetconn.open "driver={SQL Server};server=yang;uid=sa;pwd=;ConnectionTimeout=0;database=northwind"
set rs=conn.execute("select * from table")
Dim myworkspace As Workspace
Set myworkspace = DBEngine.CreateWorkspace("myworkspace", "admin", " ", dbUseJet)
Dim data1 As Database
Set data1 = DBEngine.myworkspace(0).OpenDatabase("D:\Program Files\Microsoft Visual Studio\VB98\database\db1.mdb",False,False)