This is a manual to install ECDA on Windows Server with MSSQL and connect from SAP Sybase IQ 16 in AIX through Remote Server.

1. – Install ECDA over Windows Server, it is easy, you must install only the ODBC Controller.

2 .- Configure ECDA on Windows Server, it is medium.

  2.1 .-  Start the Create Server wizard by navigating to the  %SYBASE%\DC-15_0\DCWizard directory and executing the DCWizard.bat script.

  2.2 .-  The Welcome Create Server wizard appears. Click Next.

  2.3 .- Select ECDA Option for ODBC. Click Next.

  2.4 .- Enter the server name for the new DirectConnect server and the port number that you want the server to listen on, for example, MYSERVER port 1054. Click Next.

  2.5 .- Enter the ECDA access service name that you want to use for the replicate Microsoft SQL Server database, for example, my_mssql_access_service. Click Next.

  2.6 .- Verify the DirectConnect server information. If correct, select Create Server. Otherwise, click Back to return to the previous window and provide the correct information.

  2.7 .- ** Finish the Create Server wizard, we need to configure the file dcany.cfg before start the service.

  2.8 .- Open the %SYBASE%\DC-15_0\servers\servername\cfg\dcany.cfg file, where servername is the name of the server you created, in this case MYSERVER.

  2.9 .- In the file, locate the name of the Microsoft SQL Server access service that you created. Under that, set:

[Service Library]

{Client Interaction}

[MYSERVER]

{ACS Required}

ConnectionSpec1=MYSERVER

{Client Interaction}

EnableAtStartup=yes

TransactionMode=long

SendWarningMessages=yes

{Target Interaction}

Allocate=connect

SQLTransformation=passthrough

ReturnNativeError=yes

{Catalog Stored Procedures}

CSPColumnODBCVersion=3

3 .- Start the DirectConnect server:

  3.1 .- Open a command window, and navigate to the DirectConnect installation directory. For example: cd c:\sybase\DC-15_0 

  3.2 .- Into the command window, executing the DC_SYBASE.bat script

     C:\sybase\DC-15_0>DC_SYBASE.bat

        1 file(s) copied.

  3.3 .- Go to bin folder:

     C:\sybase\DC-15_0>cd bin

  3.4 .- Start the DirectConnect server. This also starts all of the configured access services: DCStart -SMYSERVER where servername is the name of the DirectConnect server,  in this case MYSERVER.

C:\sybase\DC-15_0\bin>DCStart.bat -SMYSERVER

———————————————————————

Setting environment variables for this install….

Using DC_SYBASE.bat Environment file from:

C:\sybase\DC-15_0

Changing Drive and Directory to $SYBASE\$SYBASE_ECON\bin required for execution:

C:\sybase\DC-15_0\bin

        1 file(s) copied.

        1 file(s) copied.

———————————————————————

Running DirectConnect:

———————

– Using parameters = -SMSSQL_DC

– Command line = C:\Sybase\DC-15_0\connectivity\..\bin\direct -SMYSERVER

———————————————————————

DirectConnect 15.7 SP03

Confidential property of Sybase, Inc.

Copyright 1996-2014

Sybase, Inc.  All rights reserved.

Unpublished rights reserved under U.S. copyright laws.

This software contains confidential and trade secret information of Sybase,

Inc.   Use,  duplication or disclosure of the software and documentation by

the  U.S.  Government  is  subject  to  restrictions set forth in a license

agreement  between  the  Government  and  Sybase,  Inc.  or  other  written

agreement  specifying  the  Government’s rights to use the software and any

applicable FAR provisions, for example, FAR 52.227-19.

Sybase, Inc. One Sybase Drive, Dublin, CA 94568, USA

!READY! Waiting for connections.

Nice, the First Part is concluded

Now, go to SAP Sybase IQ 16 server:

1 .- Configure the interfaces file:

  1.1 .- Add:

MYSERVER

        master tcp ether 192.168.1.169 1054

        query tcp ether 192.168.1.169 1054

2 .- Into Sybase Central or SCC:

  2.1 .- Add the Remote Server:

     CREATE SERVER “MYSERVER” CLASS ‘ASEODBC’ USING ‘MYSERVER’;

  2.2 .-This is very important step, because if there is not EXTERNAL LOGIN the connection do not reach the MSSQL.

CREATE EXTERNLOGIN “DBA” TO “MYSERVER” REMOTE LOGIN “sa”,

  2.3 .- As we configure this server like an SAP SYBASE ASE SERVER (ASEODBC), we can not doing a test connection, it do not ping the target. It is OK.

  2.4 .- To make a real test, we must execute an insert location in this way:

INSERT INTO dba.a

LOCATION ‘MYSERVER.[DBNAMEONMSSQL]’

{select * from dbo.a};

We need to have a dba.a table exactly as into MSSQL a dbo.a table.

With this we finish the configuration.

Please leave your comments.

Santi Jácome

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply