ASP - Oracle DB connection problem

Question

    dim sql
    set con = server.CreateObject ("adodb.connection")
    set rs_editorcolumn = server.CreateObject  ("adodb.recordset")
    set rs = server.CreateObject  ("adodb.recordset")
    mydsn =Application.Value ("dsn")

    con.Open (mydsn)  

This is my code..

It is working in another machine where it is deployed In my machine. It is showing following error

Error Type: Microsoft OLE DB Provider for Oracle (0x80004005) ORA-12170: TNS:Connect timeout occurred /lms/Default.asp, line 110

110 line is con.Open(mydsn);

Used Driver: Microsoft ODBC for Oracle

I have created my DSN systemDSN I have set my DSN name UserName Server

Please Provide me Solution for this issue