[RESOLVED] Progress Database Problem

[LostAngel]

Hello, we use a manufacturing program called TMM that uses a Progress backend. Recently, we noticed that pretty large files are being created in a directory in TMM. When I open these, it seems to be data from places in the progress database. Any time a query is ran (though VB or WinSQL), it seems a file is created...I am only running SELECT statements, no insert/updates. With WinSQL, there is an option to "Auto Commit Transactions". When this is checked, the file is deleted after the data is stored. Does anyone know how to do this in VB? I have tried cnTMM.CommitTrans, but it doesn't work (I guess it only works when you are inserting data). Below is how I connect to the database:

Public Sub ConnectTMM()
Set cnTMM = New ADODB.Connection
    cnTMM.CursorLocation = adUseClient
    cnTMM.ConnectionString = "Provider=MSDASQL.1;" & _
    "Password=PASS;" & _
    "Persist Security Info=True;" & _
    "User ID=sysprogress;" & _
    "Password=PASS;" & _
    "Data Source=tmm_db10"
    cnTMM.Open
End Sub
 
Public Sub OpenTMM(strsql As String)
Set rsTMM = New ADODB.Recordset 'as we did with the connection    txtQuery.Text = strSQL
If rsTMM.State = adStateOpen Then rsTMM.Close 'If Open,  Close.
     rsTMM.Open strsql, cnTMM, adOpenKeyset, adLockOptimistic, adCmdText  'Opens Recordset.
End Sub

[si_the_geek]

Transactions aren't appropriate unless the data in the database is being modified in some way, and I dont think there is anything else you can do from VB either.

I'm pretty sure this is just a setting for the database/software, but can't help more I'm afraid.

[szlamany]

I had my first experience with a PROGRESS DB this week - and was shocked by the fact that the data was in multiple files in the folder

At any rate - if PROGRESS supports the "read regardless" concept - ability for some users to see data even if locked - then it's copying rows to a temporary storage location. Note that this is a wild guess!

ARe you specifying no locking while doing your SELECT?

[LostAngel]

I think I found out what was wrong. I changed adLockOptimistic to adLockReadOnly...and log files are deleted after I close the connection.

[Hack]

I think I found out what was wrong. I changed adLockOptimistic to adLockReadOnly...and log files are deleted after I close the connection.

Is resolved then?

If so, please pull down the Thread Tools menu and click the Mark Thread Resolved button. That will let everyone know that you have your answer.

Thank you.

[LostAngel]

Done!
Thanks!