Connecting with Sybase Advantage Database

• jamesnt

  SSC Eights!

  Points: 846

  More actions

  June 8, 2011 at 11:03 am

  #251469

  I have a Sybase Advantage Database server, not a member of my domain, that I need to connect to using SSIS to read/write data with.

  I have SQL Server 2008 64-bit with the latest service packs and patches and I have downloaded the OLE DB driver from sybase.

  The Advantage database is version 7.10.0.0 and is running on Server 2003 32-bit.

  When I set up the connection manager, it gives me error message 6420 - discovery failed. I think I am setting the connection manager up incorrectly.

  The Advantage Server's mwddf.add file is at \\192.168.1.200\medidata\carolina\mwddf.add (we are connecting across a VPN).

  How should I put the settings in place for the connection manager?

  Here is what I have now:

  Server or Filename: \\192.168.1.200\medidata\carolina\mwddf.add

  username: myusername

  password: mypassword

  Initial Catalog: blank

  Advantage Character Data Type: ADS_ANSI

  Advantate Communication Type: Blank

  Advantage Compression: blank

  Advantage Encryption password: blank

  Advantage Filter Options: IGNORE WHEN COUNTING

  Advantage Locking Mode: ADS PROPRIETARY LOCKING

  Advantage Security Mode: ADS_IGNORERIGHTS

  Advantage Server type: ADS REMOTE SERVER

  Advantage Table Type: ADS ADT

  Connect Timeout: 0

  Mode: Read/Write

  Am I missing something or doing something wrong?

  JamesNT