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
