1. Darrin DiSimo
  2. Valentina Database ADK
  3. Friday, March 25 2022, 04:37 AM
  4.  Subscribe via email
I am new to Valentina. I am trying to access a Valentina server DB via ODBC. It works fine when I do not encrypt the DB, but when I encrypt the DB I get the following error:

[Paradigma Software][Valentina ODBC][Valentina engine](0x61502) Specified encryption key is wrong.

I am trying to open it with the following connection string:

Driver={Valentina ODBC Driver};Data Source=ODBCSource;Host=localhost;Port=15432;Database=testDB;UID=sa;PWD=sa;DataEncryptionKey=1234

I know I am using the correct Encryption key. When the DB is not encrypted it works fine. I have read through the documentation, but did not find anything in about how to specify the encryption key in the connection string.

I have tried different keywords for the encryption key (EncryptionKey, DataEncryptionKey, etc) with no luck.

Thank you in advance for any help.

Darrin DISimo
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hello Darrin,

Encryption is not supported in ODBC driver, I think we can add it in the next version.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 1
Ruslan Zasukhin Accepted Answer
Hi Darrin,

I wonder why you use ODBC for VServer?
some special language or some third-party tool?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 2
Darrin DiSimo Accepted Answer
Using VB6 so there is no direct interface to Valentina.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 3
Ruslan Zasukhin Accepted Answer
For VB6 we do have VCOM - this is exactly for VB6 product.
Please check it.

1) See URL to wiki below.

2) Interesting, in WIKI said:
Valentina COM is no longer updated as of Valentina Release 7.5.9 on Feb 9, 2018.

But I see vcom_12 in the release folder:
http://www.valentina-db.com/download/release/win_32
References
  1. http://valentina-db.com/docs/dokuwiki/v12/doku.php?id=valentina:products:adk:vcom:vcom
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 4
Darrin DiSimo Accepted Answer
Thank you. I will check out VCOM.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 5
Darrin DiSimo Accepted Answer
Thank you all for the information. I checked out VCOM, but it would probably require too much rewriting. Hopefully the next version of ODBC has the Encryption option.

Thank you.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 6
Sergey Pashkov Accepted Answer
ODBC Encryption is not ready yet but I'm working on it.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 7
Sergey Pashkov Accepted Answer
Hello Darrin,

I created a test build with two new encryption parameters:
DataEncryptionKey
StructureEncryptionKey

You can try it or wait for the next version.
Attachments (1)
References
  1. https://www.dropbox.com/s/6wrarn5tfu4wca0/vodbc_standalone_x64_12_win.exe?dl=0
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 8
Darrin DiSimo Accepted Answer
Sergey, thank you for the quick response and enhancement. I will download and try this.

Thank you very much.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 9
Darrin DiSimo Accepted Answer
Sergey,

Thanks again. Is there any way to get a 32-bit version of the ODBC driver? I am using VB6 and need the 32-bit driver.

Thank you,
Darrin
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 10
Sergey Pashkov Accepted Answer
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 11
Darrin DiSimo Accepted Answer
Sergey,

Thank you again for the quick response. I downloaded the 32bit ODBC driver and it is working with Encrypted databases.

Now the only issue I am having is that using ADO with the .fields("Column1";) construct is returning that data with trailing null's. So if the data in Column1 is "ABC", rs.fields("Column1";) returns "ABC<null><null><null>...". The number of nulls seem to be padded out to the size of the field.

Do you have any idea if this is a setting in ADO, ODBC, or somewhere else??

Thanks again,
Darrin
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 12
Sergey Pashkov Accepted Answer
What is the type of this field? VarChar?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 13
Darrin DiSimo Accepted Answer
Yes. The fields are VarChar.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 14
Sergey Pashkov Accepted Answer
As I remember the field buffers are created by the calling application, ADO in this case.
But is the string created from this data is correct?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 15
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories