Page 1 of 1
Rotate text and Image from DataSource MSSQL 2008 filestream
Posted: Sat Apr 07, 2012 7:46 am
by Taron133
1) Rotate text doesn't work
2) Image doesn't load from DataSource MSSQL 2008 (type column - varbinary(max), filestream)
Error 2032 - error connection, but in other case connections success.
Error 1085 - error 8)
I used mssql, FreeTDS and sqlsrv drivers. My project use sqlsrv driver.
Please help.
Rotate text and Image from DataSource MSSQL 2008 filestream
Posted: Mon Apr 09, 2012 10:21 am
by Vladimir
Hello,
1. Yes, this is a known problem, it is added to our to-do list.
2. We improved the MSSQL adapter, please see the attached archive.
Thank you.
Rotate text and Image from DataSource MSSQL 2008 filestream
Posted: Mon Apr 09, 2012 11:25 am
by Taron133
1) When expected to solve this problem?
2) MSSQL driver OK, but SQLSRV driver doesn't OK.
3)Can you please tell whether you can resize the image to the size of the area created?
Now I decide to buy your program, or I'll use the PDF without the bugs. Help me choose;)
Rotate text and Image from DataSource MSSQL 2008 filestream
Posted: Tue Apr 10, 2012 3:16 am
by Vladimir
Hello,
1. This is a difficult problem, a quick fix will not happen. Maybe in a few months.
2. Well, we'll check work with SQLSRV driver.
3. You can use the Stretch and Aspect Ratio properties of the Image component.
Thank you.
Rotate text and Image from DataSource MSSQL 2008 filestream
Posted: Tue Apr 10, 2012 4:52 am
by Taron133
1) Bad 8 (
2) When you check, write in this topic, please.
3) If I use Stretch and Aspect Ratio properties of the Image component: an image from the database with the dimensions 50x50 does not appear fully in the component 40x40. Most places do not have to do this. A picture in the database can not be changed.
Rotate text and Image from DataSource MSSQL 2008 filestream
Posted: Wed Apr 11, 2012 6:20 am
by Vladimir
Hello,
We could not reproduce the error with the images. Please send us a fragment of a database for testing.
Thank you.
Rotate text and Image from DataSource MSSQL 2008 filestream
Posted: Wed Apr 11, 2012 6:56 am
by Taron133
/*Вложенные документы*/
CREATE TABLE Docs(
GUID UNIQUEIDENTIFIER ROWGUIDCOL PRIMARY KEY DEFAULT NEWID(),
ID INT identity UNIQUE, /*для быстрого поиска внутри таблицы (и для использования в служебных целях при отладке)*/
filename NVARCHAR(100) NOT NULL,/*название документа*/
filesize INT NOT NULL,/*размер*/
LargeFile varbinary(max) FILESTREAM NOT NULL/*документ*/
) FILESTREAM_ON FileGroup;
extension=php_sqlsrv_53_ts_vc9.dll
MSSQL 2008
2) Sorry. The image doesn't loaded from the database.
Have errors with extension=php_sqlsrv_53_ts_vc9.dll driver:
Error 2032 - error connection, but in other case connections success.
Error 1085 - error
The response was written in a longer base64 string, after "LoadData".
Rotate text and Image from DataSource MSSQL 2008 filestream
Posted: Thu Apr 12, 2012 5:42 am
by Vladimir
Hello,
Please send us a backup file of your database fragment to support[at]stimulsoft.com for more detailed testing. Also, please include the product name and a link to this topic in the letter.
Thank you.