June 8, 2011 at 11:03 am
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
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply