[test]

DSN = test

Driver = ODBC Driver 11 for SQL Server

Trace = Yes

Server = 10.0.1.102

Port = 1433

Database = testdb

Language = us_english

[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

isql test uid PASSWORD

select TOP(1) * FROM dmi_vCustomer2;

(Returns 1 row 66 seconds later.)

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

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