query definition cashe size

[Pinan]

I have an connection string sending information to a database, and it works fine, until the information quantity exceeds the cache size for the connection string. this is the code that inserts the information.

'define the worskpace and connection
Dim wrkSpace As Workspace
Dim conPubs2 As Connection

'make the appropriate settings
Set wrkODBC = CreateWorkspace("NewODBCWorkspace", "", "", dbUseODBC)
Set conPubs2 = wrkODBC.OpenConnection("Connection2", dbDriverPrompt, False, "ODBC;&quot


'insert the information into the database
Set QD = conPubs2.CreateQueryDef("", "INSERT INTO SYSTEM_INFORMATION.TCC$010_ISSUE_LOG VALUES('" & lblCalc.Caption & "' ,'" & txtSBCUID.Text & "', date, '" & Combo1.Text & "', '" & txtNCR.Text & "', '" & txtVantiveChange.Text & "', '" & txtVantive.Text & "', '" & txtKeywords.Text & "', '" & txtLog.Text & "')&quot

QD.Execute dbRunAsync

Sorry about the format...it got ugly. When I put a watch on QD, it shows the cache set at 100. I need it much larger; more like 6500. How can I change the cache size of the QD (query definition)? Like I said, it works fine on small quantities of information.