search

SuperKaioken / odbc2kml

Automatically exported from code.google.com/p/odbc2kml
0 stars 0 forks source link

database timeout #158

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. click new connection
2. enter data for mssql
3. click save

What is the expected output? What do you see instead?

timeout for mssql is to long, a user would think something is wrong

Please use labels and text to provide additional information.

Original issue reported on code.google.com by jpetti...@gmail.com on 8 Apr 2010 at 2:39

GoogleCodeExporter commented 9 years ago

Original comment by mbbowser@gmail.com on 8 Apr 2010 at 8:44

GoogleCodeExporter commented 9 years ago 
This issue was closed by revision r539.

Original comment by mbbowser@gmail.com on 8 Apr 2010 at 8:49

GoogleCodeExporter commented 9 years ago 
Not fixed.  Noticed MSSQL database connections take 15 seconds to timeout 
instead of 
the specified 10 and MySQL connections take 20 seconds instead of 10.

Re-assigning to low priority to look into later if we have time.

Original comment by nind...@gmail.com on 8 Apr 2010 at 9:34

GoogleCodeExporter commented 9 years ago 
After trying the changed connection string for Oracle the ODBC handler dies 
with an 
Oracle error stating that "Connection Timeout" is not a valid specifier (or 
something 
like that).  Not sure if our Oracle ODBC drivers allow Connection Timeout stuff.

Original comment by nind...@gmail.com on 9 Apr 2010 at 6:50

GoogleCodeExporter commented 9 years ago 
After searching online I found there is no way for our Oracle ODBC drivers to 
specify 
the Connection Timeout

Original comment by nind...@gmail.com on 10 Apr 2010 at 4:05

GoogleCodeExporter commented 9 years ago 
"Connection Timeout=x" added to the string doesn't help MySQL or MSSQL.

Original comment by mbbowser@gmail.com on 10 Apr 2010 at 5:13

GoogleCodeExporter commented 9 years ago 
I set the timeout for MySQL and MSSQL to 5 seconds with revision 564. There is 
no way 
to do this with Oracle.

Original comment by mbbowser@gmail.com on 10 Apr 2010 at 5:24

GoogleCodeExporter commented 9 years ago 
verified as unfixable

Original comment by sweenr...@gmail.com on 11 Apr 2010 at 7:09