Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dk
Starting Member
35 Posts |
 Posted - 2009-01-25 : 08:10:06
|
| Hi all,I lost a few week discovering that I can use data from one table from my database but can't from another in data connection in my infopath 2007 form. I am using the same form, the same data connections. The error message I got is: Not enough storage is available to complete this operation. First I was thinking it's because there are a lot of entities in the table, but I tried to read data from even bigger tables from another database with no mistakes. Now, I am out of any idea why it's happening, so would be very grateful for any help. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-01-25 : 08:12:49
|
I think it is not a matter of number of records in table. I think it is rowsize that matters.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
dk
Starting Member
35 Posts |
Posted - 2009-01-25 : 08:18:36
|
| I am very new in sql, so would be nice if you can explain more about rowsize. |
|
|
|
dk
Starting Member
35 Posts |
Posted - 2009-01-25 : 08:29:43
|
| Thanks for help. I removed the pictures from the data connection and now I can get all items.Still, would be nice to know how to get pictures... |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-01-25 : 08:56:05
|
Rowsize (or recordsize) is the sum of datatype sizes used in the query across the record (row).Pictures (and other BLOBs) are stored temporarily during presentation on the server's temp catalog.See the available space in the drive that holds the temp catalog.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
Problem with data connections from Infopath