Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Replicating from SQL Server to Sybase using SQL Server replication

6 posts in General Discussion Last posting was on 2010-09-09 19:09:46.0Z
WW Posted on 2010-09-06 14:57:18.0Z
Sender: 4666.4c84ff80.1804289383@sybase.com
From: WW
Newsgroups: sybase.public.ase.general
Subject: Replicating from SQL Server to Sybase using SQL Server replication
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4c85014e.4694.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 6 Sep 2010 07:57:18 -0700
X-Trace: forums-1-dub 1283785038 10.22.241.41 (6 Sep 2010 07:57:18 -0700)
X-Original-Trace: 6 Sep 2010 07:57:18 -0700, 10.22.241.41
Lines: 17
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29534
Article PK: 78764

Hi all,
I have setup a replication from SQL Server to Sybase ASE
using SQL Server transactional replication. This work via
the Sybase OLEDB driver and linked server. Connection is
working, prublication is defined on SQL Server side, the
subscription against the Sybase server and database is
working. But I got one huge problem: All character datatypes
end up as NULL in Sybase. When I enter a row in the SQL
Server table which is publicated all data that is not
character (float, numeric, datetime etc.) is replicated and
the row is available on Sybase side, but all character
columns are null. Is this something anyone here has already
heard about? The weired thing: I got this running fine in
one virtual Windows machine where ASE is running in 32 bit
under Windows. But this null problem comes up if I ran the
SQL Server in 64 Bit and the Sybase box is running in 64 Bit
Linux. Any idea what to look for?


ET Posted on 2010-09-07 06:31:26.0Z
Sender: 53fc.4c85da1e.1804289383@sybase.com
From: ET
Newsgroups: sybase.public.ase.general
Subject: Re: Replicating from SQL Server to Sybase using SQL Server replication
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4c85dc3d.5421.1681692777@sybase.com>
References: <4c85014e.4694.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 6 Sep 2010 23:31:26 -0700
X-Trace: forums-1-dub 1283841086 10.22.241.41 (6 Sep 2010 23:31:26 -0700)
X-Original-Trace: 6 Sep 2010 23:31:26 -0700, 10.22.241.41
Lines: 40
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29535
Article PK: 78765

Hi

I was thinking about code page but I cannot see how you can
end with null values. I think code page is different on your
2 servers (cp1252 on Win and cp850 for linux). But I would
have though having strange strings maybe but not nulls...

I found this in SQL Server dist agent doc for heterogeneous
rep :

Replication moves data in Unicode format regardless of the
collation/code pages used on the Publisher and Subscriber.
It is recommended that you choose a compatible
collation/code page when replicating between Publishers and
Subscribers.

cf.
http://msdn.microsoft.com/en-us/library/ms151864(v=SQL.90).aspx

You should check on MS support forums too.

Emmanuel

> Hi all,
> I have setup a replication from SQL Server to Sybase ASE
> using SQL Server transactional replication. This work via
> the Sybase OLEDB driver and linked server. Connection is
> working, prublication is defined on SQL Server side, the
> subscription against the Sybase server and database is
> working. But I got one huge problem: All character
> datatypes end up as NULL in Sybase. When I enter a row in
> the SQL Server table which is publicated all data that is
> not character (float, numeric, datetime etc.) is
> replicated and the row is available on Sybase side, but
> all character columns are null. Is this something anyone
> here has already heard about? The weired thing: I got this
> running fine in one virtual Windows machine where ASE is
> running in 32 bit under Windows. But this null problem
> comes up if I ran the SQL Server in 64 Bit and the Sybase
> box is running in 64 Bit Linux. Any idea what to look for?


WW Posted on 2010-09-07 07:48:57.0Z
Sender: 4666.4c84ff80.1804289383@sybase.com
From: WW
Newsgroups: sybase.public.ase.general
Subject: Re: Replicating from SQL Server to Sybase using SQL Server replication
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4c85ee69.5557.1681692777@sybase.com>
References: <4c85dc3d.5421.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 7 Sep 2010 00:48:57 -0700
X-Trace: forums-1-dub 1283845737 10.22.241.41 (7 Sep 2010 00:48:57 -0700)
X-Original-Trace: 7 Sep 2010 00:48:57 -0700, 10.22.241.41
Lines: 58
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29536
Article PK: 78767

Thanks Emmanuel,
this codepage and unicode stuff etc. also came into my mind,
but I have it running and working on my virtual machine
unter Windows Server with the ASE for Windows. I use the
same codepage on Sybase there as the customer environment
has, and also my SQL Server 2008 is the same version number
as the one on customer side. So same codepage stuff, same
versions (OLEDB provider from Sybase is in both cases 15.5).
So it will be a case on 64 bit (my personal system is 32 bit
only) or it is a problem that the Sybase ASE target is
running on Linux.

regards
Wolfgang

> Hi
>
> I was thinking about code page but I cannot see how you
> can end with null values. I think code page is different
> on your 2 servers (cp1252 on Win and cp850 for linux). But
> I would have though having strange strings maybe but not
> nulls...
>
> I found this in SQL Server dist agent doc for
> heterogeneous rep :
>
> Replication moves data in Unicode format regardless of the
> collation/code pages used on the Publisher and Subscriber.
> It is recommended that you choose a compatible
> collation/code page when replicating between Publishers
> and Subscribers.
>
> cf.
>
http://msdn.microsoft.com/en-us/library/ms151864(v=SQL.90).aspx
>
> You should check on MS support forums too.
>
> Emmanuel
>
> > Hi all,
> > I have setup a replication from SQL Server to Sybase ASE
> > using SQL Server transactional replication. This work
> > via the Sybase OLEDB driver and linked server.
> > Connection is working, prublication is defined on SQL
> > Server side, the subscription against the Sybase server
> > and database is working. But I got one huge problem: All
> > character datatypes end up as NULL in Sybase. When I
> > enter a row in the SQL Server table which is publicated
> > all data that is not character (float, numeric, datetime
> > etc.) is replicated and the row is available on Sybase
> > side, but all character columns are null. Is this
> > something anyone here has already heard about? The
> > weired thing: I got this running fine in one virtual
> > Windows machine where ASE is running in 32 bit under
> > Windows. But this null problem comes up if I ran the SQL
> > Server in 64 Bit and the Sybase box is running in 64 Bit
> Linux. Any idea what to look for?


ET Posted on 2010-09-07 10:42:38.0Z
Sender: 5428.4c85dc44.1804289383@sybase.com
From: ET
Newsgroups: sybase.public.ase.general
Subject: Re: Replicating from SQL Server to Sybase using SQL Server replication
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4c86171e.57f6.1681692777@sybase.com>
References: <4c85ee69.5557.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 7 Sep 2010 03:42:38 -0700
X-Trace: forums-1-dub 1283856158 10.22.241.41 (7 Sep 2010 03:42:38 -0700)
X-Original-Trace: 7 Sep 2010 03:42:38 -0700, 10.22.241.41
Lines: 79
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29537
Article PK: 78768

Hi Wolfgang,

I am not sure I am getting it : is your linux sybase ase
64-bit running with the same codepage than your win64
machine ???

I would try using ribo utility to see how TSQL orders sent
by the mssql distribution agent arrive in ASE. Then you can
see if the nulls are already there before ASE.

You can also check what the command looks like in the sql
server distribution database (get the xact_seqno from
distribution..Msrepl_commands and run sp_browsereplcmds)...
but this is more mssql support ;-)

Emmanuel

> Thanks Emmanuel,
> this codepage and unicode stuff etc. also came into my
> mind, but I have it running and working on my virtual
> machine unter Windows Server with the ASE for Windows. I
> use the same codepage on Sybase there as the customer
> environment has, and also my SQL Server 2008 is the same
> version number as the one on customer side. So same
> codepage stuff, same versions (OLEDB provider from Sybase
> is in both cases 15.5). So it will be a case on 64 bit (my
> personal system is 32 bit only) or it is a problem that
> the Sybase ASE target is running on Linux.
>
> regards
> Wolfgang
>
> > Hi
> >
> > I was thinking about code page but I cannot see how you
> > can end with null values. I think code page is different
> > on your 2 servers (cp1252 on Win and cp850 for linux).
> > But I would have though having strange strings maybe but
> > not nulls...
> >
> > I found this in SQL Server dist agent doc for
> > heterogeneous rep :
> >
> > Replication moves data in Unicode format regardless of
> > the collation/code pages used on the Publisher and
> > Subscriber. It is recommended that you choose a
> > compatible collation/code page when replicating between
> > Publishers and Subscribers.
> >
> > cf.
> >
>
http://msdn.microsoft.com/en-us/library/ms151864(v=SQL.90).aspx
> >
> > You should check on MS support forums too.
> >
> > Emmanuel
> >
> > > Hi all,
> > > I have setup a replication from SQL Server to Sybase
> > > ASE using SQL Server transactional replication. This
> > > work via the Sybase OLEDB driver and linked server.
> > > Connection is working, prublication is defined on SQL
> > > Server side, the subscription against the Sybase
> > > server and database is working. But I got one huge
> > > problem: All character datatypes end up as NULL in
> > > Sybase. When I enter a row in the SQL Server table
> > > which is publicated all data that is not character
> > > (float, numeric, datetime etc.) is replicated and the
> > > row is available on Sybase side, but all character
> > > columns are null. Is this something anyone here has
> > > already heard about? The weired thing: I got this
> > > running fine in one virtual Windows machine where ASE
> > > is running in 32 bit under Windows. But this null
> > > problem comes up if I ran the SQL Server in 64 Bit and
> > the Sybase box is running in 64 Bit Linux. Any idea what
> to look for?


Chris Baker[Sybase] Posted on 2010-09-08 15:01:43.0Z
Reply-To: "Chris Baker[Sybase]" <chris.baker.nospam@nospam.sybase.com>
From: "Chris Baker[Sybase]" <chris.baker.nospam@nospam.sybase.com>
Newsgroups: sybase.public.ase.general
References: <4c85ee69.5557.1681692777@sybase.com> <4c86171e.57f6.1681692777@sybase.com>
In-Reply-To: <4c86171e.57f6.1681692777@sybase.com>
Subject: Re: Replicating from SQL Server to Sybase using SQL Server replication
Lines: 84
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6002.18197
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18197
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4c87a557$1@forums-1-dub>
Date: 8 Sep 2010 08:01:43 -0700
X-Trace: forums-1-dub 1283958103 10.22.241.152 (8 Sep 2010 08:01:43 -0700)
X-Original-Trace: 8 Sep 2010 08:01:43 -0700, vip152.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29550
Article PK: 78781

Doesn't SQL Server use N'<string>' syntax for unicode strings? ASE does not
support it.

"ET" wrote in message news:4c86171e.57f6.1681692777@sybase.com...
> Hi Wolfgang,
>
> I am not sure I am getting it : is your linux sybase ase
> 64-bit running with the same codepage than your win64
> machine ???
>
> I would try using ribo utility to see how TSQL orders sent
> by the mssql distribution agent arrive in ASE. Then you can
> see if the nulls are already there before ASE.
>
> You can also check what the command looks like in the sql
> server distribution database (get the xact_seqno from
> distribution..Msrepl_commands and run sp_browsereplcmds)...
> but this is more mssql support ;-)
>
> Emmanuel
>
>
>
>> Thanks Emmanuel,
>> this codepage and unicode stuff etc. also came into my
>> mind, but I have it running and working on my virtual
>> machine unter Windows Server with the ASE for Windows. I
>> use the same codepage on Sybase there as the customer
>> environment has, and also my SQL Server 2008 is the same
>> version number as the one on customer side. So same
>> codepage stuff, same versions (OLEDB provider from Sybase
>> is in both cases 15.5). So it will be a case on 64 bit (my
>> personal system is 32 bit only) or it is a problem that
>> the Sybase ASE target is running on Linux.
>>
>> regards
>> Wolfgang
>>
>> > Hi
>> >
>> > I was thinking about code page but I cannot see how you
>> > can end with null values. I think code page is different
>> > on your 2 servers (cp1252 on Win and cp850 for linux).
>> > But I would have though having strange strings maybe but
>> > not nulls...
>> >
>> > I found this in SQL Server dist agent doc for
>> > heterogeneous rep :
>> >
>> > Replication moves data in Unicode format regardless of
>> > the collation/code pages used on the Publisher and
>> > Subscriber. It is recommended that you choose a
>> > compatible collation/code page when replicating between
>> > Publishers and Subscribers.
>> >
>> > cf.
>> >
>>
> http://msdn.microsoft.com/en-us/library/ms151864(v=SQL.90).aspx
>> >
>> > You should check on MS support forums too.
>> >
>> > Emmanuel
>> >
>> > > Hi all,
>> > > I have setup a replication from SQL Server to Sybase
>> > > ASE using SQL Server transactional replication. This
>> > > work via the Sybase OLEDB driver and linked server.
>> > > Connection is working, prublication is defined on SQL
>> > > Server side, the subscription against the Sybase
>> > > server and database is working. But I got one huge
>> > > problem: All character datatypes end up as NULL in
>> > > Sybase. When I enter a row in the SQL Server table
>> > > which is publicated all data that is not character
>> > > (float, numeric, datetime etc.) is replicated and the
>> > > row is available on Sybase side, but all character
>> > > columns are null. Is this something anyone here has
>> > > already heard about? The weired thing: I got this
>> > > running fine in one virtual Windows machine where ASE
>> > > is running in 32 bit under Windows. But this null
>> > > problem comes up if I ran the SQL Server in 64 Bit and
>> > the Sybase box is running in 64 Bit Linux. Any idea what
>> to look for?


Paul Vero [Sybase] Posted on 2010-09-09 19:09:46.0Z
From: "Paul Vero [Sybase]" <pvero@nospam.com>
Newsgroups: sybase.public.ase.general
References: <4c85dc3d.5421.1681692777@sybase.com> <4c85ee69.5557.1681692777@sybase.com>
Subject: Re: Replicating from SQL Server to Sybase using SQL Server replication
Lines: 81
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3664
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3664
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4c8930fa$1@forums-1-dub>
Date: 9 Sep 2010 12:09:46 -0700
X-Trace: forums-1-dub 1284059386 10.22.241.152 (9 Sep 2010 12:09:46 -0700)
X-Original-Trace: 9 Sep 2010 12:09:46 -0700, vip152.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29552
Article PK: 78782

Hi Wolfgang,

Is it possible you can capture TDS trace using the RIBO utility between the
OLE DB Provider and the ASE?
I'm curious to see how the Providwer is packaging the data - if its literal
or if parameterized.

We had some weird issue in CR 548634, but this is fixed since SDK 15.0
ESD#17 version of the Provider - you have version 15.5 so this fix is in
there (and I don't think it's the same issue).

If this is reproducible easily you can open a tech support case with Sybase
and the connectivity team can investigate this and determine if it's a
support issue with ASE (as Chris has suggested) or something else - like
char data parameters are sent as null instead of the value.

Thank you

-Paul

<WW> wrote in message news:4c85ee69.5557.1681692777@sybase.com...
> Thanks Emmanuel,
> this codepage and unicode stuff etc. also came into my mind,
> but I have it running and working on my virtual machine
> unter Windows Server with the ASE for Windows. I use the
> same codepage on Sybase there as the customer environment
> has, and also my SQL Server 2008 is the same version number
> as the one on customer side. So same codepage stuff, same
> versions (OLEDB provider from Sybase is in both cases 15.5).
> So it will be a case on 64 bit (my personal system is 32 bit
> only) or it is a problem that the Sybase ASE target is
> running on Linux.
>
> regards
> Wolfgang
>
>> Hi
>>
>> I was thinking about code page but I cannot see how you
>> can end with null values. I think code page is different
>> on your 2 servers (cp1252 on Win and cp850 for linux). But
>> I would have though having strange strings maybe but not
>> nulls...
>>
>> I found this in SQL Server dist agent doc for
>> heterogeneous rep :
>>
>> Replication moves data in Unicode format regardless of the
>> collation/code pages used on the Publisher and Subscriber.
>> It is recommended that you choose a compatible
>> collation/code page when replicating between Publishers
>> and Subscribers.
>>
>> cf.
>>
> http://msdn.microsoft.com/en-us/library/ms151864(v=SQL.90).aspx
>>
>> You should check on MS support forums too.
>>
>> Emmanuel
>>
>> > Hi all,
>> > I have setup a replication from SQL Server to Sybase ASE
>> > using SQL Server transactional replication. This work
>> > via the Sybase OLEDB driver and linked server.
>> > Connection is working, prublication is defined on SQL
>> > Server side, the subscription against the Sybase server
>> > and database is working. But I got one huge problem: All
>> > character datatypes end up as NULL in Sybase. When I
>> > enter a row in the SQL Server table which is publicated
>> > all data that is not character (float, numeric, datetime
>> > etc.) is replicated and the row is available on Sybase
>> > side, but all character columns are null. Is this
>> > something anyone here has already heard about? The
>> > weired thing: I got this running fine in one virtual
>> > Windows machine where ASE is running in 32 bit under
>> > Windows. But this null problem comes up if I ran the SQL
>> > Server in 64 Bit and the Sybase box is running in 64 Bit
>> Linux. Any idea what to look for?