Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.1.37
-
None
-
We have the following installed components on CentOS Linux release 7.5.1804 , x86_64 machine:
1. MariaDB-client-10.1.37 and MariaDB-server-10.1.37-1.el7
2. MariaDB-connect-engine-10.1.37-1.el7
3. unixODBC 2.3.1
4. Microsoft SQL Server ODBC Driver V1.0 for Linux (SQL Server Native Client 11.0), libsqlncli-11.0.so.1790.0We have the following installed components on CentOS Linux release 7.5.1804 , x86_64 machine: 1. MariaDB-client-10.1.37 and MariaDB-server-10.1.37-1.el7 2. MariaDB-connect-engine-10.1.37-1.el7 3. unixODBC 2.3.1 4. Microsoft SQL Server ODBC Driver V1.0 for Linux (SQL Server Native Client 11.0), libsqlncli-11.0.so.1790.0
Description
We are trying to connect to a remote MSSQL test DB (DSN=ODBC01) & a second MSSQL production DB (DSN=ODBC02) with SSL enabled.
odbc.ini content:
[ODBC01]
|
Driver = SQL Server Native Client 11.0
|
Description = ODBC driver Sample 1
|
Server = TCP:172.16.203.110,1433
|
Database = TESTDB
|
 |
[ODBC02]
|
Driver = SQL Server Native Client 11.0
|
Description = ODBC driver Sample 2
|
Server = TCP:10.10.46.143,1433
|
Database = DB_name
|
To check connectivity we used unixODBC isql command. Both commands worked fine:
isql ODBC01 -v user1 pw1
|
isql ODBC02 -v user2 pw2
|
In mysql we created two tables:
CREATE TABLE tb1 (c1 int) engine=connect table_type=ODBC tabname='table1' CONNECTION='DSN=ODBC01;UID=user1;PWD=pw1;'; |
CREATE TABLE tb2 (c1 int) engine=connect table_type=ODBC tabname='table2' CONNECTION='DSN=ODBC02;UID=user2;PWD=pw2;'; |
The first query worked fine,
select count(*) from tb1; |
but the second one didn't work:
select count(*) from tb2; |
ERROR 1296 (HY000): Got error 122 'Fetching: [Microsoft][SQL Server Native Client 11.0]SSL Provider: [error:80001044:lib(128):func(1):internal error:unexpected error]' from CONNECT |
We appreciate your kind support.