Connection string reserved characters
I'm using asp-pages and the oracle odbc-driver (8.1.7.6 I think) to query my Oracle DB.
I use following code :
myDSN="DSN=" & PAR_dbserver & ";uid=" & userid & ";pwd=" & pwd & ";"
set connec=server.createobject("adodb.connection")
connec.open myDSN
This works perfectly except in a few cases :
-> when pwd begins with a = or when it contains a ;
Both are explainable because these are being used to construct the connection string. My question is how do I use these characters so that my connection works (now I get a password incorrect).
I tried duplicating the characters ==, I tried %61, 0x3D, chr$(61) .... but all failed.
I searched oracle and google but nothing.
Any ideas greatly appreciated.
Stefaan Schepens
Siemens N.V.
Belgium