You need to edit the Windows registry to add the the required connection attribute. However, these values do not include the required attribute for the latest driver. No - If you choose not to delete the existing DSNs, the values of the DSNs are kept. For more information, see Using the ODBC Administrator Tool. This DSN includes the required attributes of the latest driver. Yes - If you choose to delete the existing Data Source Names (DSN) you need to create a new DSN after installing the new driver. You can choose one of the following options: You are asked if you want to delete the existing ODBC DSNs. Right-click the driver file and click Uninstall. Locate the existing driver file on your machine. To uninstall the old driver and install the latest driver: For more information, see Configuring the ODBC Data Source on Windows. Note that you may need to create additional DSNs manually, if you want to connect to another server or you want to select between different account types, for example, both production and sandbox. When you run the installer, you must review the content and add the Account ID and Role ID to get a DSN. If you install the driver on Windows as domain administrator, the installation process may fail. The fallback content configures the default service host without any role IDs or account IDs.Īfter you downloaded the Connect driver, ensure that you install it as local administrator. If you use only the installer file and there is no dsn.ini file, then fallback content is provided during installation. This installer can create generic System DSNs. Use this approach if you want to install the driver or automated services. For more information, see Installation Prerequisites.ĭownload an installer if you do not want your current user context data to be used. A key field has a unique value for each record allowing for each individual records to be properly identified.Before you install or upgrade the Connect driver, ensure that you meet the installation prerequisites. Press ‘Execute’ to execute the query, if the query has been successful it will show fields and some data in the ‘Sample’ area.įinally before creating the data view a Key field must be set, sometimes Eas圜atalog will detect this automatically depending upon the data. The encoding should be set to the same encoding as the ODBC driver. The statement now needs to be modified to select from the correct table (if unsure of which table to use, the available tables are shown by selecting the ‘Tables…’ button), in this case the table is called ‘MyFileMakerDatabase’. The ‘Tables…’ button if supported by your driver, will show a list of the tables in that data source. Alter USER/PASS with the details appropriate to the host. This is done by adding ‘UID=USER PWD=PASS ’ to the connection string. However in order for Eas圜atalog to connect, a username and password must be specified. This will open the dialog shown in the screenshot below.Įnter a name for the data source in the ‘Name:” field and select the data source that the connection is being made to from the drop down list.Įas圜atalog will automatically alter the ‘DSN= ‘ to the data source that was selected in the drop down list. To create a new ODBC Data Source in Eas圜atalog navigate to ‘New > Eas圜atalog Panel > New ODBC Data Source’. Setting up Eas圜atalog to use an ODBC Data Source is a straight forward process aslong as the data source has been configured correctly in the ODBC Administrator/ODBC Data Sources application. The ODBC Data Provider is required for this article
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |