Skip to Content

Connection failing MS-SQL to Sybase IQ using Sybase REP 15.7

Hello,

Trying to Establish a connection in SAP Replication Server 15.7

Source - MS-SQL 2008

Destination - Sybase IQ 16

Syntax :

create connection to WIN-1MOHFVXCWFB\MFNETDEV.MF_NET 
using profile rs_msss_to_iq;standard
set username to MAINT_USER
set password to maint_user_ps
go

Showing syntax error near using... Tried providing the connection name inside single Quote (') & double quotes(") with square braket [] .... but no use.

In the windows source system (MSSQL), have done all the Pre-Requisites like sybfilter driver , MSSQL jdbc driver and setting up its path and other things.

Can anyone help on this?

Thanks,

Yuvaraj Subramani

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 05 at 07:44 PM

    Looks like a named instance on MSSQL.

    Backslashes and hyphens can make it difficult.

    My Suggestion :

    First try a simple main MSSQL server without hyphen in name. Then expand to named server.

    It may be as simple as using "\\" in place of one. Or escapinging "-" with "\-"

    Also this command (create ... using profile) has a "display_only" option.

    See what output it generates and if you can executed these commands by hand.

    I have used this in context of ECO -- express connect from ASE to Oracle. And it took me a few iterations to get the permissions, connector, AIX variables, etc. right. I used display_only option to see what commands were bing sent and checking each by hand.

    I also had SAP/Sybase case opened to sort errors as I progressed slowly.

    HTH

    Avinash

    Add comment
    10|10000 characters needed characters exceeded