Hi,

When I try to set the ConnectBufferString property, I get the following error:
"this property is currently in a read only state and cannot be modified"
(I'm using Crystal Reports 9)

Any ideas?

Thx,

Kris


Private Sub ConnectReports(ByVal aBuilder As IPreviewBuilder, areportrouter As ReportSourceRouter)
   Dim i As Integer
   Dim strConnectionBuffer
   Dim objDatabaseTable As CRAXDRT.DatabaseTable
   On Error GoTo Cleanup

   strConnectionBuffer = _
      "Server=" & m_conMain.Properties("Data Source").Value & ";;" & _
      "User ID=" & m_conMain.Properties("User Name").Value & ";;" & _
      "Password=" & m_conMain.Properties("Password").Value

   For i = 0 To (aBuilder.ReportCount - 1)
      With aBuilder.Report(i).CRReport
         .EnableParameterPrompting = False
         If .Database.Tables.Count > 0 Then
            If Not (aBuilder.Report(i).IsConnected) Then
                     .Database.LogOnServer CR_ORACLEDLL, _
                                    m_conMain.Properties("Data Source").Value, , _
                                    m_conMain.Properties("User Name").Value, _
                                    m_conMain.Properties("Password").Value
               For Each objDatabaseTable In .Database.Tables
                  objDatabaseTable.ConnectBufferString = strConnectionBuffer:(
               Next
            End If
         End If
      End With
      areportrouter.AddReport aBuilder.Report(i).CRReport
      aBuilder.Report(i).IsConnected = True
   Next i

Cleanup:
...

End Sub

I'm also getting the same problem.. did you found any solution....


Please help me..

I also am getting the same problem, if you have figured out this problem, I'd appreciate any tips.

This is the only result when I google the error.


Thanks a bunch in advance!!!

Mark Shervey

Try this:

For Each objDatabaseTable In .Database.Tables
    objDatabaseTable.ConnectionProperties.DeleteAll
    objDatabaseTable.ConnectBufferString = strConnectionBuffer
Next

I get exacly the same error message although I don't use ConnectBufferString property. Does anybody get any results
on this?

Any help will be greatly appreciated.

The ConnectBufferString property only needs to be set once; on the first Table in the collection. You will notice the above error will always show up on the second table. This ought to fix the problem.

There is one other workaround; if you're using Crystal 10 you can use the CrystalDesignRuntime.Application instead of the CrystalRuntime.Application... it seems to ignore the problem. Note that this doesn't work on version XI (11)

I had the same problem and found that the easiest/best fix was to just set the ConnectionBufferString every time I opened a report and just caught the exception if it was thrown, and ignored it. That way you don't have to keep track of whether this is the first report opened or second or if they closed one and are opening a new one, etc.