Re: HELP MONGO ODBC AUTH is the problem.

neipia · 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 · 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