Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM ODBC Driver » View Thread |
Messages 1 to 1 of 1 total |
Escaping characters in table passwords in connection string |
Wed, May 25 2016 4:55 PM | Permanent 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 ; but neither has worked. Is there some secret to escaping these characters that I'm missing? |
This web page was last updated on Friday, March 29, 2024 at 03:30 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |