In order for SenseTalk to establish a connection to a database using ODBC, you must supply SenseTalk with a connection property list. For more information about configuring DSNs, refer to the documentation for your ODBC driver or database.
#WINDOWS ODBC MANAGER INSTALL#
You must install a driver and configure a couple of files.ĭownload and extract or install the appropriate 64-bit ODBC driver for your target database and the operating system where Eggplant Functional is installed.Ĭreate and configure the "odbc.ini" file (where you create DSNs) and the "odbcinst.ini" file (where you specify driver installation locations) in the /etc directory, which is where Eggplant Functional expects them to be. Linux releases of Eggplant Functional include an ODBC driver manager, so you don't need to install one. You must install the 64-bit version of the appropriate ODBC driver for your database. We have successfully tested ODBC Manager for Mac, which features a GUI where you can configure your DSNs. Mac operating systems do not include ODBC driver administration software, so you need to install a third-party ODBC manager in addition to any ODBC drivers.
#WINDOWS ODBC MANAGER DOWNLOAD#
To connect to MySQL, for example, you’ll need to download a 64-bit ODBC driver. You must also download the appropriate 64-bit ODBC driver for your database. The 64-bit ODBC Administrator: C:\Windows\system32\odbcad32.exe. This administrator can be found in the following location:
#WINDOWS ODBC MANAGER WINDOWS 10#
Windows 8, and Windows 10 provide an ODBC administrator for 64-bit applications.
It manages and loads the ODBC drivers, and it also provides a graphical user interface (GUI) where you can configure DSNs. The ODBC driver manager on Windows is called the ODBC Data Source Administrator. The Driver Manager manages the ODBC driver and allows Eggplant Functional to load and use the ODBC driver. The DSN is defined in your ODBC Administrator or odbc.ini file. This information is part of your Data Source Name (DSN) definition. Not necessary on Linux.ĭata Source Information: This information specifies the connection information for your specific database, and must include the server name, IP address, port, and credentials. OCBC Driver Manager: This manages the ODBC driver and allows Eggplant Functional to load and use the ODBC driver. Install this driver on the machine where you run Eggplant Functional, and make sure it is the same version (32-bit or 64-bit) as your installation of Eggplant Functional. You must install the appropriate driver for the type of database you want to access. ODBC Driver: This allows Eggplant Functional and the target database to communicate. That said, accessing a database using ODBC requires three things: Requirements for using ODBC vary between operating systems. This can be tested using the DSN in your ODBC Administrator or odbc.ini file. Important: Once you have set up the connection using the information below, test it to ensure the connection is working before trying to define the connection in an Eggplant Functional script.
0 kommentar(er)
