dim Conn as New ADODB.Connection Conn.Open "Provider=sqloracel;Data Source='" & Server & "';Initial Catalog=表名;User Id='" & User & "';Password='" & Password & "';" 我想这样就行吧! Conn.Open "Provider=sqloracel;Data Source='" & Server & "';Initial Catalog=表名;User Id='" & User & "';Password='" & Password & "';" 改个名就是SQL SERVER了!
可以用adodc连接oracle数据库啊。把他的 connectionsting 复制过来啊!
连sql server dim con as adodb.connection con.connectionstring =" driver ={sql server}; server= 192.168.0.1;database= pubs;uid=sa;pwd=111" con.open 假设 sql server 数据库在 192.168.0.1 的计算机上 ! 用户名是 sa 密码 是111
Conn.Open "Provider=sqloracel;Data Source='" & Server & "';Initial Catalog=表名;User Id='" & User & "';Password='" & Password & "';"
我想这样就行吧!
Conn.Open "Provider=sqloracel;Data Source='" & Server & "';Initial Catalog=表名;User Id='" & User & "';Password='" & Password & "';"
改个名就是SQL SERVER了!
dim con as adodb.connection
con.connectionstring =" driver ={sql server}; server= 192.168.0.1;database= pubs;uid=sa;pwd=111"
con.open
假设 sql server 数据库在 192.168.0.1 的计算机上 ! 用户名是 sa
密码 是111
建立一个ODBC连接,
connectionstring="DSN=YourDataSourceName;UID=YourUserID;PWD=YourPassword"如果要想用程序建立一个ODBC的话,你可以在CSDN上搜索一下,很多的!
sql="select * from [odbc;driver={microsoft odbc for oracle};server=服务器;uid=拥护;pwd=密码;].table"
用ADODC控件生成一个连接字符串, 然后把它复制下来,用adoCn.open "Provider=Microsoft……" 然后就可以了。