Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 1 of 1 total
Thread Escaping characters in table passwords in connection string
Wed, May 25 2016 4:55 PMPermanent Link

Sigma Assessment Systems, Inc.

I'm trying to access a DBISAM 4 database using the ODBC driver (4.39.00.03) from a .Net application (VS2013). I am able to access most of the tables in the database, but some of the tables have semi-colons, equal signs, quotes and double quotes in their passwords. I've not been able to figure out a way to escape these characters so that the connection string works.

Here's what I've got in my web.config:
<add name="TEST_ConnectionString" connectionString="DRIVER={DBISAM 4 ODBC Driver};ConnectionType=Remote;RemoteIPAddress=127.0.0.1;CatalogName=TESTDatabase;UID=TESTUser;PWD=Password;TablePassword1=1234567890;TablePassword2=ABCDEFGHIJ;TablePassword3=>2345;7890"/>

It works fine until I add the third table password. I've tried escaping the semi-colon in the third password with a \ and with &#59; but neither has worked. Is there some secret to escaping these characters that I'm missing?
Image