ODBC Connection test not responding

Vidya_Sagar_Reddy · June 4, 2020, 4:49am

I have installed mongo DB in Linux operating system(CentOS 7), I am configuring ODBC 32 bit connection in windows machine, when I test it is not responding, I have tried ODBC 64/32 bit and also tried with unicode and ascii option. I am not sure with what i am doing. I have also attached screenshot for connection details. Logs are not generating. Do i miss any configuration in ODBC like TLS or SSL?

Stennie_X · June 7, 2020, 1:54am

Welcome to the community @Vidya_Sagar_Reddy,

The MongoDB ODBC Driver for BI Connector also requires a compatible version of the MongoDB Connector for BI to be installed and running.

What are your installed versions of MongoDB ODBC driver, Connector for BI, and MongoDB server?

Regards,
Stennie

Vidya_Sagar_Reddy · June 15, 2020, 5:45am

Sorry for Late reply,

mongo --version
MongoDB shell version v4.2.7
git version: 51d9fe12b5d19720e72dcd7db0f2f17dd9a19212
OpenSSL version: OpenSSL 1.0.1e-fips 11 Feb 2013
allocator: tcmalloc
modules: none
build environment:
distmod: rhel70
distarch: x86_64
target_arch: x86_64

cat /etc/os-release
NAME=“CentOS Linux”
VERSION=“7 (Core)”
ID=“centos”
ID_LIKE=“rhel fedora”
VERSION_ID=“7”
PRETTY_NAME=“CentOS Linux 7 (Core)”
ANSI_COLOR=“0;31”
CPE_NAME=“cpe:/o:centos:centos:7”
HOME_URL=“https://www.centos.org/”
BUG_REPORT_URL=“https://bugs.centos.org/”

CENTOS_MANTISBT_PROJECT=“CentOS-7”
CENTOS_MANTISBT_PROJECT_VERSION=“7”
REDHAT_SUPPORT_PRODUCT=“centos”
REDHAT_SUPPORT_PRODUCT_VERSION=“7”

BI Connector Version: 2.13.4

ODBC Driver: Tried with all possibilities 32/64 bit and 1.0/1.4(ascii/unicode)

Marty_Zager · July 4, 2020, 9:23pm

Thanks so much - I had a similar issue to this thread but it was because I didn’t have the compatible version of the Connector for BI.

Vidya_Sagar_Reddy · July 6, 2020, 8:15am

@Marty_Zager, Could you please share me your compatible version for below list and let me try it out,

mongo --version
BI Connector Version
ODBC Mongo DB version.
Unicode or acsii

Pavankumar_Asagalli · May 26, 2021, 3:56pm

I’m also facing the same issue, could you please share us detailed resolution here.

So far have tried using Mongdb driver version 1.0 and 1.4 but no luck.

Thanks,
Pavankumar

vijai_kumar_S · July 9, 2021, 10:27am

The MongoDB BI Connector connects to the MongoDB server on port 27017 and will bridge the NoSQL nature of MongoDB and make its data visible as sort of virtual tables. ODBC driver then connects to the MongoDB BI Connector, typically on port 3307.
so try 3307 instead 27017

Edgar_Cap · December 2, 2021, 11:52am

Please install MongoDB Connector for BI MongoDB BI Connector Download | MongoDB and then:
“C:\Program Files\MongoDB\Connector for BI<VERSION>\bin\mongosqld.exe” and:
2021-12-02XXXXXXXXXXX I NETWORK [initandlisten] waiting for connections at 127.0.0.1:3307
ODBC will work fine on port 3307
Regards

sarath_sr · October 27, 2022, 11:41am

i am facing same issue ,which is the compatible version of the connector for bi

Murali_A · June 19, 2023, 9:02am

I am facing same issues. I have connected at 127.0.0.1:3307. But not fully loaded databases in ODBC driver. Unknown database error. I am not able to connect. Please refer the screenshots and version

OS : Centos 7
MongoDB Version :

MongoDB shell version v4.4.18
Build Info: {
“version”: “4.4.18”,
“openSSLVersion”: “OpenSSL 1.0.1e-fips 11 Feb 2013”,
“modules”: ,
“environment”: {
“distmod”: “rhel70”,
“distarch”: “x86_64”,
“target_arch”: “x86_64”
}
}