DevOps, CI/CD and Automation

---cmd prompt------------------------

H:\>sqlplus scott/tiger

SQL*Plus: Release 10.2.0.3.0 - Production on Sun Mar 28 16:54:53 2010

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL>

-------------ASP -------------------------


<%@ Language="JScript" %>

<%

var uname=Request.Form("un");
var upwd=Request.Form("pwd");
Response.Write("User Name is " + uname + "<br>" + "password is " + upwd);
var sql = "select * from emp";
var conn = Server.CreateObject("ADODB.Connection");
var rs = Server.CreateObject("ADODB.Recordset");
conn.Open = "Driver={Oracle in OraDb10g_home1};DBQ=tcp;UID='uname';PWD='upwd';";
rs.Open(sql, conn, 3, 3);

%>


------------------Error------------------


User Name is scott
Password is tiger

Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'

[Oracle][ODBC][Ora]ORA-01017: invalid username/password; logon denied

/prc/main.asp, line 11

---------------------------------------
variable uname has valid username that is 'scott' and variable upwd as valid password ie 'tiger' both entered by the user.

with the same username and password i am able to connect to the database from the command prompt.

but when i tried using odbc through ASP(javascript) i am getting above error.

and one more thing if i mention username and password directly in UID and PWD it works but when i pass it through variables it wont work.
since variables have username and password it has to take from it directly...........manually i cant give,dynamically it has to take.


plz help me out....how i can pass the parameter to that UID and PWD.

conn.Open = "Driver={Oracle in OraDb10g_home1};DBQ=tcp;UID='uname';PWD='upwd';";


help plz

----------------

conn.Open = "Driver={Oracle in OraDb10g_home1};DBQ=tcp;UID='uname';PWD='upwd';"; --- does not work

conn.Open = "Driver={Oracle in OraDb10g_home1};DBQ=tcp;UID=scott;PWD=tiger;"; --- works

but i want the 1st statement to work........since user gives the password and username dynamically.

Thanks
Veeresh S