关于用odbc连接oracle的问题。。。

[wsmall]

谁能告诉我那个连接语句怎么写？
就是 conn.open ...

我的odbc的文件名称叫Test..

[liuzxit]

don' use ODBC,use OLEDB

oConn.Open "Provider=msdaora;" & _
"Data Source=MyOracleDB;" & _
"User Id=myUsername;" & _
"Password=myPassword"

or

oConn.Open "Provider=OraOLEDB.Oracle;" & _
"Data Source=MyOracleDB;" & _
"User Id=myUsername;" & _
"Password=myPassword"

[whb147]

<%
set conn=server.createobject("adodb.connection")
conn.cursorlocation=adUseClient
DSNTemp="Provider=MSDAORA.1;Password=xxxxx;User ID=yanhang;Data Source=xxx.world"
conn.open DSNtemp
%>

[flygoocn]

偶用javascript结果死活就是连不上数据库