Performance Issues

Jun 3, 2010 at 2:04 AM

Using Agent 6 against the old Microsoft newsgroups the time to download new headers and bodies was a function of the number of new headers and bodies available.

Using Agent 6 against the Microsoft forums via the Community NNTP bridge the time to download new headers and bodies appears to be dependent on how many old messages there are.

For example it takes approximately the same amount of time to download new headers and bodies from microsoft.public.access newsgroup wihich has a large number of old messages as it does to download new headers and bodies from the microsoft.public.access.security newgroups which has about 1/30 as many old messages.

It takes 17 miinutes to downlaod 2 new headers and bodies from Msdn en-US.vsto and under a minute to download one new header and body from Msdn en-US.oxmlsdk which is about 1/20 the size.

These measurements are for the first downloads after starting the bridge.  Subsequent downloads are fairly fast even for large forums.  It appears that the bridge is actually checking all headers in the forums instead of pulling ones created after the last one already stored in Agent.  Then it caches the information so subsequent downloads only pull new headers.  The server creates messasges out of order is unchecked in Agent so it should be asking for all headers after the last one it got.  But this does not appear to be what the bridge does.

Coordinator
Jun 3, 2010 at 5:58 AM

I cannot repro this problem.  Can you enable the debug with and show, what agent is psoting to the NNTP server? And post the reults here?

Normally it should take less than a second to check of new messages...

Jun 3, 2010 at 6:45 AM

I opened the debug window and checked everything and then selected the VSTO forum and clicked on download headers.  My options in Agent are set to download all bodies for new headers.

I am watching what looks like every message in the forum flying past.  I cannot post the enter thing here without being banned.  I would upload a zipped archive but there doesn't appear to be an option to upload a file.   I will therefore post the begining of the debug windows -- assuming it doesn't run out of space and lose the start of the process.

Jun 3, 2010 at 6:58 AM

I had to stop Agent and then kill the bridge because it was still downloading.

I then started the bridge and opened the debug window and check everything.  Then I started agent, selected the accessdev forum which only had a few postings and click on download headers for the selected newsgroup -- there was one new one.  It appears that all messages are being downloaded.  Here is the begining of the debug window:

ClientConnected: 1
ClassifyCommand: MODE READER
Received: Command: MODE, Parameters: READER
Received: Response: 200 Community Forums Bridge News Server Ready - posting allowed

 

ClassifyCommand: XFEATURE COMPRESS GZIP TERMINATOR
ClassifyCommand: Command unknown: Command: XFEATURE, Parameter: COMPRESS GZIP TERMINATOR
Received: Command: NOTRECOGNISED, Parameters: READER
Received: Response: 500 command not recognised

 

ClassifyCommand: GROUP Msdn.en-US.accessdev
Received: Command: GROUP, Parameters: Msdn.en-US.accessdev
Received: Response: 211 140 1 140 Msdn.en-US.accessdev group selected

 

ClassifyCommand: LISTGROUP Msdn.en-US.accessdev
ClassifyCommand: Command unknown: Command: LISTGROUP, Parameter: Msdn.en-US.accessdev
Received: Command: NOTRECOGNISED, Parameters: Msdn.en-US.accessdev
ClassifyCommand: XHDR LINES 1-140
Received: Command: XHDR, Parameters: LINES 1-140
RawBody <06da335f-8fae-4fe8-a31f-57629dc8a032@communitybridge.codeplex.com>:
<p>Hi all,</p>
<p>I would like to know, what's the connection string in order to connect to an Access 2010 Database through c#?</p>
<p>&nbsp;</p>
<p>Thanks in advance,</p>
<p>Alex</p>
FromWeb: Body <06da335f-8fae-4fe8-a31f-57629dc8a032@communitybridge.codeplex.com> after conversion:

 


Hi all,

 

I would like to know, what's the connection string in order to connect to an Access 2010 Database through c#?

 

 

 

Thanks in advance,

 

Alex
RawBody <b69998fe-1685-41c3-b7fa-23ee3b251ee9@communitybridge.codeplex.com>:
<p>Take a look here:</p>
<p><a href="http://www.connectionstrings.com/access-2007http://www.connectionstrings.com/access-2007">http://www.connectionstrings.com/access-2007</a></p>
<p>and then change te 12 into a 14 and see if that does the trick...</p>
<p>Maurice</p>
FromWeb: Body <b69998fe-1685-41c3-b7fa-23ee3b251ee9@communitybridge.codeplex.com> after conversion:

 


Take a look here:

 

http://www.connectionstrings.com/access-2007

 

and then change te 12 into a 14 and see if that does the trick...

 

Maurice
RawBody <e3de97fc-a36b-4de8-a190-f6916bc47ba4@communitybridge.codeplex.com>:
<p>Just an FYI, the doc at the web site is in error. Continue to use 12.0 as the version for the ACE OLEDB Provider (and Excel as well).<br/>
<br/>
If Office or Access is not installed you will need the following:</p>
<p><a href="http://www.microsoft.com/downloads/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B371EDE16D&amp;displaylang=en

http://www.microsoft.com/downloads/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en">http://www.microsoft.com/downloads/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B371EDE16D&amp;displaylang=en</a></p><hr class="sig">Paul ~~~~ Microsoft MVP (Visual Basic)
FromWeb: Body <e3de97fc-a36b-4de8-a190-f6916bc47ba4@communitybridge.codeplex.com> after conversion:

 


Just an FYI, the doc at the web site is in error. Continue to use 12.0 as the version for the ACE OLEDB Provider (and Excel as well).

 

If Office or Access is not installed you will need the following:

 

http://www.microsoft.com/downloads/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en

 

--
Paul ~~~~ Microsoft MVP (Visual Basic)
RawBody <0b7599d8-6414-475d-a375-47cedfe73bbb@communitybridge.codeplex.com>:
<p>Hello there, I am developing a simple application in Access that allows the user to print out vouchers. The following query selects the top voucher that has not yet been sold:</p>
<p>SELECT TOP 1 *<br/>
FROM Vouchers<br/>
WHERE Vouchers.Group=&quot;1 Day&quot; And Status=&quot;Unsold&quot;;</p>
<p>It is used to generate a report that has a print button. Once the user clicks the print button, I would like the status of the voucher to change to sold. I'm not sure what the best approach to this is but I have attempted to retrieve the serial number of
 the printed voucher and use an update query to change the status attribute using VBA. This is what I did:</p>
<p>&nbsp;</p>
<p>&nbsp;&nbsp;&nbsp; Function ChangeStatus() As Boolean<br/>
<br/>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dim db As Database<br/>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dim changedStatus As String<br/>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dim statusMsg As String<br/>
<br/>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; On Error GoTo Err_Execute<br/>
<br/>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Set db = CurrentDb()<br/>
<br/>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Re-Assign Date to TransactionDate<br/>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; changedStatus = &quot;update [Vouchers]&quot;<br/>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; changedStatus = changedStatus &amp; &quot; set [Status] = #&quot; &amp; sold &amp; &quot;#&quot;<br/>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; changedStatus = changedStatus &amp; &quot; where [Vouchers.Serial] = #&quot; &amp; Serial.Text &amp; &quot;#&quot;<br/>
<br/>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; db.Execute changedStatus, dbFailOnError<br/>
<br/>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Set db = Nothing<br/>
<br/>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MsgBox &quot;Changing the Status was Successful.&quot;<br/>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ChangeStatus = True<br/>
<br/>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; On Error GoTo 0<br/>
<br/>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Exit Function<br/>
<br/>
Err_Execute:<br/>
<br/>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MsgBox &quot;Updating the status failed&quot;<br/>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ChangeStatus = False<br/>
<br/>
&nbsp;&nbsp;&nbsp; End Function<br/>
</p>
<p>&nbsp;</p>
<p>Private Sub CmdPrint_Click()<br/>
<br/>
Dim ChangeStatus As String<br/>
<br/>
<br/>
<br/>
&nbsp;&nbsp;&nbsp; On Error GoTo ErrorHandler<br/>
&nbsp;&nbsp;&nbsp; <br/>
&nbsp;&nbsp;&nbsp; 'DoCmd.OpenReport &quot;1 Day&quot;, acViewPreview<br/>
&nbsp;&nbsp;&nbsp; <br/>
&nbsp;&nbsp;&nbsp; 'Opens print dialog for current screen (report in this case):<br/>
&nbsp;&nbsp;&nbsp; DoCmd.RunCommand acCmdPrint<br/>
<br/>
ErrorHandler:<br/>
&nbsp;&nbsp;&nbsp; If Err.Number &lt;&gt; 0 And Err.Number &lt;&gt; 2501 Then<br/>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MsgBox &quot;Error: &quot; &amp; Err.Number &amp; vbNewLine &amp; Err.Description<br/>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Exit Sub<br/>
&nbsp;&nbsp;&nbsp; End If</p>
<p>Call ChangeStatus<br/>
</p>
<p>End Sub<br/>
</p>
<p>&nbsp;</p>
<p>Please help me!!!</p>
FromWeb: Body <0b7599d8-6414-475d-a375-47cedfe73bbb@communitybridge.codeplex.com> after conversion:

 


Hello there, I am developing a simple application in Access that allows the user to print out vouchers. The following query selects the top voucher that has not yet been sold:

 

SELECT TOP 1 *
FROM Vouchers
WHERE Vouchers.Group="1 Day" And Status="Unsold";

 

It is used to generate a report that has a print button. Once the user clicks the print button, I would like the status of the voucher to change to sold. I'm not sure what the best approach to this is but I have attempted to retrieve the serial number of the printed voucher and use an update query to change the status attribute using VBA. This is what I did:

 

 

 

    Function ChangeStatus() As Boolean

 

        Dim db As Database
        Dim changedStatus As String
        Dim statusMsg As String

 

        On Error GoTo Err_Execute

 

        Set db = CurrentDb()

 

        'Re-Assign Date to TransactionDate
        changedStatus = "update [Vouchers]"
        changedStatus = changedStatus & " set [Status] = #" & sold & "#"
        changedStatus = changedStatus & " where [Vouchers.Serial] = #" & Serial.Text & "#"

 

        db.Execute changedStatus, dbFailOnError

 

        Set db = Nothing

 

        MsgBox "Changing the Status was Successful."
        ChangeStatus = True

 

        On Error GoTo 0

 

        Exit Function

 

Err_Execute:

 

        MsgBox "Updating the status failed"
        ChangeStatus = False

 

    End Function

 


 

 

Private Sub CmdPrint_Click()

 

Dim ChangeStatus As String

 

 

 

    On Error GoTo ErrorHandler
   
    'DoCmd.OpenReport "1 Day", acViewPreview
   
    'Opens print dialog for current screen (report in this case):
    DoCmd.RunCommand acCmdPrint

 

ErrorHandler:
    If Err.Number <> 0 And Err.Number <> 2501 Then
        MsgBox "Error: " & Err.Number & vbNewLine & Err.Description
        Exit Sub
    End If

 

Call ChangeStatus

 


End Sub

 


 

 

Please help me!!!
RawBody <91d7b5b7-adff-431b-801e-1848bd26e858@communitybridge.codeplex.com>:
<div>hi,</div>
<div>say you have an integer primary key field in Vouchers table called ID</div>
<div>first you get the ID of top voucher, you can use DFirst or open recordset:</div>
<div>&nbsp;</div>
<div>varID=dfirst(&quot;ID&quot;,&quot;Vouchers&quot;,&quot;Vouchers.Group='1 Day' And Status='Unsold'&quot;)</div>
<div>&nbsp;</div>
<div>then you run report for this ID:</div>
<div>DoCmd.OpenReport &quot;1 Day&quot;, acViewPreview,&quot;ID=&quot; & varID</div>
<div>&nbsp;</div>
<div>and then update status for that record:</div>
<div>&nbsp;</div>
<div>changedStatus = &quot;update [Vouchers]&quot;</div>
<div>changedStatus = changedStatus & &quot; set [Status] = #&quot; & sold & &quot;#&quot;</div>
<div>changedStatus = changedStatus & &quot; where ID = &quot; & varID</div>
<div>db.Execute changedStatus, dbFailOnError</div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div>-- </div>
<div>Best regards,</div>
<div>___________</div>
<div>Alex Dybenko (MVP)</div>
<div>http://accessblog.net</div>
<div>http://www.PointLtd.com</div>
<div>&nbsp;</div>
<div>&nbsp;</div>
FromWeb: Body <91d7b5b7-adff-431b-801e-1848bd26e858@communitybridge.codeplex.com> after conversion:

 

hi,
say you have an integer primary key field in Vouchers table called ID
first you get the ID of top voucher, you can use DFirst or open recordset:
 
varID=dfirst("ID","Vouchers","Vouchers.Group='1 Day' And Status='Unsold'")
 
then you run report for this ID:
DoCmd.OpenReport "1 Day", acViewPreview,"ID=" & varID
 
and then update status for that record:
 
changedStatus = "update [Vouchers]"
changedStatus = changedStatus & " set [Status] = #" & sold & "#"
changedStatus = changedStatus & " where ID = " & varID
db.Execute changedStatus, dbFailOnError
 
 
--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
 
 
RawBody <10b9280b-a9de-4078-b66d-823e5a1216ee@communitybridge.codeplex.com>:
<div>Hi,</div>
<div>I have an inventory&nbsp;form that shows vendor information along with the individual inventory items.&nbsp; I have a button on this form&nbsp;that launches an Order form.</div>
<div>When the Order form loads, I want&nbsp;the Vendor that was listed on the Inventory form to automatically fill in.&nbsp; The VendorID is on the inventory form.&nbsp; I am trying to pass this info to the Order form.&nbsp; The Vendor info on the Order form
 is a combo box, which list VendorID, VendorName, then all other pertinent info displays (address, city, state, etc) in their respective text boxes.&nbsp; Here is the error message and code I have tried, but doesn't work.&nbsp; All help is GREATLY appreciated!!!</div>
<div>Run-time error '451': Property let procedure not defined and property get procedure did not return an object.</div>
<div>Dim Vendor As String</div>
<div>DoCmd.OpenForm &quot;frmOrders&quot;, acNormal, , , acFormAdd<br/>
Vendor = Forms!frmInventory.VendorID.Value<br/>
Forms!frmorders.VendorID.BoundColumn(0) = Vendor<br/>
Vendor = Forms!frmorders.VendorID.Text<br/>
</div>
<div>Again, much appreciated as I am a novice programmer...</div>
<div>Sal</div>
FromWeb: Body <10b9280b-a9de-4078-b66d-823e5a1216ee@communitybridge.codeplex.com> after conversion:

 

Hi,
I have an inventory form that shows vendor information along with the individual inventory items.  I have a button on this form that launches an Order form.
When the Order form loads, I want the Vendor that was listed on the Inventory form to automatically fill in.  The VendorID is on the inventory form.  I am trying to pass this info to the Order form.  The Vendor info on the Order form is a combo box, which list VendorID, VendorName, then all other pertinent info displays (address, city, state, etc) in their respective text boxes.  Here is the error message and code I have tried, but doesn't work.  All help is GREATLY appreciated!!!
Run-time error '451': Property let procedure not defined and property get procedure did not return an object.
Dim Vendor As String
DoCmd.OpenForm "frmOrders", acNormal, , , acFormAdd
Vendor = Forms!frmInventory.VendorID.Value
Forms!frmorders.VendorID.BoundColumn(0) = Vendor
Vendor = Forms!frmorders.VendorID.Text

 

Again, much appreciated as I am a novice programmer...
Sal
RawBody <4dd53cf5-e5c1-40f7-97df-39ebcb14ea3f@communitybridge.codeplex.com>:
<p>Hi, Sal,</p>
<p>&nbsp;</p>
<p>&gt; Vendor = Forms!frmInventory.VendorID.Value</p>
<p>what's the name of the combobox in frmInventory? Really VendorID?</p>
<p>&nbsp;</p>
<p>Mark</p>

 

 

Coordinator
Jun 3, 2010 at 7:02 AM

You should only check the NNTPServer checkbox!

Coordinator
Jun 3, 2010 at 7:31 AM

I executed the same command sequence as shown by your log.... it took about 3 seconds to retrive the articles 1-140...

Also be aware, that the debug window will have impact on the performance...

Jun 3, 2010 at 7:45 AM
Edited Jun 3, 2010 at 7:51 AM
jkalmbach wrote:

You should only check the NNTPServer checkbox!

 The following is with just NTTP check and is from requesting new headers and bodies in two forums -- one at a time.  The first one, accessdev, had 139 old messages and no new ones.  The seconcd one was exceldev which had 149 old messages and four new ones.  It appears that there is a response requested for every existing header in the second case:

"ClassifyCommand: XHDR LINES 1-159
Received: Command: XHDR, Parameters: LINES 1-159
Received: Response: 221 header follows"

Debug window follows:

ClassifyCommand: GROUP Msdn.en-US.accessdev
Received: Command: GROUP, Parameters: Msdn.en-US.accessdev
Received: Response: 211 140 1 140 Msdn.en-US.accessdev group selected

ClassifyCommand: GROUP Msdn.en-US.exceldev
Received: Command: GROUP, Parameters: Msdn.en-US.exceldev
Received: Response: 211 159 1 159 Msdn.en-US.exceldev group selected

ClassifyCommand: LISTGROUP Msdn.en-US.exceldev
ClassifyCommand: Command unknown: Command: LISTGROUP, Parameter: Msdn.en-US.exceldev
Received: Command: NOTRECOGNISED, Parameters: Msdn.en-US.exceldev
Received: Response: 500 command not recognised

ClassifyCommand: XHDR LINES 1-159
Received: Command: XHDR, Parameters: LINES 1-159
Received: Response: 221 header follows

Received: Response: 1 123

Received: Response: 2 109

Received: Response: 3 115

Received: Response: 4 65

Received: Response: 5 115

Received: Response: 6 82

Received: Response: 7 248

Received: Response: 8 25

Received: Response: 9 215

Received: Response: 10 1

Received: Response: 11 133

Received: Response: 12 246

Received: Response: 13 89

Received: Response: 14 292

Received: Response: 15 65

Received: Response: 16 179

Received: Response: 17 64

Received: Response: 18 57

Received: Response: 19 78

Received: Response: 20 66

Received: Response: 21 60

Received: Response: 22 172

Received: Response: 23 73

Received: Response: 24 33

Received: Response: 25 35

Received: Response: 26 103

Received: Response: 27 67

Received: Response: 28 239

Received: Response: 29 25

Received: Response: 30 102

Received: Response: 31 25

Received: Response: 32 182

Received: Response: 33 94

Received: Response: 34 237

Received: Response: 35 43

Received: Response: 36 31

Received: Response: 37 50

Received: Response: 38 88

Received: Response: 39 80

Received: Response: 40 1320

Received: Response: 41 81

Received: Response: 42 77

Received: Response: 43 148

Received: Response: 44 132

Received: Response: 45 53

Received: Response: 46 97

Received: Response: 47 83

Received: Response: 48 563

Received: Response: 49 72

Received: Response: 50 94

Received: Response: 51 1

Received: Response: 52 153

Received: Response: 53 21

Received: Response: 54 33

Received: Response: 55 396

Received: Response: 56 1

Received: Response: 57 153

Received: Response: 58 36

Received: Response: 59 68

Received: Response: 60 258

Received: Response: 61 36

Received: Response: 62 64

Received: Response: 63 5

Received: Response: 64 18

Received: Response: 66 258

Received: Response: 67 114

Received: Response: 68 30

Received: Response: 69 71

Received: Response: 70 19

Received: Response: 71 191

Received: Response: 72 193

Received: Response: 73 186

Received: Response: 74 10

Received: Response: 75 79

Received: Response: 76 35

Received: Response: 77 339

Received: Response: 78 29

Received: Response: 79 1

Received: Response: 80 29

Received: Response: 81 96

Received: Response: 82 88

Received: Response: 83 117

Received: Response: 84 129

Received: Response: 85 15

Received: Response: 86 117

Received: Response: 87 30

Received: Response: 88 1

Received: Response: 89 54

Received: Response: 90 14

Received: Response: 92 140

Received: Response: 93 136

Received: Response: 94 142

Received: Response: 95 141

Received: Response: 96 48

Received: Response: 97 35

Received: Response: 98 96

Received: Response: 99 55

Received: Response: 100 101

Received: Response: 101 40

Received: Response: 102 140

Received: Response: 103 14

Received: Response: 104 1

Received: Response: 105 65

Received: Response: 106 42

Received: Response: 107 332

Received: Response: 108 37

Received: Response: 109 51

Received: Response: 110 553

Received: Response: 111 162

Received: Response: 112 107

Received: Response: 113 117

Received: Response: 114 57

Received: Response: 115 89

Received: Response: 116 132

Received: Response: 117 728

Received: Response: 118 256

Received: Response: 119 228

Received: Response: 120 52

Received: Response: 121 210

Received: Response: 122 48

Received: Response: 123 191

Received: Response: 124 1

Received: Response: 125 80

Received: Response: 126 73

Received: Response: 127 57

Received: Response: 128 78

Received: Response: 129 68

Received: Response: 130 52

Received: Response: 131 519

Received: Response: 132 129

Received: Response: 133 151

Received: Response: 134 132

Received: Response: 135 51

Received: Response: 136 9

Received: Response: 137 116

Received: Response: 138 220

Received: Response: 139 219

Received: Response: 140 18

Received: Response: 141 100

Received: Response: 142 40

Received: Response: 143 42

Received: Response: 144 35

Received: Response: 145 153

Received: Response: 146 106

Received: Response: 147 25

Received: Response: 148 21

Received: Response: 149 111

Received: Response: 150 172

Received: Response: 151 438

Received: Response: 152 153

Received: Response: 153 545

Received: Response: 154 1

Received: Response: 155 1

Received: Response: 156 1

Received: Response: 157 1

Received: Response: 158 87

Received: Response: 159 118

Received: Response: .

ClassifyCommand: XOVER 156-159
Received: Command: XOVER, Parameters: 156-159
Received: Response: 224 overview information follows

Received: Response: 156 is there a way to detect the cell/Range content is clipped? Kelmen Thu, 3 Jun 2010 02:00:25 +0000 <56e57d2e-16d0-4879-a73f-208f59c3d139@communitybridge.codeplex.com>  118 1 LOCALHOST.communitybridge.codeplex.com Msdn.en-US.exceldev:156

Received: Response: 157 Re: Range Manipulation And Looping Joshua01100110 Thu, 3 Jun 2010 02:00:42 +0000 <85a7e14f-7298-442b-bac2-d8188c831a37@communitybridge.codeplex.com> <59694b95-45f4-423d-9367-36ccea70bed7@communitybridge.codeplex.com> 85 1 LOCALHOST.communitybridge.codeplex.com Msdn.en-US.exceldev:157

Received: Response: 158 How to allow user using Excel when a program is using Excel COM? Very Crazy Dog Thu, 3 Jun 2010 02:32:04 +0000 <efc52ce3-e16c-42d5-969e-9d1cef0a8f0b@communitybridge.codeplex.com>  536 87 LOCALHOST.communitybridge.codeplex.com Msdn.en-US.exceldev:158

Received: Response: 159 Re: is there a way to detect the cell/Range content is clipped? Rick Rothstein, MVP - Excel Thu, 3 Jun 2010 03:00:48 +0000 <22f1ad30-4259-46da-b6da-8d1b4852d059@communitybridge.codeplex.com> <56e57d2e-16d0-4879-a73f-208f59c3d139@communitybridge.codeplex.com> 791 118 LOCALHOST.communitybridge.codeplex.com Msdn.en-US.exceldev:159

ClientConnected: 14
ClassifyCommand: ARTICLE 157
Received: Command: ARTICLE, Parameters: 157
Received: Response: 220 157 <85a7e14f-7298-442b-bac2-d8188c831a37@communitybridge.codeplex.com> article retrieved - head and body follow
From: Joshua01100110
Subject: Re: Range Manipulation And Looping
Date: Thu, 3 Jun 2010 02:00:42 +0000
Lines: 1
Message-ID: <85a7e14f-7298-442b-bac2-d8188c831a37@communitybridge.codeplex.com>
Newsgroups: Msdn.en-US.exceldev
Path: LOCALHOST.communitybridge.codeplex.com
Xref: LOCALHOST.communitybridge.codeplex.com Msdn.en-US.exceldev:157
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit
X-Newsreader: Community Forums NNTP Server 1.1.23.0
X-Comments: Stars=0; Points=0; Posts=6; Answers=0
Archived-At: <http://social.Msdn.microsoft.com/Forums/en-US/exceldev/thread/b5d5be7d-26d9-4385-8961-9d5d79766452#85a7e14f-7298-442b-bac2-d8188c831a37>
References: <59694b95-45f4-423d-9367-36ccea70bed7@communitybridge.codeplex.com>

Thank you, but this isn't really what I'm trying to do. I got it figured out, sort of
.

ClassifyCommand: MODE READER
Received: Command: MODE, Parameters: READER
Received: Response: 200 Community Forums Bridge News Server Ready - posting allowed

ClassifyCommand: ARTICLE 159
Received: Command: ARTICLE, Parameters: 159
Received: Response: 220 159 <22f1ad30-4259-46da-b6da-8d1b4852d059@communitybridge.codeplex.com> article retrieved - head and body follow
From: Rick Rothstein, MVP - Excel
Subject: Re: is there a way to detect the cell/Range content is clipped?
Date: Thu, 3 Jun 2010 03:00:48 +0000
Lines: 118
Message-ID: <22f1ad30-4259-46da-b6da-8d1b4852d059@communitybridge.codeplex.com>
Newsgroups: Msdn.en-US.exceldev
Path: LOCALHOST.communitybridge.codeplex.com
Xref: LOCALHOST.communitybridge.codeplex.com Msdn.en-US.exceldev:159
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit
X-Newsreader: Community Forums NNTP Server 1.1.23.0
X-Comments: Stars=1; Points=113; Posts=16; Answers=8
Archived-At: <http://social.Msdn.microsoft.com/Forums/en-US/exceldev/thread/56e57d2e-16d0-4879-a73f-208f59c3d139#22f1ad30-4259-46da-b6da-8d1b4852d059>
References: <56e57d2e-16d0-4879-a73f-208f59c3d139@communitybridge.codeplex.com>

 

Maybe a function like this might be of use to you...

Function IsTextFit(R As Range) As Boolean
    Dim OriginalWidth As Double
    OriginalWidth = R.Columns.ColumnWidth
    R.Columns.AutoFit
    IsTextFit = OriginalWidth >= R.Columns.ColumnWidth
    R.Columns.ColumnWidth = OriginalWidth
End Function

Note that there are some situations where the text will look like it fits, but the function will return false. This happens if the column's width is ever so slightly less than the width produced by auto-fitting the column. The reason is because there is a blank area after each character which (I think) serves as an inter-character spacer... I don't think there is any practical way to determine if this blank area is being partially sliced off by the column's right guide line or not.
.

ClassifyCommand: ARTICLE 156
Received: Command: ARTICLE, Parameters: 156
Received: Response: 220 156 <56e57d2e-16d0-4879-a73f-208f59c3d139@communitybridge.codeplex.com> article retrieved - head and body follow
From: Kelmen
Subject: is there a way to detect the cell/Range content is clipped?
Date: Thu, 3 Jun 2010 02:00:25 +0000
Lines: 1
Message-ID: <56e57d2e-16d0-4879-a73f-208f59c3d139@communitybridge.codeplex.com>
Newsgroups: Msdn.en-US.exceldev
Path: LOCALHOST.communitybridge.codeplex.com
Xref: LOCALHOST.communitybridge.codeplex.com Msdn.en-US.exceldev:156
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit
X-Newsreader: Community Forums NNTP Server 1.1.23.0
X-Comments: Stars=1; Points=63; Posts=88; Answers=15
Archived-At: <http://social.Msdn.microsoft.com/Forums/en-US/exceldev/thread/56e57d2e-16d0-4879-a73f-208f59c3d139#56e57d2e-16d0-4879-a73f-208f59c3d139>
References:

is there a way to detect the cell content is being displayed as ***** or being clipped because not enough width to fit
.

ClassifyCommand: ARTICLE 158
Received: Command: ARTICLE, Parameters: 158
Received: Response: 220 158 <efc52ce3-e16c-42d5-969e-9d1cef0a8f0b@communitybridge.codeplex.com> article retrieved - head and body follow
From: Very Crazy Dog
Subject: How to allow user using Excel when a program is using Excel COM?
Date: Thu, 3 Jun 2010 02:32:04 +0000
Lines: 87
Message-ID: <efc52ce3-e16c-42d5-969e-9d1cef0a8f0b@communitybridge.codeplex.com>
Newsgroups: Msdn.en-US.exceldev
Path: LOCALHOST.communitybridge.codeplex.com
Xref: LOCALHOST.communitybridge.codeplex.com Msdn.en-US.exceldev:158
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit
X-Newsreader: Community Forums NNTP Server 1.1.23.0
X-Comments: Stars=1; Points=6; Posts=17; Answers=0
Archived-At: <http://social.Msdn.microsoft.com/Forums/en-US/exceldev/thread/efc52ce3-e16c-42d5-969e-9d1cef0a8f0b#efc52ce3-e16c-42d5-969e-9d1cef0a8f0b>
References:

I have developed a program in VB.NET which uses Microsoft Excel 11.0 Object Library COM to call an Excel application for some data manipulation.

However while the hidden Excel application is running at the background, user cannot double click on any Excel file, which will cause the hidden Excel application to show on the screen and interrupted my VB.NET program.

I want to know how to allow user still able to use Excel application properly while my VB.NET program is running with hidden Excel application at the background. Thanks.
.

 

Coordinator
Jun 3, 2010 at 7:50 AM

The problem is, that your client is requesting *ALL* messages (159); but this should also take about 5 seconds... (XHDR LINES 1-159).

What performance issues do you see in this responses?

Also, what are aour settings in the Agent: Tools | Servers and Accounts | localhost | Advanced settings"?

Jun 3, 2010 at 8:21 AM

The client is not requesting all messages.  It is Agent 6 and it is only requesting new headers and bodies -- at least that is the way it works with real newsgroups.  There is some chatter in the debug window about unrecognised commands.  The processing only took about 5 seconds because the total number of messages in the forum was only 153.  When I did the same thing with the vsto forum with over 60K messages it took seventeen minutes -- I assume that was to process the 60K messages.

The Microsoft bridge is supposed to work with Agent 6.  I assume the Community Bridge is also supposed to work with Agent 6.  I don't think either one does.

>Also, what are aour settings in the Agent: Tools | Servers and Accounts | localhost | Advanced settings"?

Use a non-standard NNTP port - Unchecked

The server creates messaes out of order - Unchecked

Use the XHDR command instead of xover -- Unchecked

Use binary search to sample headers by date -- Checked

Request compressed headers from server -- Checked

          Use XHDR instead of LISTGROUP when compression is on -- Checked

The above are the same settings I use with the Microsoft newsgroups and many others.

Coordinator
Jun 3, 2010 at 9:53 AM

All seems to be ok... what is your problem now?

It is "normal" that it takes several minutes if your request > 500 messages... this is because the web-service is slow... There is no way the bridge can increase this...

Greetings
  Jochen

Jun 6, 2010 at 7:55 PM

My last post did not seem to make it so I'll try again.

>It is "normal" that it takes several minutes if your request > 500 messages...

The request was for new headers not 500+ messages.

>All seems to be ok... what is your problem now?

As I said before, it takes seventeen minutes to download a few new headers from a large forum.  Downloading new headers from an equivalent newsgroup takes a few seconds.

 

Coordinator
Jun 6, 2010 at 7:57 PM
Edited Jun 6, 2010 at 8:27 PM

Can you do the following:
1. Exit Agent
2. Exit NNTPBridge
3. Start NNTP Bridge
4. Open the debug window (Tools | Schow debug wndoow...)
5. CHeck all checkboxes in the Debug window!
6. Start agent
7. Download all *new* headers in agent
8. Wait 60 Seconds
9. Select all lines in the debug window
10. RIght click on the lines and select "copy the text into the clipboard"
11. Post the debug output here

Also I will now release V31, which have fixed an issue with Tabs ind the subject (which can lead Agent to have some problems).

 

PS: And as I said: Your client (Agent) has requested *all* messages from this group (XHDR LINES 1-159)! And if this group contains > 70000 messages this will take a while! Please be sure you really selected "Get all *new* messages".

Otherwise it would be nice if you could test with V31 and the above steps. But I think agent does something wrong and requests *all* headers like in your example above.

Jun 7, 2010 at 3:15 AM

Using V31

I could not get the debug windows to stop scrolling.  There was no way to select the contents for a large forum.  I tried starting over and selecting a smaller forum.  I still could not get the debug windows to stop scroll to select it.  I tried unchecking all of the options but it keep scrolling.  I could not use a very small forum as that did not exhibit the same symtoms.

Is there some way to direct the debug information to a file so it doesn't get lost?

 

Coordinator
Jun 7, 2010 at 4:54 AM

It seems to be better if you just check the "NNTP" and "main" checkboxes... It still seems that Agent tries to download *all* articles...

Jun 7, 2010 at 5:21 AM
Edited Jun 7, 2010 at 5:23 AM

It still runs away if I try to get new headers from any forum with a few thousand messages.  Please note that this is after already downloading all headers and bodies from the forum.

>It still seems that Agent tries to download *all* articles...

That may be the case but if Agent is talking to a real news server it only takes a few seconds.  Perhaps you can get a copy of Agent 6 and try it.  According to Microsoft the bridges are supposed to support it --- but it appears they do only enough to force folks to switch readers.

They offer a 30 day free trial: http://www.forteinc.com/agent/index.php

Then try the  Msdn.en-US.isvvba forum or better yet the Msdn.en-US.vsto forum.

Edit: BTW, the Community Bridge seems to hang every now and then.  I have to use Task Manager to kill it.

Coordinator
Jun 7, 2010 at 5:33 AM
Edited Jun 7, 2010 at 5:33 AM

I have a copy of Agent 6 and many others also ;) And it works without any problems...

The bridge might hang if you use the debug windows with extensive messages. If you do not use the debug window, then there is no problem.

 

Have you tried the same with the MS bridge?

Jun 7, 2010 at 6:40 AM
Edited Jun 7, 2010 at 6:48 AM

Please use Agent 6 and subscribe to the Msdn.en-US.isvvba forum.  Set it to download all bodies when downloading new headers.  Download all messages.  Then close Agent and the Bridge and reboot.  Start the bridge.  Start Agent.  Select the Msdn.en-US.isvba forum.  Click on Get New Headers in Folders -- it is the second icon on the toolbar.

 

Edit:

>Have you tried the same with the MS bridge?

Yes -- the performance was terrible -- and that is the reason I tried the Community Bridge.

Edit2:

You might want to try the same thing with the microsoft.public.windowsxp.help_and_support newsgroup which is still available on msnews.microsoft.com.  Compare the performance.

Coordinator
Jun 7, 2010 at 7:25 AM

I have done this... I have no problems after reatrting.. Agent only request the new headers/bodies and not all...

Also it is very misterious that agent tries to get all "LINES" of each article...

What special setting do you have, that agent wants "LINES" info?

I have only one suggestion left: *Uncheck* in the folder properties: Receiving messages | Usenet messages | Do not keep unavailable messages

Maybe this is forcing Agent to update *all* messages...

Jun 7, 2010 at 10:17 AM

>I have only one suggestion left: *Uncheck* in the folder properties: Receiving messages | Usenet messages | Do not keep unavailable messages

Didn't help.

I am going to try starting over.  That is -- delete everything in the directory I have setup for Agent using the bridge and start from scratch.

Jun 17, 2010 at 4:20 AM
saberman wrote:

I am going to try starting over.  That is -- delete everything in the directory I have setup for Agent using the bridge and start from scratch.

 Have you had any luck with this? I think I am experiencing the same problem.