请问:ASP如何正确连接Oracle9i?

2006-07-26 04:07:33 503 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

光模块深度拆解：从外壳到光学引擎的硬核解析光模块是数据中心与通信网络中实现光电转换的核心器件，其本质是集光学、电子、热学、机械与协议于一体的精密系统。理解其工作原理需从基础物理层切入：激光器类型（如DFB、VCSEL）决定波长与效率，调制格式（PAM4/NRZ）影响信噪比与带宽利用率，封装形态（OSFP/QSFP-DD）约束散热与互操作性，而CMIS协议与DDM监控则赋予模块可管理性。技术价值体现在高密度互联、低功耗演进与智能运维能力；典型应用场景覆盖数据中心短距DR8、城域网FR4/LR4及骨干网ZR等分级链路。本文以800G OSFP模块为实物阅读详情

WEB服务器:WIN2003+IIS6.0

数据库服务器:WIN2003+Oracle9i

我已经在WEB服务器安装Oracle9i客户端,测试能连接到数据库服务器.

ASP用OLEDB方式连接Oracle

连接字符串如下:

<%

Dim conn
set conn=server.createobject("adodb.connection")
conn.Open "Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=libsys;Password=libsys;Data Source=orcl"
Set rs=Server.CreateObject("ADODB.Recordset")

%>

问题是现在连接特别慢,我等了一分钟也没有任何提示.

...全文

800G光模块FA与MT插芯深度拆解解析光纤阵列（FA）和MT插芯是800G高速光互连的核心物理层组件，其亚微米级定位精度、热应力匹配设计与三维机械稳定性，直接决定PAM4信号在数据中心内的误码率、OSNR余量与长期可靠性。FA并非简单光纤排列，而是融合陶瓷基板、V型槽工艺、梯度UV固化与背面应力补偿结构的精密光学机械系统；MT插芯也不仅是多芯连接器，实为具备双销阶梯孔锁止、应力释放槽与CTE匹配特性的重复定位引擎。这些技术共同支撑AI训练集群中万亿参数模型的低延迟梯度同步，广泛应用于OSFP/CPO架构的交换机、智能网卡与共封装光学模块。本文聚阅读详情

heijunma

ASP 28,401 成员 356,940 内容

+ 关注 + 加入社区

切换为时间正序

littlelam 2006-07-31

打赏
举报

Oracle
ODBC

New version:

"Driver={Microsoft ODBC for Oracle};Server=OracleServer.world;Uid=Username;Pwd=asdasd;"

Old version:

"Driver={Microsoft ODBC Driver for Oracle};ConnectString=OracleServer.world;Uid=myUsername;Pwd=myPassword;"

OLE DB, OleDbConnection (.NET)

Standard security:

"Provider=msdaora;Data Source=MyOracleDB;User Id=UserName;Password=asdasd;"
This one's from Microsoft, the following are from Oracle
Standard Security:

"Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=Username;Password=asdasd;"

Trusted Connection:

"Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;"

OracleConnection (.NET)

Standard:

"Data Source=MyOracleDB;Integrated Security=yes;"
This one works only with Oracle 8i release 3 or later
Specifying username and password:

"Data Source=MyOracleDB;User Id=username;Password=passwd;Integrated Security=no;"
This one works only with Oracle 8i release 3 or later
Declare the OracleConnection:

C#:
using System.Data.OracleClient;
OracleConnection oOracleConn = new OracleConnection();
oOracleConn.ConnectionString = "my connection string";
oOracleConn.Open();

VB.NET:
Imports System.Data.OracleClient
Dim oOracleConn As OracleConnection = New OracleConnection()
oOracleConn.ConnectionString = "my connection string"
oOracleConn.Open()

Core Labs OraDirect (.NET)

Standard:
"User ID=scott; Password=tiger; Host=ora; Pooling=true; Min Pool Size=0;Max Pool Size=100; Connection Lifetime=0"

Data Shape

MS Data Shape:
"Provider=MSDataShape.1;Persist Security Info=False;Data Provider=MSDAORA;Data Source=orac;user id=username;password=mypw"

impeller 2006-07-31

打赏
举报

<%
Dim conn
set conn=server.createobject("adodb.connection")
conn.Open "Provider=MSDAORA.1;User ID=libsys;Password=libsys;Data Source=orcl"
Set rs=Server.CreateObject("ADODB.Recordset")
%>

heijunma 2006-07-31