JDBC:ODBC connection, workgroup user & database password
Thomas Mayer
my mdb database is secured with a mdw-file and a database password. Now I
have problems to create a odbc connection string that includes both
passwords. Any ideas how that can be done ?
e.g.:
Driver={Microsoft Access Driver
(*.mdb)};DBQ=myaccessdb.mdb;Uid=myuser;Pwd=mypassword;SystemDB=myworkgroup.mdw;
that works perfectly when there is no additional database password on the
mdb file. But I need that password. Is there any way to add the database
password in the odbc connection string as well ?
Greetings, Thomas
David W. Fenton
news:i2u516$575$03$1...@news.t-online.com:
Everything you need to know here:
http://www.connectionstrings.com/access
Note, though, that database passwords are basically nothing but
"security theater" and really serve no useful purpose whatsoever.
--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/
Thomas Mayer
first of all, thanks for the answer - well, I know that site, but the
connection string provided there doesn't work. It seems that it is simply
not possible to have both, workgroup password and database password in an
odbc connection string. I really couldn't believe it but seems to be true.
So no way to connect to that database with Java... Anyone another idea ?!
Greets, Thomas
"David W. Fenton" <NoE...@SeeSignature.invalid> schrieb im Newsbeitrag
news:Xns9DC58864579ADf9...@74.209.136.98...
David W. Fenton
> first of all, thanks for the answer - well, I know that site, but
> the connection string provided there doesn't work. It seems that
> it is simply not possible to have both, workgroup password and
> database password in an odbc connection string. I really couldn't
> believe it but seems to be true. So no way to connect to that
> database with Java... Anyone another idea ?!
I don't know that ODBC supports database passwords.
But, again, database passwords are a massive waste of time, and you
shouldn't be using them in the first place.