2214484 - Data source name not found and no default driver specified - SAP IQ

Source database: IQ 16 on Windows

Target database: IQ 16 on another machine Windows

Remote Server created with IQODBC class.

No ODBC DSN created previously.

DROP SERVER TestIQremote

CREATE SERVER TestIQremote CLASS 'IQODBC' USING 'DRIVER=SybaseIQ;HOST=xxxx;Server=xxx1;DBN=xxx';

CREATE EXISTING TABLE Test_Connection AT 'TestIQremote..dbo.Test_Connection_source' ;

Select  count(*) from Test_Connection  ;

Error : Unable to connect to server 'TestIQremote': [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

SQLCODE=-656, ODBC 3 State="HY000"

SAP IQ 16

IQDBC; SAODBC; DSN; data source name , KBA , BC-SYB-IQ , Sybase IQ , Problem