Home > Archive > SQL Anywhere database > July 2005 > External procedures with 64-bit engine









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author External procedures with 64-bit engine
Breck Carter [TeamSybase]

2005-07-11, 11:23 am

How do I get a Visual Studio .NET 32-bit Windows C DLL containing
custom "external procedures" to work with the 64-bit ASA 9 engine?

The current version of the DLL works OK with the 32-bit 9.0.2.3124
engine.

I am happy to make a separate 64-bit version if necessary, but I would
like some "getting started" pointers to the docs: iAnywhere, Microsoft
or other.

Thanks!

Breck

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
John Smirnios

2005-07-12, 3:23 am

64-bit processes cannot load 32-bit DLLs and vice-versa. If you are
using a 64-bit server, you must build a 64-bit DLL to contain your
external stored procedures.

Do you need instructions on how to build a 64-bit DLL? Just download &
install the latest SDK (approx Apr 21 or later). The 64-bit compilers &
libraries are in it.

-john.

--
John Smirnios
Senior Software Developer
iAnywhere Solutions Engineering

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer

Breck Carter [TeamSybase] wrote:
> How do I get a Visual Studio .NET 32-bit Windows C DLL containing
> custom "external procedures" to work with the 64-bit ASA 9 engine?
>
> The current version of the DLL works OK with the 32-bit 9.0.2.3124
> engine.
>
> I am happy to make a separate 64-bit version if necessary, but I would
> like some "getting started" pointers to the docs: iAnywhere, Microsoft
> or other.
>
> Thanks!
>
> Breck
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com

Breck Carter [TeamSybase]

2005-07-12, 9:23 am

Thanks! are there any source/header/whatever files I need on the ASA
side? If so, are they only delivered with the 64-bit SQL Anywhere?

(oh, wow, I'm feeling a tsunami of "dumb" washing over me :)

Breck Doesn't Even Own A 64-bit Box Yet

On 11 Jul 2005 21:27:08 -0700, John Smirnios
< smirnios_at_sybase_d
ot_com> wrote:

>64-bit processes cannot load 32-bit DLLs and vice-versa. If you are
>using a 64-bit server, you must build a 64-bit DLL to contain your
>external stored procedures.
>
>Do you need instructions on how to build a 64-bit DLL? Just download &
>install the latest SDK (approx Apr 21 or later). The 64-bit compilers &
>libraries are in it.
>
>-john.


--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
John Smirnios

2005-07-13, 1:23 pm

The same ASA header files should work for 32 & 64 bit builds.

-john
John Does All His Development Now On A 64-bit Machine And Has A 64-bit
Capable Machine At Home Too

:)

--
John Smirnios
Senior Software Developer
iAnywhere Solutions Engineering

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer

Breck Carter [TeamSybase] wrote:
> Thanks! are there any source/header/whatever files I need on the ASA
> side? If so, are they only delivered with the 64-bit SQL Anywhere?
>
> (oh, wow, I'm feeling a tsunami of "dumb" washing over me :)
>
> Breck Doesn't Even Own A 64-bit Box Yet
>
> On 11 Jul 2005 21:27:08 -0700, John Smirnios
> < smirnios_at_sybase_d
ot_com> wrote:
>
>
>
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com

Breck Carter [TeamSybase]

2005-07-13, 8:23 pm

Intel or AMD? Windows? Do you have a 64-bit laptop?

Breck Wants A Turbo Carrera Too

On 13 Jul 2005 11:33:23 -0700, John Smirnios
< smirnios_at_sybase_d
ot_com> wrote:

>The same ASA header files should work for 32 & 64 bit builds.
>
>-john
>John Does All His Development Now On A 64-bit Machine And Has A 64-bit
>Capable Machine At Home Too
>
>:)


--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
John Smirnios

2005-07-14, 1:23 pm

At work I have a dual Opteron 252 system with 2GB RAM a 4-drive SATA
stripe running Win64. It's wonderful and it is definitely not a laptop.
I got my new machine just a month too early -- Peter got the same
machine a month later but he has two dual-core Opterons. It's soooooo fast.

At home, Athlon64 3500. Still running Win32 though. Low availability of
64-bit drivers is more of an issue for a home machine where you need to
plug in scanners, printers, cameras, etc.

-john.
--
John Smirnios
Senior Software Developer
iAnywhere Solutions Engineering

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer

Breck Carter [TeamSybase] wrote:
> Intel or AMD? Windows? Do you have a 64-bit laptop?
>
> Breck Wants A Turbo Carrera Too
>
> On 13 Jul 2005 11:33:23 -0700, John Smirnios
> < smirnios_at_sybase_d
ot_com> wrote:
>
>
>
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com

Breck Carter [TeamSybase]

2005-07-14, 8:23 pm

Oh, yeah, driver availability... (:

What is thing you call "home"? Is it anything like "hotel room"? :)

Breck

On 14 Jul 2005 11:31:44 -0700, John Smirnios
< smirnios_at_sybase_d
ot_com> wrote:

>At work I have a dual Opteron 252 system with 2GB RAM a 4-drive SATA
>stripe running Win64. It's wonderful and it is definitely not a laptop.
>I got my new machine just a month too early -- Peter got the same
>machine a month later but he has two dual-core Opterons. It's soooooo fast.
>
>At home, Athlon64 3500. Still running Win32 though. Low availability of
>64-bit drivers is more of an issue for a home machine where you need to
>plug in scanners, printers, cameras, etc.
>
>-john.


--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com