Passing special characters in passwords to iSeries ODBC Connection

I am attempting to use a VB.NET ODBC Connection to connect to an AS/400 iSeries database. I need to be able to pass special characters in users' passwords, but am getting an "Syntax error in connection string" because of the special characters in the password.

I have tried enclosing the password in {}.

I have tried enclosing the password in single quotes and double quotes.

I even read somewhere that you can use \ to enclose the password.

Nothing works.

I know it is the special characters causing problems -- =}; and maybe others.

Please help! Thanks ahead of time.

0 answers