Intermittent pypyodbc connection

JohnConnor01

Hello,

I am experiencing intermittent pypyodbc server connections. I am able to successfully run a simple query on a SQL Server database, and without making changes, the same query won't work 5 minutes later. Any help would be appreciated.

-JC from Boston

(Update: When looking at the debugger, I got an error regarding "Trying to use a closed connection")

(Update: I believe the problem is arising with numerous open/close connections strings in the program and then running certain lines when the connection is inadvertently still closed.)

KimberlyGarbade

If this is stand alone code (I.E. its not embedded in some other code I'm not seeing) than that is odd.  I can't replicate the problem, the code works for me (with a slight modification not to return all the records in my test table by using a Where clause on your Select statement)...

Could you have created the connection in one part of your code, closed it, and then tried to call it again later by accident?

For example the code in the first image works because the "conn.close()" is commented out.  The second image shows the results of the same code with "conn.close" included and the function call fails:

 

 

 

Only other thing I can think of is that some process running in the database is taking a long time (in computer terms longer than 5 seconds) and your connection is timing out. You could try adding a "timeout=some number of seconds" parameter to your connection string, but that doesn't sound right even to me.