Hello,

I have a simple program (Below):

It opens a ADODB connection, opens a recordset. Runs a query. Which all works. but when It issues the rs.close and db.close the Thread created on the Linux box still exists. And multiple calls to this routine will eventually give me a "too many connections error"

Shouldn't the db.close kill the thread created?? What am I missing.. I checked on your site for some insight but found nothing that speaks of this.

Any help is much appreciated.

Thanks.

Mike mi...@unipros.com P.S.: running MySQL vers.3.23.41On RedHat linux 7.x and the latest MyODBC from your site 2.50.39.00

Public Sub load_Jobs(aclient As String, acontrol As Control) Dim db As New ADODB.Connection Dim rs As New ADODB.Recordset acontrol.Clear

sql = "select JobID from Jobs where ClientCode='" + aclient

db.Open "Driver={mySQL};" & _ "Server=192.168.0.102;" & _ "Port=3306;" & _ "Option=131072;" & _ "Stmt=;" & _ "Database=timesheet;" & _ "Uid=xxx;" & _ "Pwd=xxxxxxx;"

rs.Source = sql Set rs.ActiveConnection = db rs.Open

If rs.EOF=False then Do While rs.EOF = False acontrol.AddItem rs!jobid rs.MoveNext Loop endif

rs.Close Set rs = Nothing db.Close Set db = Nothing