请教asp连接oracle的问题!

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   
  1. 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   
Published At
Categories with Web编程
comments powered by Disqus