ODBC.png' alt='64-Bit Isam Odbc Driver' title='64-Bit Isam Odbc Driver' />USQL Frequently Asked Questions. Can USQL be deployed in a Citrix environment USQL is currently deployed in a Citrix environment by a number of customers. In order to deploy USQL successfully in Citrix, the following elements are required to be configured and licensed Transoft USQL server, installed on the Citrix server and licensed with sufficient concurrent users to handle the number of client users. Dynamics_CRM_ODBC_Driver_32_64_bit_web_search_for_windows.png' alt='64-Bit Isam Odbc Driver' title='64-Bit Isam Odbc Driver' />Transoft USQL client, installed on the Citrix server and licensed as a gateway client. Each user is able to access USQL via a Citrix client, presenting them with a virtual desktop, and permitting multiple users to access the USQL client software. Please contact Transoft Customer Services if you require further information or assistance with deployment of USQL in a Citrix environment. Is USQL compatible with my operating system Transoft USQL is compatible with a multitude of operating systems, including Windows Server 2. Windows 7, XP and VISTA. Microsoft Data Access Components MDAC also known as Windows DAC is a framework of interrelated Microsoft technologies that allows programmers a uniform and. Describes how to import data from Excel worksheets to SQL Server databases. Microsoft Excel Microsoft SQL Server. Heg/TmYoexru3kI/AAAAAAAAAAc/hEOVS-c4PqE/s1600/Untitled.png' alt='64-Bit Isam Odbc Driver' title='64-Bit Isam Odbc Driver' />IBM AIX. Unix. Ware For specific Operating System version compatibility information, please refer to USQL Current Releases or contact Transoft Customer Services. Additional builds of USQL for other Operating Systems may also be available, or can be requested via Transoft Customer Services. Information regarding 6. Windows Operating Systems. A 6. 4 bit Transoft ODBC driver is available, and is installed automatically, together with the 3. Transoft ODBC driver, when the USQL Client software is installed on a 6. Windows operating system. SimbaEngine X increases developer productivity and allows you to build a custom ODBC driver in as few as five days. I found a solution for this problem. The issue I described in my question occured basically due to the incompatibility of the Microsoft. Jet. OLEDB. 4. 0 driver in 64 bit OS. The administrative tools that are installed with the USQL client are currently all 3. DSNs. Currently, 6. DSNs must be administrated from the Windows ODBC Manager. Is USQL compatible with my data source Transoft USQL supports the following Data Source types, across various operating systems ACUCOBOL. Micro Focus COBOL. D ISAM For specific information about data source type availability on your platform, please refer to USQL Current Releases or contact Transoft Customer Services. If you have a requirement for USQL to be made available for a data source that is not listed above, please contact Transoft Customer Services. The configuration process and product functionality can differ between each data source, so please refer to the USQL user guide for full details. How do I create a new UDD for COBOL data USQL uses the data descriptions metadata in the Universal Data Dictionary UDD to provide relational access to non relational data. The UDD is created using information in the Universal File Dictionary UFD, which describes the physical structure of the non relational data structures. There are two methods for producing the UFD and UDD For ACUCOBOL and Micro Focus COBOL users, the UFD and UDD can be produced automatically using COBOL File Definitions FDs and the USQL Manager. For other data sources, the UFD must be created first and then the UDD is generated automatically. Creating a UDD using the USQL Manager. Note that this section describes the basic steps required to create a UDD using the USQL Manager. Please refer to the sections Planning to Use USQL Manager, Using USQL Manager to Create a UDD and Modifying a UDD within the USQL user guide for full instructions. Step 1 Start the USQL Manager The USQL Manager can be loaded from the Windows Start menu under Programs USQL Client. Once opened, select New Data Dictionary from the Main Menu Step 2 Configure the UDD Two dialog boxes will follow, asking you to choose the data dictionary type, and a name for the dictionary. Once these have been completed, the 3. ODBC Setup window will appear, asking you to specify the name and port of the USQL Server Step 3 Prepare to import FDs A blank UDD will now have been created using the name you have specified. Use the New option on the right hand side, or the FD Import icon at the top to open the COBOL FD Converter Step 4 Browse for FDs Clicking the Name button will open a new browsing window, which you can use to navigate and select the COBOL FD file that you wish to add to the UDD Step 5 Convert FDs to tables Once the FD is selected, click the Convert button the USQL Manager will immediately show all files referenced in the selected FD, and show the table name that will be created for the UDD. You can modify this name by using the Rename button. Finally, to add one or many tables to the UDD, select them using the respective checkbox, and click Write Chosen. These new tables will now be listed in the Data Dictionary Maintenance window How do I create a new UDD for non COBOL data USQL uses the data descriptions metadata in the Universal Data Dictionary UDD to provide relational access to non relational data. The UDD is created using information in the Universal File Dictionary UFD, which describes the physical structure of the non relational data structures. To create the UDD for non COBOL data sources, the UFD must be created first and then the UDD is generated automatically. A UFD file is a plain text document which describes the file structures of your source data. This is used by USQL to generate a UDD. Examples and assistance for creating UFDs can be found within the USQL User Guide,refer to the section Specific UDD Information. How To Improve The Readability Of A Program. Once you have created a UFD, follow the steps below to create a new UDD. Step 1 Create the UDDWindows. In a Windows environment, UDDs are created using the Win USQLi utility, from the USQL Client program group. From the File menu, select New UDD, and name the new dictionary. This will generate a blank UDD. If you wish to prove that the UDD has been successfully created, run the query select from uddtables from the Win. USQLi interface, and a list of system tables should be returned UNIX or Linux From a command line interface, navigate to the USQL bin directory. Execute the following command to create a new blank UDD. This will create the new UDD with the name you specified Step 2 Import the UFDs Windows. Using Win USQLi, select Import from the Table menu. This opens a browse window. Locate the UFD you have created earlier and select it. UNIX and Linux Using a command line interface, open the usqli utility, and connect to your new UDD. Run the following command within usqli Import lt name of UFD This will automatically populate the UDD using the information contained within the UFD. Repeat this for all UFDs. Step 3 Update the UDDWindows. Using Win USQLi, select Update from the Table menu. UNIX and Linux The UDD update is executed from a command line by running the following. UDD Once completed, usqli will inform you that the UDD tables have been successfully updated Can I configure my DSN as a Linked Server MS SQL ServerIn order to established a Linked Server connection between Microsoft SQL Server and USQL, you must ensure that USQL is installed and configured, and that the DSN that you wish to connect to can be queried using other tools such as Win USQLi. The instructions provided below are based on Microsoft SQL Server 2. The process for creating Linked Servers using other versions of Microsoft SQL Server is likely to be similar please contact Transoft Customer Services for further assistance.