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.

Trigger migration to x64 environment

5 posts in Trigger Last posting was on 2011-04-20 16:32:37.0Z
Christian Palm Posted on 2011-04-20 09:40:49.0Z
Date: Wed, 20 Apr 2011 11:40:49 +0200
From: Christian Palm <Christian.Palm@untereichen.net>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; de; rv:1.9.2.15) Gecko/20110303 Thunderbird/3.1.9
MIME-Version: 1.0
Newsgroups: Advantage.Trigger
Subject: Trigger migration to x64 environment
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 145.228.214.125
Message-ID: <4daeaa10@solutions.advantagedatabase.com>
X-Trace: 20 Apr 2011 02:40:32 -0700, 145.228.214.125
Lines: 28
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.Trigger:484
Article PK: 1136545

Hi,

I've now migrated my database onto a new X2008 R2 Server and also
upgraded to the latest 10.1 Version. So far so good.

Unfortunately I don't get my old and proven C# .net trigger to run.

What I did so far:
- changed the trigger project in VS2010 to reference the latest .net ads
client and did some general tests. I compiled it to run on the x64
platform and verified that this works in general and that the 64 bit ADS
dll's are loaded. Of course the dll is still made COM visible
- on the target server added the trigger dll installation directory to
the global path
- did a regasm (from only the x64 version of the .net framework). The 32
bit version of regasm correctly complains as this is not compiled to
work in x86 mode.
- restarted the ADS server

When then trying with Data Architect to create a trigger my new dll or
class doesn't show up in the (big big) list of available classes.

I then tried to add a trigger programmatically from a x64 program but
this also fails.

Does anybody have advice for me?

Thanks!


Joachim Duerr (ADS) Posted on 2011-04-20 10:49:18.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: Trigger migration to x64 environment
Newsgroups: Advantage.Trigger
References: <4daeaa10@solutions.advantagedatabase.com>
Date: Wed, 20 Apr 2011 12:49:18 +0200
User-Agent: XanaNews/1.19.1.269
X-Face: u2p+</,mb|Ah!x!/qxX5q0t:O~.<1&JzwNHYhSqcviY{~&|iDc"U.Je1A.ZeHR`d;;y#R
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-15
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 95.115.79.229
Message-ID: <4daeb989$1@solutions.advantagedatabase.com>
X-Trace: 20 Apr 2011 03:46:33 -0700, 95.115.79.229
Lines: 11
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.Trigger:485
Article PK: 1136548


Christian Palm wrote:

>When then trying with Data Architect to create a trigger my new dll
>or class doesn't show up in the (big big) list of available classes.

ARC is Win32...so it won't show up 64Bit assemblies.

--
Joachim Duerr, Advantage Presales
*** NEW *** Advantage Pocket Guide released *** NEW ***
http://pocketguide.jd-engineering.de


Christian Palm Posted on 2011-04-20 11:22:18.0Z
Date: Wed, 20 Apr 2011 13:22:18 +0200
From: Christian Palm <Christian.Palm@untereichen.net>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; de; rv:1.9.2.15) Gecko/20110303 Thunderbird/3.1.9
MIME-Version: 1.0
Newsgroups: Advantage.Trigger
Subject: Re: Trigger migration to x64 environment
References: <4daeaa10@solutions.advantagedatabase.com> <4daeb989$1@solutions.advantagedatabase.com>
In-Reply-To: <4daeb989$1@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 145.228.214.125
Message-ID: <4daec1d9$1@solutions.advantagedatabase.com>
X-Trace: 20 Apr 2011 04:22:01 -0700, 145.228.214.125
Lines: 19
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.Trigger:486
Article PK: 1136546

So far so bad.
I now could create my trigger and when testing it via an ARC32 update I
get the following error:
"BrowseTable: Error 5177: Trigger execution failed Error 5042: The
requested feature has not been implemented. Interface version 1 COM
triggers are not supported on 64 bit platforms."

Can I get around this somehow? I thought 64 bit is now fully supportet?!?


Am 20.04.2011 12:49, schrieb Joachim Duerr (ADS):

> Christian Palm wrote:
>
>> When then trying with Data Architect to create a trigger my new dll
>> or class doesn't show up in the (big big) list of available classes.
>
> ARC is Win32...so it won't show up 64Bit assemblies.
>


Lance Schmidt Posted on 2011-04-20 15:45:09.0Z
Date: Wed, 20 Apr 2011 15:45:09 +0000 (UTC)
Message-ID: <a1f122613aff8cdcd56c5a73d23@devzone.advantagedatabase.com>
From: Lance Schmidt <NoThanks@spam.com>
Subject: Re: Trigger migration to x64 environment
Newsgroups: Advantage.Trigger
References: <4daec1d9$1@solutions.advantagedatabase.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Reader 1098.1
NNTP-Posting-Host: 10.6.199.207
X-Trace: 20 Apr 2011 08:44:51 -0700, 10.6.199.207
Lines: 43
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.Trigger:487
Article PK: 1136547

Hello Christian,

The trigger template needed to change for x64 support. The function parameter
hConnection became and Int64 instead of an Int32 for each trigger function.

Finally you need to expose the following function to tell the server to use
the newer triggers.

// Do not change or remove this function. It is used internally by
the Advantage server
public Int32 GetInterfaceVersion()
{
return 3;
} // GetInterfaceVersion


Best Regards,

Lance Schmidt
Advantage R&D

> So far so bad.
> I now could create my trigger and when testing it via an ARC32 update
> I
> get the following error:
> "BrowseTable: Error 5177: Trigger execution failed Error 5042: The
> requested feature has not been implemented. Interface version 1 COM
> triggers are not supported on 64 bit platforms."
> Can I get around this somehow? I thought 64 bit is now fully
> supportet?!?
>
> Am 20.04.2011 12:49, schrieb Joachim Duerr (ADS):
>
>> Christian Palm wrote:
>>
>>> When then trying with Data Architect to create a trigger my new dll
>>> or class doesn't show up in the (big big) list of available classes.
>>>
>> ARC is Win32...so it won't show up 64Bit assemblies.
>>


Joachim Duerr (ADS) Posted on 2011-04-20 16:32:37.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: Trigger migration to x64 environment
Newsgroups: Advantage.Trigger
References: <4daeaa10@solutions.advantagedatabase.com> <4daeb989$1@solutions.advantagedatabase.com> <4daec1d9$1@solutions.advantagedatabase.com>
Date: Wed, 20 Apr 2011 18:32:37 +0200
User-Agent: XanaNews/1.19.1.269
X-Face: u2p+</,mb|Ah!x!/qxX5q0t:O~.<1&JzwNHYhSqcviY{~&|iDc"U.Je1A.ZeHR`d;;y#R
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-15
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 95.115.79.229
Message-ID: <4daf09ff$1@solutions.advantagedatabase.com>
X-Trace: 20 Apr 2011 09:29:51 -0700, 95.115.79.229
Lines: 19
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.Trigger:488
Article PK: 1136549


Christian Palm wrote:

>So far so bad.
>I now could create my trigger and when testing it via an ARC32 update
>I get the following error: "BrowseTable: Error 5177: Trigger
>execution failed Error 5042: The requested feature has not been
>implemented. Interface version 1 COM triggers are not supported on 64
>bit platforms."
>
>Can I get around this somehow? I thought 64 bit is now fully
>supportet?!?

interface 1 is not supported at all for a couple of versions now. You
need to update the interface to V2 (introduced in ADS 7).

--
Joachim Duerr, Advantage Presales
*** NEW *** Advantage Pocket Guide released *** NEW ***
http://pocketguide.jd-engineering.de