Forum Discussion

Ryu's avatar
Ryu
Contributor
8 years ago

Connection to DB not closing properly?

I have this function that accesses a database using ADODriver.  I have it closing the connection at the end, and the first run through the function when I open TC passes.  However, on a subsequent ru...
tristaanogre's avatar
tristaanogre
Esteemed Contributor
8 years ago

A better way of closing it is to actually close the DDT driver.  This is a more complete way.  I'm not fully familiar with Python syntax but this is what it should look like.

 

def getTableValues():
  num = []
  countTable = DDT.ADODriver(ConStr, query)
  while not countTable.EOF():
    num.append(countTable.Value[1])
    countTable.Next()
  for i in num:
    Log.Message(i)
  DDT.CloseDriver(countTable.Name)