MC Research

 

 

Technical FAQs

These FAQs are intended to assist you once you have purchased our products. If you are interested in more general, pre-purchase questions, please see our Customer FAQs. We have split the sections into Setting Up and Getting Going, Troubleshooting and Tips and Hints.

ODBC

I cannot establish an ODBC connection, what settings can I check?
I cannot establish a TCP/IP connection, how can I check it?
I cannot connect LinkUP to my SQLServer.
Do you have instructions about ODBC connections using OpenLink drivers?
Where do I put the OpenLink ODBC licence file for a single tier driver?
Where do I put the OpenLink ODBC licence file for a multi tier driver?
I am using the OpenLink Bridge driver to connect to my database. When I try to make a connection I receive an error reading (Miscellaneous TLI error). Why?
After running an update I noticed that there is text missing from some of the records which contain long descriptions of over 255 characters. Why?
I am trying to connect to a database on the PC/Server from my MAC but I don’t know the IP Address of the PC/Server for the OpenLInk configuration. What can I do?
I am using SequeLink drivers on a MAC 0S 9.x to connect to my SQL server database. However I cannot view/read “nvar” or “nvarchar” data fields from my SQL database. How do I solve this?
I am having trouble making a connection to my database using the OpenLink Multi-Tier driver.
When I start QuarkXPress on my Mac I receive the error ‘XTension not compatible with this version of QuarkXPress‘, Why?

Dongle Issues

I have a Mac with an ADB dongle and I want to upgrade to a USB, how do I do that?
I see the message ‘Dongle not initialised’ when I try to open LinkUP. I have installed the driver as directed,

Data Source Issues

I cannot update from some DBF files.
I am unable to update, connect to or edit the data source.
On my PC I get LinkUP Error: Error reading data [microsoft][ODBC Excel Driver] Syntex error (missing operator) in query expression ‘field name’ when trying to view certain fields from an Excel spreadsheet through the dataviewer. Why does this happen?
On my MAC when I click on certain fields in my dataviewer and click requery I lose all the data in the viewer. What causes this?
My data in Excel is formatted correctly, but when I update using LinkUP, I lose the commas in my numbers and it adds a .0 to the end of all records, how can I stop this happening?
I have an SQL database and my field named ‘language’ isn’t working properly.
I cannot see the decimal places from a price field in the dataviewer and they are not displayed after update.Why?

Troubleshooting

When I use LinkUP, or the demo, my computer crashes or freezes.
I have created a where statement that I wish to use, However when I try to copy it to the where clause in Configure / Data sources it overruns and cuts the end of my statement off. How do I solve this?
I have downloaded the demo version, followed the directions for Quark 6.0 on PC, and am unable to get the XTension to load. When I startup Quark 6.0 and launch the XTensions Manager, that xtension has stats "Error. XTensions module failed to load."How do I solve this?
My text is being imported as Helvetica or Arial and does not retain the style sheets as set up in my QuarkXPress document?
If I connect to my datasource via Configure, Data Sources, the Markup Tools palette is not auto-populated with field names; why?
I have recently changed the format of my pictures from jpeg to tiff, Now whenever I run an update my pictures are not imported. Why?
I receive the following error when trying to import or export from my database: ODBC syntax error reading ‘field name’. Why?

Tips And Hints

How do I filter the data viewer record set (I can only see 200 of my fields at a time)?
Some pointers on Character Maps.
We want LinkUP to export text to the Quark document that has tags applied to it, ie <b>Bold</b> and <I>Italic</I>. Can LinkUP do this?
Can I reconfigure LinkUP so it doesn’t sort by key?
How can I find my LinkUP serial number and dongle (security code) on my Mac?
How do I create a relational database based on my Quark document using the LinkUP Enterprise export function?
When building a relational document, the next item starts at the end of the last line. I want the markup to include the return character.
If I convert my documents from QuarkXPress 4 to QuarkXPress 6 will the LinkUP markups remain in place?
I want to create a multi-level build (relational build) using a template, how do I do this?
Is it possible to change the colour of my text box when I run an update?
How do I filter my data via LinkUP so I can build in sections?
How do I use the mail merge function?

 

ODBC

Q   I cannot establish an ODBC connection, what settings can I check?
A   Check the following:

     1 Check that you have ODBC drivers installed on your computer for your specific database format. If not, find an ODBC supplier, such as Actual Technologies or OpenLink and download a demo driver.
     2 Make sure that there is a physical connection between your computer and the computer holding the data source – ie, they are on the same network.
     3 Run an ODBC test. There are various ODBC testers available on the Internet or contact us for help.

Q   I cannot establish a TCP/IP connection, how can I check it?
A   Try the following:

     1 Check you have ODBC drivers installed on your computer for your specific database format.
     2 Make sure that there is a physical connection between your computer and the computer holding the data source, ie, on the same network.
     3 On Macs, check that TCP/IP is set to E/NET and not to PPP in the Apple Talk Control Panel.
     4 Ensure that your computer and the one containing the data source have the appropriate subnet masks to enable them to see each other, eg:
     Server Address 192.0.0.1 Subnet Mask 255.255.255.0
     Mac Address 192.0.0.2 Subnet Mask 255.255.255.0.
     5 Try to ‘ping’ the server. (Ping is a utility that confirms that the connection between two TCP/IP computers exists. This type of program is either provided with your network card software or available for free download from the Internet.)
     6 Ensure that your network protocol is set to TCP/IP and the host TCP/IP address is entered correctly in the ODBC setup control panel.

Q   I cannot connect LinkUP to my SQLServer.
A   Please check the following:

     1 TCP/IP protocol is installed on the SQLServer itself. Note: Default installation will NOT install TCP/IP, the server needs to be stopped and restarted.
     2 TCP/IP on the Mac needs to be installed and configured to be in the same subnet as the server, ie, if the server has an address of 192.168.x, then your computer must have an address of 192.168.x (where x is a number between 1 and 255, excluding number 10 and any other used by existing network devices).
     3 Ping the server from your computer.
     4 Check ODBC components are installed correctly on your computer. It should have an ‘ODBC Setup PPC’ control panel available as well as the SequeLink folder.
     5 Check ODBC components are installed correctly on the server. The NT server should have a SequeLink program group and the administrator should be run and the process started.

Q   Do you have instructions about ODBC connections using OpenLink drivers?
A   Yes, please see below for your particular configuration.

      For Mac OSX
      1 How to link MS Access on PC to QuarkXpress on Mac
      2 How to link MS Excel on PC to QuarkXpress on Mac
      3 How to link MS SQL on PC to QuarkXpress on Mac
      4 How to link Oracle on PC to QuarkXpress on Mac

      For Mac OS9 and OS9 Classic
      1 How to link MS Access on PC to QuarkXpress on Mac
      2 How to link MS Excel on PC to QuarkXpress on Mac
      3 How to link MS SQL on PC to QuarkXpress on Mac
      4 How to link Oracle on PC to QuarkXpress on Mac

Q   Where do I put the OpenLink ODBC licence file for a single tier driver?
A
   The licence file should be placed in one of the following locations depending on the OS you are using.

Mac OS X - The licence should be placed in the following directory:
Macintosh HD/Library/Application Support/OpenLink/Bin

Mac OS 9 or 9 Classic – The licence file should be placed in the following directory:
System Folder/Preferences

Q   Where do I put the OpenLink ODBC licence file for a multi-tier driver?
A
   The licence file should be placed in the following location:

C:\Program Files\Openlink\Bin

Q   I am using the OpenLink Bridge driver to connect to my database. When I try to make a connection I receive an error reading (Miscellaneous TLI error). Why?
A   This is because you are using two different versions of OpenLink drivers on the server and client eg: OpenLink driver V5.0 on the client and OpenLink driver V5.1 on the server. To solve this problem uninstall current drivers on both the client and the server, making sure you take a copy of the licence file (oplrqb.lic) from the OpenLink / Bin directory on the server. Then download and install the latest set of drivers from OpenLink

Q   When using LinkUP with OpenLink drivers to run an update I noticed that there is text missing from some of the records which contain long descriptions of over 255 characters. Why?
A   This is because you did not uncheck the "Defer fetching of long data" option from Options tab in the ODBC Administrator on the client. Please download our instructions describing where this option can be changed.

Q   I am trying to connect to a database on the PC/Server from my MAC but I don’t know the IP Address of the PC/Server for the OpenLInk configuration. What can I do?
A   You can use the server name instead of the IP address simply by inputing the computer name in the Hostname section of the OpenLInk configuration screen.

Q   I am using SequeLink drivers on a MAC 0S 9.x to connect to my SQL server database. However I cannot view/read “nvar” or “nvarchar” data fields from my SQL database.
A
   SequeLink does not support nvar and nvarchar field formats.

Q   I am having trouble making a connection to my database using the OpenLink Multi-Tier driver.
A
   If you have researched the other ODBC issue solutions on these technical FAQs and had a look at OpenLink's Online technical support (www.openlinksw.com), Please download these instructions explaining how to create an OpenLink log file. This may enable us to see where your problem lies. Once you have created the file, email it to us on support@mcresearch.co.uk

Q   When I start QuarkXPress on my Mac I receive the error ‘XTension not compatible with this version of QuarkXPress‘, Why?
A
   There are three possible reasons for this error to occur.

     1 Check that you are running the appropriate version of QuarkXPress..
     2 Make sure you have the dongle drivers correctly installed (If running with a full version of LinkUP).
     3 Make sure you have an ODBC driver installed. If you have version 3.52 of the OpenLink drivers installed, you will need to copy the folder 3.52 from
Macintosh HD/Library/Frameworks/iODBC.Frameworks/Versions and paste it back to the same location renaming the folder to ‘3.51’.

Dongle Issues

Q   I have a Mac with an ADB dongle and I want to upgrade to a USB, how do I do that?
A   We have a dongle exchange policy by which we exchange dongles for the cost it takes to cover the hardware, reprogamming and courier. ADB dongles are now defunct, please visit our Upgrades page for details.

Q   I see the message ‘Dongle not initialised’ when I try to open LinkUP. I have installed the driver as directed, what now?
A   Check the following:

     1 Ensure your IT department have the USB controller enabled, the dongle is securely plugged in and you have downloaded the appropriate driver.
     2 Download this dongle medic application to see if your dongle is detected.

Data Source Issues

Q   I cannot update from some DBF files.
A   DBF drivers to not support non-DOS file naming conventions, so make sure that there are no non-DOS characters or spaces in the table names (alph-numeric only). Also ensure that the file names are less than ten characters.

Q   I am unable to update, connect to or edit the data source.
A   It could be that only characters A-Z are allowed in the data source names and characters other than these A-Z, eg, spaces or underscores, may have been used. Rename the data source names.

Q   On my PC I get LinkUP Error: Error reading data [microsoft][ODBC Excel Driver] Syntex error (missing operator) in query expression ‘field name’ when trying to view certain fields from an Excel spreadsheet through the dataviewer. Why does this happen?
A   
This is happening because you have spaces in the field name. This can be proved by removing any fields from the dataviewer with a space in the field name and hit requery you will see all the data from fields that do not contain spaces in their field names. Field names should not contain spaces or uppercase, or any non alphabetical or numerical characters.

Q   On my MAC when I click on certain fields in my dataviewer and click requery I lose all the data in the viewer. What causes this?
A   This is happening because you have spaces in the field name. This can be proved by removing any fields from the dataviewer with a space in the field name and hit requery you will see all the data from fields that do not contain spaces in their field names. Field names should not contain spaces or uppercase.

Q   My data in Excel is formatted correctly, but when I update using LinkUP, I lose the commas in my numbers and it adds a .0 to the end of all records, how can I stop this happening?
A   Please see this Excel document with formulas to prevent this. The explanation of ‘why’ is in the document.

Q   I have an SQL database and my field named ‘language’ isn’t working properly.
A   You will have to rename this field. For some reason it conflicts with other command calls!

Q   I cannot see the decimal places from a price field in the dataviewer and they are not displayed after update.Why?
A   This is due to the database format, Please download the access database and view the query field format to amend this configuration.

Troubleshooting

Q   When I use LinkUP, or the demo, my computer crashes or freezes. (This question and answer is mainly for legacy systems, it is not a problem in current versions of LinkUP.)
A   Please check the following:

     1 Mac OS versions should be compatible with the programs.
     2 If you are currently running OS9.0, it is recommended that you upgrade or use ATM 4.6.1 (Adobe Type Manager) or the latest version. Also for older OS’s, please ensure you have the Font Manager Patch available from www.adobe.com/support.
     3 QuarkXPress should have a minimum of 25MB (set under ‘get info’ in the QuarkXPress application file).
     4 On Macs, the ATM should be set up as follows (ATM is accessible via the ‘Apple’ list, or in Control Panels):
         • Cache size - 2Mb minimum
         • Preserve character shapes - ON
         • Smooth font edges on screen – ON
         • Disable smoothing at screen font sizes - OFF
         • Precision character positioning – ON
         • Enable font substitution - OFF
         • Enable auto activation - GLOBAL
  Also ensure:
a. Virtual memory OFF (under memory control panel).
b. TCP/IP installed and configured.
c. ODBC installed and configured.
d. Create a duplicate folder, copy QuarkXPress application into this folder. Inside this folder create an XTensions folder and copy the LinkUP and Xpress tags filter into this folder. Launch this copy of QuarkXPress by double clicking on the QuarkXPress icon. (This is to ensure that other Xtensions are not interfering with LinkUP)
e. Ensure that you are running only ONE of the LinkUP XTensions by placing it in the XTensions folder within the QuarkXPress folder by double clicking the QuarkXPress folder you are currently running. 
f. If you are working with ASCII text files only, you will need to request the LinkDB version (which is not compatible with Quark V.5 or V.6). 

Q   I have created a where statement that I wish to use, However when I try to copy it to the where clause in Configure; Data Sources it overruns and cuts the end of my statement off. How do I solve this?
A   LinkUP will work with up to 64 characters for the 'where' statement. If your statement exceeds this limit then you will need to query your data from within your database to achieve the required results.

Q   I have downloaded the demo version, followed the directions for Quark 6 on PC, and am unable to get the XTension to load. When I startup Quark 6 and launch the XTensions Manager, that xtension has "Error. XTensions module failed to load." How do I solve this?
A   You will need to run the Quark updater for Quark 6.1, this is available free of charge at www.quark.com. If you are running Quark 6.0 on a MAC you will also need to install ODBC before LinkUP can run. Please read the Tutorial Essentials.

Q   My text is being imported as Helvetica or Arial and does not retain the style sheets as set up in my QuarkXPress document?
A   This is a recognised issue with QuarkXPress 6.5. The text can be re-styled after import. We are awaiting an update from Quark.

Q   If I connect to my datasource via Configure, Data Sources, the Markup Tools palette is not auto-populated with field names; why?
A   If you want to autopopulate the Markup Tools palette, create a New View via the Data Viewer. The full setup/configuration way of creating field names is to do so manually and assumes you wish to create your specific field names for markups and their entire configuration individually.

Q   I have recently changed the format of my pictures from jpeg to tiff, Now whenever I run an update my pictures are not imported. Why?
A   If you change the format of your images you will also need to replicate the change in your database image reference field or set a find and replace rule for the image filed using LinkUP Configure; Field Links.

Q   I receive the following error when trying to import or export from my database: ODBC syntax error reading ‘field name’. Why?
A
   This error may occur if your field names are the same as the reserved function names in your database for example Microsoft Access has reserved functions such as Time, Desc, Note. Download the attached PDF for a full list of reserved function names.

Tips and hints

Q   How do I filter the data viewer record set (I can only see 200 of my fields at a time)?
A   To filter the data viewer please download and follow these instructions.

Q   Some pointers on Character Maps.
A   Characters are always translated both on input and output.
Current character mapping is saved with the document and within the project, ie, reloading the project file will reconfigure maps accordingly. You can change the current mapping by loading the character map files. This action is accessible by selecting LinkUP, Configure, Character Map.

The following notes apply when producing your own custom map files. Please also refer to this Character Map document:
- Input and output terms are relative, depending on the data flow direction. Input value is the value expected from the database during document update/build.
Output is the new (replaced) character during the same process. So, for example, A from the database needs to be B on the page during database to page flow:
A \066
B \066
The mapping would search down the input side of the list and take the first match. It would match the first A (ASCII 65) and replace with the new output value 66 which, in this case is B.

- If the process is reversed, ie exporting from Quark to the Database, input value is the value expected to be sent to the database, output value is the character to be found in the Quark document. So, for example, if A from the document needs to be B in the database during the page to database flow:
A \065
B \066
The mapping would search down the output side of the list and take the first match. So first matching A value (ASCII 65) will be replaced with the new input character B. In case of multiple matches, the first encountered match will be executed. Ie, if you have several places where you mapped A to B in the first instance and C in the second instance, only B would ever be output.



Q   We want LinkUP to export text to the Quark document that has tags applied to it, ie <b>Bold</b> and <I>Italic</I>. Can LinkUP do this?
A   Yes, choose LinkUP Tags on export. In the LinkUP menu in Quark, pick Configure>Field Links, pick the ‘Basic Actions’ button and in ‘During Update Process Tags as:’ choose ‘LinkUP’ radio button.

Q   Can I reconfigure LinkUP so it doesn’t sort by key?
A   Yes, Click on LinkUP / Configure / Datasources, select the datasource you wish to sort and click Edit. In the Order By field type the name of the field you wish to order, this will sort the field in alphabetical ascending order. To sort the same fields in descending order leave a space after the field name and type desc. You can also sort by multiple fields by typing a (, ) before typing any additional fields to order by.

Eg: Order By: product desc, description. This will sort your data with descending product then description.



Q   How can I find my LinkUP serial number and dongle (security code)?
A   There are two ways in which you can acheive this. The first is to enable LinkUP from the utilities menu and click LinkUP / About LinkUP from within Quark and the second is to download the relevant application below and click update security key. This will provide you with both the LinkUP serial number and the dongle (security key) reference number.
     MAC OS9
     MAC OSX

     PC

Q   How do I create a relational database based on my Quark document using the LinkUP Enterprise export function?
A
   Download instructions here. (.zip file includes Quark template, MS Access Database and full instructions).

Q   When building a relational document, the next item starts at the end of the last line. I want the markup to include the return character.
A   In the Markup Properties extended palette, you need to ensure that you have the correct amount of ‘Offset Characters’ configured. Ie, if the return is the next character on from the end marker, you need to have End Offset Character as 1. The same can be used for formatting prior to the start marker.

Q   If I convert my documents from QuarkXPress 4 to QuarkXPress 6 will the LinkUP markups remain in place?
A
   Yes (presuming you have upgraded to the relevant version of LinkUP). You may need to change your datasources or picture paths but the links should remain embedded. Remember you may open a QXP4 document in QXP6 but, once opened, you will not be able to open it again in QXP4 unless you save back via QXP5. Always ensure you have a clean copy of the QXP4 document to revert to in case of problems. (Only QuarkXPress 6 and 7 are currently supported.)

Q   I want to create a multi-level build (relational build) using a template, how do I do this?
A
   Download these instructions for a simple three level build (LinkUP Enterprise only). The download includes detailed instruction on how to markup the document, a sample Access database and a QuarkXPress template. The document is for Quark 6 on a PC, but can be used on a Mac too. If you need any further instructions about ODBC connections, please download the demo bundle and see the Tutorial Essentials document.

Q   Is it possible to change the colour of my text box when I run an update?
A
   Yes, please download our tutorial for box colour updates

Q   How do I filter my data via LinkUP so I can build in sections?
A
   You can build in sections by applying a where statement.

Q   How do I use the mail merge function?
A
   Download this tutorial explaining how to setup and configure LinkUP to use the mail merge facility.

Copyright © 1993-2008 MC Research Ltd | Sims Designs