Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Connection string reserved characters

371849Nov 18 2002
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 23 2002
Added on Nov 18 2002
6 comments
2,431 views