比如连接?查询?
解决方案 »
- MsgBox被至顶窗体盖住,如何用API的messagebox函数将MsgBox也至顶?
- 能否用 set FRM = txtFRMNAME 这样的方式来调用某个窗体
- ACCESS与SQL数据表结构及简繁互转问题!
- 逐行处理文本文件时,如何转到下一行,菜鸟急救!!!
- 如何设置显示EXCEL饼图显示百分比例?
- 关于vb中生成弹出窗口并操作
- 急急急....,关于VB中用MSCOMM通信的问题!
- 你知道如何获得系统那个“internet临时文件夹”吗?
- 关于“视频”的问题?来着有份。
- 哪里有《VB5插件开发指南》啊,我急用啊!!!!!!!!
- 急!求sharpgrid (datadynamic 公司) 2.0版的注册码
- 唉,如果这个功能实现,我的正式处子之作就算比较完美了,望专家来看看
Dim rs As New ADODB.Recordset
Dim conn As New ADODB.Connection
Dim str As String
Dim connstr As String
connstr = "Provider=SQLOLEDB.1;Integrated Security=SSPI;" & "Persist Security Info=False;Initial Catalog=" _
& DATABASE_NAME & ";Data Source=" & SERVER_NAME
conn.Open connstr
rs.Open TABLE_NAME,conn, adOpenStatic, adLockOptimistic
ODBC Driver for MySQL (via MyODBC)
To connect to a local database
Conn.Open "Driver={mySQL};" & _
"Server=MyServerName;" & _
"Option=16834;" & _
"Database=mydb;"
To connect to a remote database
Conn.Open "Driver={mySQL};" & _
"Server=db1.database.com;" & _
"Port=3306;" & _
"Option=131072;" & _
"Stmt=;" & _
"Database=mydb;" & _
"Uid=myUsername;" & _
"Pwd=myPassword;"
Dim connstr As String
connstr = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog= 数据库名;Data Source=服务器名
Conn.Open connstr,"sa","sa的登陆密码"
Dim conn As New ADODB.Connection
Dim str As String
Dim connstr As String
connstr = "Provider=SQLOLEDB.1;Integrated Security=SSPI;" & "Persist Security Info=False;Initial Catalog=" _
& DATABASE_NAME & ";Data Source=" & SERVER_NAME
conn.Open connstr
rs.Open TABLE_NAME,conn, adOpenStatic, adLockOptimistic