Strange Database Problem

[arrian]

I'm having an issue with the program I'm working on. It seems like for some reason, every once in a while the connection to the database errors out. It works fine most of the time, but on occasion, it errors out. It's not giving me ANY reasons for the errors, just error 5: Unspecified error. The database is being run localy. If anyone needs some snippets of the code, I can provide that as well.

 

[ca8msm]

Most of the pages that describe this error (from what I've found by looking on google) suggest that it is a case of too many connections - could you look at using an alternative db?


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[arrian]

Ok... Looks like one of the connections wasn't being closed for some reason. I fixed that, and it seems to be working now! I'm very mad at myself for not seeing it. The connection was in my "Connect" sub, which returns a dataset, and I was only looking at the "Execute" sub, which executes commands (ie Delete, Insert, Update, etc...) Thanks a lot, everyone. Seems to be all fixed!

 

[zqtqzq]

i have experienced the same error in one of my application using Access Database. The problem likely is from Connection not being properly closed before opening another instance.

Also check if you call a dll functions all the time. Make sure you close the function call before calling another instance of this function