Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.13
-
None
-
CentOS release 6.5 (X86_64)
Description
My connect table is not working due to timeout reasons.
Is there a way I can configure to change the query timeout.
/etc/odbc.ini
[test]
|
DSN = test
|
Driver = ODBC Driver 11 for SQL Server
|
Trace = Yes
|
Server = 10.0.1.102
|
Port = 1433
|
Database = testdb
|
Language = us_english
|
/etc/odbcinst.ini
[ODBC Driver 11 for SQL Server]
|
Description=Microsoft ODBC Driver 11 for SQL Server
|
Driver=/opt/microsoft/msodbcsql/lib64/libmsodbcsql-11.0.so.2270.0
|
Threading=1
|
UsageCount=1
|
test on isql
isql test uid PASSWORD
|
select TOP(1) * FROM dmi_vCustomer2;
|
|
|
(Returns 1 row 66 seconds later.)
|
error on MariaDB
CREATE OR REPLACE TABLE ms_dmi_vCustomer2
|
(
|
customer_no int DEFAULT NULL
|
,post_code varchar(7) DEFAULT NULL
|
,customer_category smallint DEFAULT NULL
|
,mail_address varchar(100) DEFAULT NULL
|
,sex int DEFAULT NULL
|
,birthday char(23) DEFAULT NULL
|
,update_date char(23) DEFAULT NULL
|
)
|
ENGINE=CONNECT DEFAULT CHARSET=utf8 CONNECTION='DSN=test;UID=uid;pwd=PASSWORD' `table_type`=ODBC `block_size`=500
|
`tabname`='dmi_vCustomer2';
|
|
|
select * from ms_dmi_vCustomer2 limit 10;
|
|
|
(Returns the following error 27 seconds later.)
|
|
|
ERROR 1296 (HY000): Got error 122 '[unixODBC][Microsoft][ODBC Driver 11 for SQL Server]Query timeout expired' from CONNECT
|
*.err file
S1T00: [unixODBC][Microsoft][ODBC Driver 11 for SQL Server]Query timeout expired, Native=0
|
[unixODBC][Microsoft][ODBC Driver 11 for SQL Server]Query timeout expiredrnd_next CONNECT: [unixODBC][Microsoft][ODBC Driver 11 for
|
SQL Server]Query timeout expired
|
GEM(73): [unixODBC][Microsoft][ODBC Driver 11 for SQL Server]Query timeout expired
|
external_lock: this=0x7fe8e6894a20 thd=0x7fe8f96fc008 xp=0x7fe8e69141a0 g=0x7fe8e68e7000 lock_type=2
|
ODBC CloseDB: closing ms_dmi_vCustomer2
|