Hi,
Please don't double post. Here my answer again (in case somebody else
searches for this):
Sorry, you can not use "CIPHER=AES" in the ODBC connection string. This is
only allowed in the JDBC database URL.
You would need to set the database name to "GE04;CIPHER=AES", but I'm not
sure if this is possible or how to do it.
Or, as a workaround, you could start the PgServer with an undocumented
feature "key" that allows mapping of one database URL to another:
java org.h2.tools.Server -pg -key GE04 "~/temp/ge04;cipher=aes"
I will need to document this as follows:
To map an ODBC database name to a different JDBC database name, use the
option "-key" when starting the server. Please note only one mapping is
allowed. The following will map the ODBC database named "TEST" to the
database URL "jdbc:h2:~/data/test;cipher=aes":
java org.h2.tools.Server -pg -key TEST "~/data/test;cipher=aes"
Regards,
Thomas
On Thu, Sep 19, 2013 at 4:37 AM, Balaji M <[email protected]> wrote:
> Hi ,
>
> I have the same issue when connect to encrypted database . iam getting
> "Communication closed during authentication;Socket has been closed " error
> .
>
> Please help
> Connection string iam using
> "ODBC;DSN=;SERVER=localhost;DATABASE=GE04;CIPHER=AES;PORT=5435;UID=admin;PWD=abc123
> abc123;DRIVER={PostgreSQL Unicode}"
>
> Note : with out Encrypting the database i can connect.
>
> Thanks and Regards
> Balaji Manickam
>
> --
> You received this message because you are subscribed to the Google Groups
> "H2 Database" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To post to this group, send email to [email protected].
> Visit this group at http://groups.google.com/group/h2-database.
> For more options, visit https://groups.google.com/groups/opt_out.
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
