I'm trying to create a new Pivot table in a workbook with VSTO2.

The second line crash:

System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

Server stack trace:
Exception rethrown at [0]:

at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Microsoft.Office.Interop.Excel.PivotCaches.Add(XlPivotTableSourceType SourceType, Object SourceData)
at ExcelTestPivot.ThisWorkbook.ThisWorkbook_Startup(Object sender, EventArgs e) in C:\Documents and Settings\****\ThisWorkbook.vb:line 11

Can you hel me? Thnks.

Here the code:

Dim oPiv As Excel.PivotCache

oPiv = Me.PivotCaches.Add(Excel.XlPivotTableSourceType.xlDatabase)

With oPiv

.Connection = "Data Source=.\SQLEXPRESS;Initial Catalog=exlCantieri;Integrated Security=True"

.CommandText = "SELECT *** FROM ***"

End With

With Globals.Foglio1.PivotTables("Tabella_pivot1").PivotFields("field1")

End With

With Globals.Foglio1.PivotTables("Tabella_pivot1").PivotFields("field2")

End With

Globals.Foglio1.Range("B4").Select()

Globals.Foglio1.PivotTables("Tabella_pivot1").PivotCache.Refresh()

According to Excel OM documentation, you must specify the SourceData argument if the SourceType is not xlExternal.

This seems to be the cause of the exception.

ok all it's ok.

I use ODBC connection with this string to connect to sqlexpress:

I'd like to know if i can use other type of connection.