Rotate text and Image from DataSource MSSQL 2008 filestream

Taron133 · Post by **Taron133** » Sat Apr 07, 2012 7:46 am

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.

Post by **Vladimir** » Mon Apr 09, 2012 10:21 am

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.

Taron133 · Post by **Taron133** » Mon Apr 09, 2012 11:25 am

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;)

Post by **Vladimir** » Tue Apr 10, 2012 3:16 am

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.

Taron133 · Post by **Taron133** » Tue Apr 10, 2012 4:52 am

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.

Post by **Vladimir** » Wed Apr 11, 2012 6:20 am

Hello,

We could not reproduce the error with the images. Please send us a fragment of a database for testing.

Thank you.

Taron133 · Post by **Taron133** » Wed Apr 11, 2012 6:56 am

/*Вложенные документы*/
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".

Post by **Vladimir** » Thu Apr 12, 2012 5:42 am

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.