Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

When saving data type text in a field of type blob subtype 1, the information is being saved in binary form. [ODBC119] #116

Closed
firebird-automations opened this issue Apr 7, 2011 · 18 comments

Comments

@firebird-automations
Copy link

Submitted by: Roberto Carlos da Silva (robertosistemas)

Duplicates ODBC110

Attachments:
TestBlobFields.zip
Firebird_ODBC_2.0.1.152_x64.exe
Firebird_ODBC_2.0.1.152_Win32.exe
files_for_tests.zip
TestThreadSafe.zip

When saving data type text in a field of type blob subtype 1, the information is being saved in binary form.

with odbc driver Firebird_ODBC_1.2.0.69-Win32.exe it's work fine, but with new version Firebird_ODBC_2.0.0.151_Win32.exe, don't work

Commits: 9a2d48f 4c18cf4

@firebird-automations
Copy link
Author

Commented by: Roberto Carlos da Silva (robertosistemas)

I send a project for you reproduce the behavior

thanks

@firebird-automations
Copy link
Author

Modified by: Roberto Carlos da Silva (robertosistemas)

Attachment: TestBlobFields.zip [ 11943 ]

@firebird-automations
Copy link
Author

Modified by: Roberto Carlos da Silva (robertosistemas)

security: Developers [ 10012 ] =>

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

priority: Critical [ 2 ] => Major [ 3 ]

Version: 2.0.1 [ 10430 ] =>

Version: 2.1 Beta [ 10410 ] =>

@firebird-automations
Copy link
Author

Commented by: @alexpotapchenko

The attached driver for testing

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

Attachment: OdbcFb.zip [ 11961 ]

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.0.1 [ 10430 ]

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

Link: This issue duplicates ODBC110 [ ODBC110 ]

@firebird-automations
Copy link
Author

Commented by: Roberto Carlos da Silva (robertosistemas)

I tested the drive attached and now work fine!! thanks. You will publish new realease for download?

@firebird-automations
Copy link
Author

Commented by: @alexpotapchenko

>>You will publish new realease for download?
After 2.0.1 release only.

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

Attachment: Firebird_ODBC_2.0.1.152_x64.exe [ 12071 ]

Attachment: Firebird_ODBC_2.0.1.152_Win32.exe [ 12072 ]

@firebird-automations
Copy link
Author

Commented by: Roberto Carlos da Silva (robertosistemas)

Dear Alexander,

I installed the driver that you have attached the link ODBC119,
but now is giving an error that I believe is in the implementation of the driver version: Firebird_ODBC_2.0.1.152.
I am attaching the ticket ODBC119, some screens with the error,
and where the files are giving the error so you can check and correct the error.
I am also sending some links that might help you in solving the problem

http://dotnetdebug.net/2006/04/17/pinvoke-and-memory-related-issues/

http://dotnetdebug.net/category/pinvoke/

rename all file with extension .txt to .vb

thank you

@firebird-automations
Copy link
Author

Modified by: Roberto Carlos da Silva (robertosistemas)

Attachment: files_for_tests.zip [ 12081 ]

@firebird-automations
Copy link
Author

Commented by: @alexpotapchenko

Well, is it reproduce in 2.0.0.151 version?
I need to reproduce the problem under debugger.. Can you give me full test project sources for Visual Studio?

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

Attachment: OdbcFb.zip [ 11961 ] =>

@firebird-automations
Copy link
Author

Commented by: Roberto Carlos da Silva (robertosistemas)

some errors reported:

(1) System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

(2) ERROR [08S01] [ODBC Firebird Driver][Firebird]Error reading data from the connection.

(3) ERROR [HY000] [ODBC Firebird Driver][Firebird]request synchronization error.

The read error occurs when the option is not used thread-safe.
As a suggestion, it would be nice if the thread-safe option was enabled by default in the drive.
not passing the attribute SAFETHREAD = Y in the connection string.
because in most ODBC drivers are already thread-safe without any attribute.

@firebird-automations
Copy link
Author

Modified by: Roberto Carlos da Silva (robertosistemas)

Attachment: TestThreadSafe.zip [ 12094 ]

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment