i&#039;m new to asp.<BR>i want to beable to connect to my oracle database thru asp. my odbc settings are correct. i can connect to my oracle database with ms-access, sqlplus and excel. so i know that part works. i&#039;ve tried this code:<BR>&#060;!-- #include virtual = "..ssincludesadovbs.inc" --&#062;<BR>&#060;%<BR>strSQL="select * from server_data"<BR>set objDBConn= Server.createobject("adodb.connection")<BR>strConn = "driver={Microsoft ODBC for Oracle};dsn=cap;uid=capaplan;pwd=capaplan"<BR>objD BConn.Open strConn<BR>%&#062; <BR> <BR>when i try to load the page i get this message:<BR>Microsoft OLE DB Provider for ODBC Drivers error &#039;80004005&#039;<BR>[Microsoft][ODBC driver for Oracle][Oracle]ORA-12203: TNS:unable to connect to destination<BR>/db1a.asp, line 6<BR><BR>i&#039;ve done internet searches, and have also gone to bookstores and read and search. can anyone help me?<BR><BR>z<BR>