How to Connect to MongoDB

Connectivity via ODBC Driver in Windows OS

Users may encounter the following error message when attempting to connect to MongoDB with the Strategy ODBC Driver for MongoDB on Windows OS:  "java.lang.NoClassDefFoundError: com/ddtek/mongodbcloud/sql/JniCommunicator"

CAUSE  

The user has manually created the DSN in the Windows ODBC Administrator instead of using the Strategy Connectivity Wizard.  The Connectivity Wizard creates the DSN with all of the correct values for JVM Arguments, JVM Classpath and Extended Options.  It is the supported manner in which to create DSNs for use with Strategy.

ACTION 

Create the DSN using the Strategy Connectivity Wizard instead of manually creating the DSN in the Windows ODBC Administrator. The Tech Note KB262252 explains how to use the Connectivity Wizard to create DSNs for MongoDB.

Connectivity via JDBC Driver

From M2021Update1, users may encounter the following error message when attempting to connect to MongoDB with the Strategy JDBC:  "The connection options used to create the database do not match the options used to create the database. "

CAUSE  

The user has connected to MongoDB with Strategy ODBC, then connect to MongoDB with Strategy JDBC without defining schema path in the connection string. The connection with Strategy JDBC uses the same schema path with Strategy ODBC. 

ACTION 

Define schema path in the JDBC connection string. 
JDBC;DRIVER={com.Strategy.jdbc.mongodb.MongoDBDriver};URL={jdbc:Strategy:mongodb://@ip:@port;DatabaseName=@db;SchemaDefinition=@SD;ValidateServerCertificate=false;EncryptionMethod=noEncryption};