oracle远程连接mysql命令,oracle 远程连接数据库指令,sqlplus 用户名/密码@();这条指令括号中该写什么内容...

方法一:

dim conn

set conn=server.createobject("ADODB.connection")

conn.open "PROVIDER=SQLOLEDB;DATA SOURCE=(local);UID=用户名;PWD=密码;DATABASE=数据库"

Set conn = Server.CreateObject("ADODB.Connection")

DSNtemp="DRIVER={SQL Server};SERVER=(local);UID=用户名;PWD=密码;DATABASE=数据库"

conn.open DSNtemp

%>

方法二:

option explicit

dim startime

dim conn

dim connstr

dim db,pass_word,User_ID,Data_Source

startime=timer()

db="数据库名称XK"

Pass_word="帐号密码123456"

User_ID="登陆帐号sa"

Data_Source="服务名称或者ip127.0.0.1"

Set conn = Server.CreateObject("ADODB.Connection")

connStr="Provider=SQLOLEDB.1;Password='"&pass_word&"';Persist Security Info=True;User ID='"&User_ID&"';Initial Catalog='"&db&"';Data Source='"&Data_Source&"'"

conn.Open connstr

function CloseDb

Conn.close

Set conn = Nothing

End Function

取消

评论