SStory wrote:
> Well,
>
> Are you firing this a bunch? Are you getting a brand new connection each
> time?
>
> Do you need a queue? (IN ours we have a queue, so that we don't miss
> anything and of course it is multithreaded.)
>
> Thanks,
>
> Shane
>
> "Chris" <no@spam.com> wrote in message
> news:e5BYEHGRFHA.2664@TK2MSFTNGP15.phx.gbl...
>
>>I am using the following function in a windows service. It is fired off
>>by a file system watcher component. It works fine, except for I'll copy
>>in 20 files it has to process at one time. I'll load up MySqlBrowser to
>>check the data, and it says I'm out of connections. (the database is
>>remote) The connections don't clear until I stop the service. Any idea
>>what I'm missing?
>>
>>Thanks
>>Chris
>>
>> Dim myConnection As MySqlConnection
>> Dim myCommand As MySqlCommand
>> Try
>> Dim myConnectionString As String
>> myConnectionString = ...
>>
>> myConnection = New MySqlConnection(myConnectionString)
>> Dim myInsertQuery As String = GenerateQuery()
>> myConnection.Open()
>> myCommand = New MySqlCommand(myInsertQuery)
>> myCommand.Connection = myConnection
>> myCommand.ExecuteNonQuery()
>> For Each S As String In Errors
>> myCommand.CommandText = "Insert into ImportErrors ....
>>myCommand.ExecuteNonQuery()
>> Next
>> Catch ex As Exception
>> WriteLog(ex.Message)
>>Finally
>> If Not myCommand Is Nothing Then
>> myCommand.Dispose()
>> End If
>> If Not myConnection Is Nothing Then
>> myConnection.Close()
>> myConnection.Dispose()
>> End If
>> End Try
>
>
>

"Chris" <no@spam.com> wrote in message
news:e5BYEHGRFHA.2664@TK2MSFTNGP15.phx.gbl...
> I am using the following function in a windows service. It is fired off
> by a file system watcher component. It works fine, except for I'll copy
> in 20 files it has to process at one time. I'll load up MySqlBrowser to
> check the data, and it says I'm out of connections. (the database is
> remote) The connections don't clear until I stop the service. Any idea
> what I'm missing?
>
> Thanks
> Chris
>
> Dim myConnection As MySqlConnection
> Dim myCommand As MySqlCommand
> Try
> Dim myConnectionString As String
> myConnectionString = ...
>
> myConnection = New MySqlConnection(myConnectionString)
> Dim myInsertQuery As String = GenerateQuery()
> myConnection.Open()
> myCommand = New MySqlCommand(myInsertQuery)
> myCommand.Connection = myConnection
> myCommand.ExecuteNonQuery()
> For Each S As String In Errors
> myCommand.CommandText = "Insert into ImportErrors ....
> myCommand.ExecuteNonQuery()
> Next
> Catch ex As Exception
> WriteLog(ex.Message)
> Finally
> If Not myCommand Is Nothing Then
> myCommand.Dispose()
> End If
> If Not myConnection Is Nothing Then
> myConnection.Close()
> myConnection.Dispose()
> End If
> End Try

"Chris" <no@spam.com> wrote in message
news:%23QOXoRIRFHA.3188@TK2MSFTNGP10.phx.gbl...
> SStory wrote:
>> Well,
>>
>> Are you firing this a bunch? Are you getting a brand new connection each
>> time?
>>
>> Do you need a queue? (IN ours we have a queue, so that we don't miss
>> anything and of course it is multithreaded.)
>>
>> Thanks,
>>
>> Shane
>>
>> "Chris" <no@spam.com> wrote in message
>> news:e5BYEHGRFHA.2664@TK2MSFTNGP15.phx.gbl...
>>
>>>I am using the following function in a windows service. It is fired off
>>>by a file system watcher component. It works fine, except for I'll copy
>>>in 20 files it has to process at one time. I'll load up MySqlBrowser to
>>>check the data, and it says I'm out of connections. (the database is
>>>remote) The connections don't clear until I stop the service. Any idea
>>>what I'm missing?
>>>
>>>Thanks
>>>Chris
>>>
>>> Dim myConnection As MySqlConnection
>>> Dim myCommand As MySqlCommand
>>> Try
>>> Dim myConnectionString As String
>>> myConnectionString = ...
>>>
>>> myConnection = New MySqlConnection(myConnectionString)
>>> Dim myInsertQuery As String = GenerateQuery()
>>> myConnection.Open()
>>> myCommand = New MySqlCommand(myInsertQuery)
>>> myCommand.Connection = myConnection
>>> myCommand.ExecuteNonQuery()
>>> For Each S As String In Errors
>>> myCommand.CommandText = "Insert into ImportErrors ....
>>>myCommand.ExecuteNonQuery()
>>> Next
>>> Catch ex As Exception
>>> WriteLog(ex.Message)
>>>Finally
>>> If Not myCommand Is Nothing Then
>>> myCommand.Dispose()
>>> End If
>>> If Not myConnection Is Nothing Then
>>> myConnection.Close()
>>> myConnection.Dispose()
>>> End If
>>> End Try
>>
>>
>>
>
> I thought about using a Queue. I have it so that each time a new file is
> created it files a new thread which does the function that you saw. So yes
> if a bunch of files get thrown up at the same time, it would make many
> connections. Would you suggest that I have a worker thread that just
> polls the queue once a minute?
>
> Chris