Connecting to any other datasource
You can connect BiG EVAL to any other datasource not listed in the documentation.
Please ensure that the following requirements are met:
- Install an OLEDB or ODBC driver on your BiG EVAL server.
- BiG EVAL is a 64bit application. Therefore, you always need a 64bit driver.
- BiG EVAL is a 64bit application. Therefore, you always need a 64bit driver.
- Create a datasource in BiG EVAL and choose either OLEDB or ODBC as the type.
- When using OLEDB:
- Lookup the connection-string for your driver on connectionstrings.com. Use the one, that contains the Provider= property.
- When using ODBC:
- Create a System-DSN (not a user-dsn) in the 64bit ODBC DSN Manager.
- As a connection-string in the BiG EVAL datasource try to use the most simple version at first. Usually that’s enough:
DSN=MyDsnName; - When you store user and password within your ODBC DSN, you usually don’t need to enter them in the connection-string again. Otherwise use:
DSN=MyDsnName;UID=MyUsername;PWD=MyPassword; - Use connectionstrings.com for more information about the specific connectionstring of your driver.
- When using OLEDB: