Hi,
I'm trying to connect to an Oracle database.
The user enters his/her username and password.

The connection works great, as long as the user does not have special characters in his/her password. If the password contains certain special characters (not only quotation marks), the connection fails. Most of the times I get an error message, saying that my TNS connection string is wrong.

Here's my code:

Code:
oCn.Open("Driver={Microsoft ODBC for Oracle};" & _
                    "Server=" & server & ";" & _
                    "Uid=" & txtUser.Text & ";" & _
                    "Pwd=" & txtOldPW.Text)
What do I have to do so that a user could connect, for example, with a password of N@7pz+6? or even L"1p'7'1Av?


Thanks!