Re: HELP MONGO ODBC AUTH is the problem.

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
neipia
Posts: 4
Joined: Tue 17 Mar 2020 01:22

Re: HELP MONGO ODBC AUTH is the problem.

Post by neipia » Wed 18 Mar 2020 02:09

DRIVER=Devart ODBC Driver for MongoDB;Description=Devart ODC Driver for MongoDB;Data Source=127.0.0.1;Database=soft;Client Library=C:\Program Files (x86)\Devart\ODBC\MongoDB\Win32\libmongoc-1.0.dll;BSON Library=C:\Program Files (x86)\Devart\ODBC\MongoDB\Win32\libbson-1.0.dll

As source above, the table is called normally without authentication.



DRIVER=Devart ODBC Driver for MongoDB;Description=Devart ODC Driver for MongoDB;Data Source=172.0.0.1;Database=MT;User ID=aabb;Password=aabb;Client Library=C:\Program Files (x86)\Devart\ODBC\MongoDB\Win32\libmongoc-1.0.dll;BSON Library=C:\Program Files (x86)\Devart\ODBC\MongoDB\Win32\libbson-1.0.dll;Connection Options="authMechanism=SCRAM-SHA-1"

The connection is made from the source above, but the table to be authenticated cannot be read.
However, the monodb compass connects normally.
If you go through ODBC, you will not be able to read the table.
The error message
SQLSTATE = S1000 [Devart][ODBC]{MongoDB]no such table : table name

I am connected, but I can't access the table because I can't authenticate.

ViktorV
Devart Team
Posts: 2853
Joined: Wed 30 Jul 2014 07:16

Re: HELP MONGO ODBC AUTH is the problem.

Post by ViktorV » Wed 18 Mar 2020 14:33

Please don't create duplicated topics. I answered to you at the topic: viewtopic.php?f=55&t=39978

Post Reply