Conn.Provider = "OraOLEDB.dbserver"
Conn.ConnectionString = "Data Source=oracle;User ID=news;Password=hayc;"
Conn.Provider = Application("cncjb_Provider")
Conn.ConnectionString = Application("cncjb_ConnectionString")
Conn.Open
为什么连不上去呢?我的主机名和例程名都是dbserver
---------------------------------------------------------------
1)OLE DB Provider for Oracle (from Microsoft)
1
2Dim oConn,strConn
3Set oConn=Server.CreateObject(“ADODB.Connection”)
4StrConn= "Provider=msdaora;" & _
5"Data Source=MyOracleDB;" & _
6"User Id=myUsername;" & _
7"Password=myPassword;"
8oConn.Open strConn
- OLE DB Provider for Oracle (from Oracle)
1
2Dim oConn,strConn
3Set oConn=Server.CreateObject(“ADODB.Connection”)
4StrConn= "Provider=OraOLEDB.Oracle;" & _
5"Data Source=MyOracleDB;" & _
6"User Id=myUsername;" & _
7"Password=myPassword;"
8oConn.Open strConn
---------------------------------------------------------------
那是数据库的驱动程序没有安装,请用WIN2000带的ODBC FOR ORACLE连接:
1
2Dim oConn,strConn
3Set oConn=Server.CreateObject(“ADODB.Connection”)
4StrConn="Driver={Microsoft ODBC for Oracle};" & _
5"Server=OracleServer.world;" & _
6"Uid=myUsername;" & _
7"Pwd=myPassword;"
8oConn.Open strConn