Get Data Moving 1
Results 1 to 2 of 2

Thread: SQL Server Linked Sever to attunity

  1. #1
    mike--mike is offline Junior Member
    Join Date
    Jan 2010
    Posts
    1
    Rep Power
    0

    SQL Server Linked Sever to attunity

    Hello - I'm quite new to attunity (and linked servers)... I'm trying to setup a linked server to our attunity.

    We have an attunity set up and running which we use for our crystal reporting. I want to set up the linked server to be able to create union views with other databases.

    Can't find much guidance on the net about how to do this (ie the settings to enter after selecting 'new linked server' in MS SQL Server Management Studio...

    Any tips or advice would be most gratefully received! Thanks - Mike

  2. #2
    ussupport1 is offline US Support
    Join Date
    Sep 2006
    Posts
    49
    Rep Power
    0

    Crystal Reports

    Mike,
    When using Crystal reports we recommend using a Kagera type connection using Microsoft OLEDB to connect to an Attunity ODBC driver. Crystal reports provides an ODBC 3.5 layer and our driver is an ODBC 2.5 layer. For this reason you use an MS OLEDB connection, MS OLEDB for ODBC Drivers, or on later versions ADO.NET for ODBC drivers. When making this connection user the ID NAV and the password NAV (case sensitive). As a quick exercise I had customers create a file on their desktop called testlink.udl. Once this is created you can right click on the file/properties and configure a Universal data Link using the methods I suggested above. This just show the list of providers and what is registered and available on the machine. Please note, not all Windows installations have a full or updated MDAC (Microsoft Data Access Components) and you can download this separately from Microsoft to get the latest and greatest. If .NET is installed we recommend getting the latest for this environment also.

    Thanks,
    Attunity Support
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •