Hi,
I have created a new table with 9 BLOB fields having compression property set to NO and Sub Type property set to Memo.
I want to update the table with data using an external program written in Visual Basic 6 and having ADO2.5
I have worked before with Image field types in SQL Server and with BLOB field types in Oracle Server by accessing them with ADO2.5 without having any problem at all.
So, I ran my program and update the table successfully, but (there is always a but) when I try to get a backup of the database from Navision 4.0 I get this error message:
The following ODBC error occurred:
Error: [Microsoft][ODBC Driver Manager] Invalid string or buffer length
State ID: HY090
What the heck is this message !!! ](*,)
kirkostas™
0
Comments
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
I received again the same error when I tried to backup my database.
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
What do you mean?
-Mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
BLOB field is a binary field and not a bmp or something.
If you look in the SQL Server you will see that the BLOB field is actually the "Image" field which is a binary field and you can store inside it whatever you want but in binary.
So it doesn't matter what I want to save in it. I know how to insert data in a binary field, inside and outside of navision, the problem is when I am filling data in this table I get this ODBC error message when I try to backup the database.
Maybe I misunderstood you previous question about the Image type.
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
Anyway I tried all of them without success.
I still got the ODBC error message when backup the database.
Thanks
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
files over NAv Client.
Has anyone has an idea why the odbc client cannot read files < 4 KB.
Or can I config my MDAC components to do so?