ODBC with DSN:
<%
set conn=server.createobject("adodb.connection")
conn.cursorlocation=adUseClient ' requires use of adovbs.inc; numeric value is 3
conn.open "DSN=your_DSN_name;UID=kathi;PWD=xxxxxx"
%>
OLEDB
<%
set conn=server.createobject("adodb.connection")
conn.cursorlocation=adUseClient ' requires use of adovbs.inc; numeric value is 3
DSNTemp="Provider=MSDAORA.1;Password=xxxxx;User ID=kathi;Data Source=xxx.world"
conn.open DSNtemp
%>
espero te haya ayudado..salu2