下面是我用ADO连接ORACLE的程序,
Dim rs As ADODB.Recordset
Dim cnn As ADODB.Connection
Dim strcnn As String
strcnn = "Provider=OraOledb.Oracle.1;Password=manager;User ID=system;Data Source=ora9;Locale Identifier=2052"
Set cnn = New ADODB.Connection
cnn.Open strcnn并写了SQL语句,
dim sql as string
sql = "update TIMEDATA set temperature='" & myString1 & " ',pressure='" & myString2 & "',dif_pressure='" & myString3 & "'"
cnn.Execute sql请问在连接SQL Server2000的时候还要执行SQL语句,在上面的程序中要改动的是
strcnn = "Provider=OraOledb.Oracle.1;Password=manager;User ID=system;Data Source=ora9;Locale Identifier=2052"
它吗?如何改?(我的数据库名还是ora9)
Dim rs As ADODB.Recordset
Dim cnn As ADODB.Connection
Dim strcnn As String
strcnn = "Provider=OraOledb.Oracle.1;Password=manager;User ID=system;Data Source=ora9;Locale Identifier=2052"
Set cnn = New ADODB.Connection
cnn.Open strcnn并写了SQL语句,
dim sql as string
sql = "update TIMEDATA set temperature='" & myString1 & " ',pressure='" & myString2 & "',dif_pressure='" & myString3 & "'"
cnn.Execute sql请问在连接SQL Server2000的时候还要执行SQL语句,在上面的程序中要改动的是
strcnn = "Provider=OraOledb.Oracle.1;Password=manager;User ID=system;Data Source=ora9;Locale Identifier=2052"
它吗?如何改?(我的数据库名还是ora9)
如果连接SQL SERVER2000成功,在执行SQL语句的时候(如上面的)也应该没有问题吧?
SQL就是一种标准语言,对任何数据库都可以的