QuantLib › quantlib-dev

Re: [Quantlib-users] Using QuantLibXL

Classic

List

Threaded

7 messages Options

Eric Ehlers-2

Re: [Quantlib-users] Using QuantLibXL

Hi Slava,

Picking up the thread that started in quantlib-users...

The error you reported initially - "QuantLibXL-vc80-MT-S-0_9_5.xll is not a
valid add-in" - this was a known problem, which I was observing on my machine,
and which was resolved by svn revision 15471. Can we take a second to make
sure you got the fix?

On Fri, August 29, 2008 17:01, Slava D wrote:
> Hi Eric,
>
> thank you very much for your attempt to help me.
>
> Unfortunately, it did not work - I have downloaded the updates you made for
> QuantLibObjectHandler and for QuantLibXL. I did not update QuantLibAddIn as
> all its changes were quite before your changes to fix static at the
> solutions abiove.

I'm slightly confused when you talk about downloads, and about updating some
projects and not others.

We're working with the latest snapshot of the svn trunk. Normally you would
use Tortoise SVN to do svn checkout from

https://quantlib.svn.sourceforge.net/svnroot/quantlib/trunk

To a directory on your hard drive e.g.

C:\projects\trunk

The fix as I mentioned was svn revision 15471 which was applied Thursday. So
what you should now do is right click on your local root directory e.g.
C:\projects\trunk and do svn update. This brings your local copy of the trunk
up to date, which at the time of this writing is revision 15476.

You would then rebuild the solution. For this particular fix an incremental
rebuild should suffice, a full rebuild isn't required.

> I am still getting the same error message:
>
> *Warning: At least one module has an unresolved import due to a missing
> export function in a delay-load dependent module.*
>
>
> ar MPR.dll for function WNetRestoreConnectionA.
>
> guys,
>
> Do you know how this problem is coming?
>
> Before I had error mesage "Missing msjava.dll".

Those messages are from the dependency walker and can be ignored, see the FAQ
for more info:

http://www.dependencywalker.com/faq.html

More important, when you start Excel and load QuantLibXL-vc80-mt-s-0_9_5.xll,
do you still get a run time error?

I assume you're using the XLL on the same machine on which it was compiled?

Regards,
Eric

-------------------------
Eric Ehlers
nazcatech sprl | Brussels | http://www.nazcatech.be
Distributed computing for pricing analytics - Use Microsoft Excel as a client
to the Grid

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
QuantLib-dev mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-dev

Slava D

Re: [Quantlib-users] Using QuantLibXL

Hi Eric,

thank you very much for your e-mail.

I will try everything again.

However, having checked QuantLibObjectHandler xll-s (they are not required for static QuantLibXL, but they are good points to check), I have noticed that there is an error there that "MSVCR80.dll" is not found.

I believe that there are some problems with the manifest for QuantLibObjectHandler - I have used full rebuild (on the net there are a couple of ways to fix it in the right way). Some blogs on the net are claiming that the problems with "MSVCR80.dll" are coming when you do a full rebuild.

I will also try to use the link you sent to me for the trunk - before I was using

http://quantlib.svn.sourceforge.net/viewvc/quantlib/

there I took your files for QuantLibObjetHandler and QuantLibXL with your comments that you fixed static stuff.

Let me try to everything again an I will let you know how things are.

However, I do believe that we would converge pretty soon to something reasonable.

thanks for you help again,

Slava

On Mon, Sep 1, 2008 at 10:54 AM, Eric Ehlers <[hidden email]> wrote:

Hi Slava,

Picking up the thread that started in quantlib-users...

The error you reported initially - "QuantLibXL-vc80-MT-S-0_9_5.xll is not a
valid add-in" - this was a known problem, which I was observing on my machine,
and which was resolved by svn revision 15471. Can we take a second to make
sure you got the fix?

On Fri, August 29, 2008 17:01, Slava D wrote:
> Hi Eric,
>
> thank you very much for your attempt to help me.
>
> Unfortunately, it did not work - I have downloaded the updates you made for
> QuantLibObjectHandler and for QuantLibXL. I did not update QuantLibAddIn as
> all its changes were quite before your changes to fix static at the
> solutions abiove.

I'm slightly confused when you talk about downloads, and about updating some
projects and not others.

We're working with the latest snapshot of the svn trunk. Normally you would
use Tortoise SVN to do svn checkout from

https://quantlib.svn.sourceforge.net/svnroot/quantlib/trunk

To a directory on your hard drive e.g.

C:\projects\trunk

The fix as I mentioned was svn revision 15471 which was applied Thursday. So
what you should now do is right click on your local root directory e.g.
C:\projects\trunk and do svn update. This brings your local copy of the trunk
up to date, which at the time of this writing is revision 15476.

You would then rebuild the solution. For this particular fix an incremental
rebuild should suffice, a full rebuild isn't required.

> I am still getting the same error message:
>
> *Warning: At least one module has an unresolved import due to a missing
> export function in a delay-load dependent module.*
>
>
> ar MPR.dll for function WNetRestoreConnectionA.
>
> guys,
>
> Do you know how this problem is coming?
>
> Before I had error mesage "Missing msjava.dll".

Those messages are from the dependency walker and can be ignored, see the FAQ
for more info:

http://www.dependencywalker.com/faq.html

More important, when you start Excel and load QuantLibXL-vc80-mt-s-0_9_5.xll,
do you still get a run time error?

I assume you're using the XLL on the same machine on which it was compiled?

Regards,
Eric

-------------------------
Eric Ehlers
nazcatech sprl | Brussels | http://www.nazcatech.be
Distributed computing for pricing analytics - Use Microsoft Excel as a client
to the Grid

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
QuantLib-dev mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-dev

Eric Ehlers-2

Re: [Quantlib-users] Using QuantLibXL

Hi Slava,

On Mon, September 1, 2008 20:51, Slava D wrote:
> However, having checked QuantLibObjectHandler xll-s (they are not required
> for static QuantLibXL, but they are good points to check), I have noticed
> that there is an error there that "MSVCR80.dll" is not found.
>
> I believe that there are some problems with the manifest for
> QuantLibObjectHandler - I have used full rebuild (on the net there are a
> couple of ways to fix it in the right way). Some blogs on the net are
> claiming that the problems with "MSVCR80.dll" are coming when you do a full
> rebuild.

Compiled with VC8 configuration "Release CRTDLL", the XLL will have a run time
dependency on MSVCR80.dll. Certainly if the dependency walker indicates that
that dependency is unsatisfied then it would explain the error "not a valid
add-in". Normally if you test the XLL on the same machine on which it was
compiled then this error doesn't occur. I have never heard of this problem
being triggered by a full rebuild.

> I will also try to use the link you sent to me for the trunk - before I was
> using
>
> http://quantlib.svn.sourceforge.net/viewvc/quantlib/
>
> there I took your files for QuantLibObjetHandler and QuantLibXL with your
> comments that you fixed static stuff.

The best is to use TortoiseSVN to check out the root directory of the
repository trunk as described in my earlier message.

> Let me try to everything again an I will let you know how things are.
>
> However, I do believe that we would converge pretty soon to something
> reasonable.
>
> thanks for you help again,

No problem, happy to help, I'm optimistic that a clean start will fix the
problem, please keep me posted.

Regards,
Eric

-------------------------
Eric Ehlers
nazcatech sprl | Brussels | http://www.nazcatech.be
Distributed computing for pricing analytics - Use Microsoft Excel as a client
to the Grid

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
QuantLib-dev mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-dev

Slava D

Re: [Quantlib-users] Using QuantLibXL

Hi Eric.,

thank you very much for your e-mail.

I took everything via TortoiseSVN as you adviced in one of your e-mails.

I also run vcredist.exe as some people recommend.

I did full rebuild of everything (QuantLib, genXXX, and then QuantLibObjectHandler). For ObjectHandler I did with flag Using FAT 32 workaround as Yes (as it is recommended on the net). Dependendwlaker still indicates that QuantLibObjectHandler is still missing msvcr80.dll (for the release mode) and msvcr80d.dll (for the debug mode). I have also checked that my manifest is looking for the dll-s above with the same version numbers as I have on my machine.

Mistery.

I plan to do a full rebuild somewhere Monday-Tuesday on a virgin machine with VS2008.

I do want to make it work as I plan to use QuantLib quite a lot.

I have a couple of questions:

I am going to use VS2008 with SP1. Do I need to run vsredist.exe before douing the full rebuild?

did you take VS2008 with sp1, or just vs2008?

Thank you very much for your help again - it is nice to feel that I can ask somebody for an advice.

many thanks,

Slava

On Tue, Sep 2, 2008 at 11:18 AM, Eric Ehlers <[hidden email]> wrote:

Hi Slava,

On Mon, September 1, 2008 20:51, Slava D wrote:
> However, having checked QuantLibObjectHandler xll-s (they are not required
> for static QuantLibXL, but they are good points to check), I have noticed
> that there is an error there that "MSVCR80.dll" is not found.
>
> I believe that there are some problems with the manifest for
> QuantLibObjectHandler - I have used full rebuild (on the net there are a
> couple of ways to fix it in the right way). Some blogs on the net are
> claiming that the problems with "MSVCR80.dll" are coming when you do a full
> rebuild.

Compiled with VC8 configuration "Release CRTDLL", the XLL will have a run time
dependency on MSVCR80.dll. Certainly if the dependency walker indicates that
that dependency is unsatisfied then it would explain the error "not a valid
add-in". Normally if you test the XLL on the same machine on which it was
compiled then this error doesn't occur. I have never heard of this problem
being triggered by a full rebuild.

> I will also try to use the link you sent to me for the trunk - before I was
> using
>
> http://quantlib.svn.sourceforge.net/viewvc/quantlib/
>
> there I took your files for QuantLibObjetHandler and QuantLibXL with your
> comments that you fixed static stuff.

The best is to use TortoiseSVN to check out the root directory of the
repository trunk as described in my earlier message.

> Let me try to everything again an I will let you know how things are.
>
> However, I do believe that we would converge pretty soon to something
> reasonable.
>
> thanks for you help again,

No problem, happy to help, I'm optimistic that a clean start will fix the
problem, please keep me posted.

Regards,
Eric

-------------------------
Eric Ehlers
nazcatech sprl | Brussels | http://www.nazcatech.be
Distributed computing for pricing analytics - Use Microsoft Excel as a client
to the Grid

Eric Ehlers-2

Re: [Quantlib-users] Using QuantLibXL

Hi Slava,

On Sat, September 6, 2008 19:21, Slava D wrote:
> Hi Eric.,
>
> thank you very much for your e-mail.
>
> I took everything via TortoiseSVN as you adviced in one of your e-mails.
>
> I also run vcredist.exe as some people recommend.

It's not necessary to run vcredist on a machine where Visual C++ is already
installed. It shouldn't do any harm either.

> I did full rebuild of everything (QuantLib, genXXX, and then
> QuantLibObjectHandler). For ObjectHandler I did with flag Using FAT 32
> workaround as Yes (as it is recommended on the net). Dependendwlaker still
> indicates that QuantLibObjectHandler is still missing msvcr80.dll (for the
> release mode) and msvcr80d.dll (for the debug mode). I have also checked
> that my manifest is looking for the dll-s above with the same version
> numbers as I have on my machine.

I don't entirely understand your comments above. There is no
QuantLibObjectHandler. QuantLibAddin contains a project called
QuantLibObjects. I wouldn't expect you to run Dependency Walker on that,
rather on the XLL.

Please try the following:

1) svn checkout from

https://quantlib.svn.sourceforge.net/svnroot/quantlib/trunk

to

C:\projects\trunk

2) Start VC8

3) Open QuantLibXL\QuantLibXL_full_vc8.sln, select configuration Release, and
do Build | Build Solution.

4) Start Excel and load QuantLibXL\xll\QuantLibXL-vc80-mt-s-0_9_6.xll

Note that with configuration Release, the Microsoft C runtime is statically
linked into the XLL, so there is no runtime dependency on the MS DLLs.

> I plan to do a full rebuild somewhere Monday-Tuesday on a virgin machine
> with VS2008.

Sounds good. I think with the steps above you'll be just as well on your
existing machine.

Which version of Visual C++ are you using?

Visual C++ 2003 = VC7
Visual C++ 2005 = VC8
Visual C++ 2008 = VC9

Earlier you talk about msvcr80.dll which is VC8. Here you talk about VC9. If
you're switching to the newer compiler in an attempt to fix this problem, that
shouldn't be necessary though it shouldn't hurt either.

> I am going to use VS2008 with SP1. Do I need to run vsredist.exe before
> douing the full rebuild?

On the machine where Visual Studio is installed, it should not be necessary to
run vcredist at all.

If you copy the XLL to another computer:
- If the XLL was compiled with configuration Release, then it is not necessary
to install vcredist.
- If the XLL was compiled with configuration Release CRTDLL, then you need to
install vcredist.

I haven't tried SP1 for VC9. For VC8, the vcredist on the Microsoft website
corresponds to VC8 without SP1. When you install SP1 for VC8, you get new
vcredist files here:

C:\Program Files\Microsoft Visual Studio
8\SDK\v2.0\BootStrapper\Packages\vcredist_x86\vcredist_x86.exe
C:\Program Files\Microsoft Visual Studio
8\SDK\v2.0\BootStrapper\Packages\vcredist_x64\vcredist_x64.exe

I think it may be the case that a binary compiled with VC8 no SP1 will crash
if executed with the vcredist from VC8+SP1, and vice versa. I have yet to
establish whether this is true of the Release CRTDLL build of QuantLibXL.

> did you take VS2008 with sp1, or just vs2008?

For VS2008, aka VC9, I just have the Express edition which I use only to test
that the build completes successfully. For my production work I use VC8+SP1.

> Thank you very much for your help again - it is nice to feel that I can ask
> somebody for an advice.

No problem, really. I'm pleased at the prospect that you may contribute back
to the Project but in any case we're always happy to help.

Regards,
Eric

-------------------------
Eric Ehlers
nazcatech sprl | Brussels | http://www.nazcatech.be
Distributed computing for pricing analytics - Use Microsoft Excel as a client
to the Grid

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
QuantLib-dev mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-dev

Slava D

Re: [Quantlib-users] Using QuantLibXL

Hi Eric,

thank you very much for your -email.

>>it's not necessary to run vcredist on a machine where Visual C++ is already

installed. It shouldn't do any harm either.

Yep, thanks will know this.

>>I don't entirely understand your comments above. There is no

QuantLibObjectHandler. QuantLibAddin contains a project called
QuantLibObjects. I wouldn't expect you to run Dependency Walker on that,
rather on the XLL.

sorry for the confusion. I ran dependency walker on QuantLibObject xll-s.

I did everything with VS2005, but plan to try again with VS2008.

>>Please try the following:

1) svn checkout from

https://quantlib.svn.sourceforge.net/svnroot/quantlib/trunk

to

C:\projects\trunk

2) Start VC8

3) Open QuantLibXL\QuantLibXL_full_vc8.sln, select configuration Release, and
do Build | Build Solution.

4) Start Excel and load QuantLibXL\xll\QuantLibXL-vc80-mt-s-0_9_6.xll

am I missing something - can I compile QuantLibXL without compiling QuantLib, genXXX and QuantLibObject?

>>I'm pleased at the prospect that you may contribute back
to the Project

To be honest, I would like to give something back.

As soon as I get QuantLib up and running, I plan to come back and to see whether I can do something.

Thanks for the clarifications with the vcredist.

I got into all those details out of despair - all compilations were clean but QuantLib xll was not opening.

I have not tried anything again as I am still waiting for my VS2008 license.

I will update when I try again.

thanks you very much for your help.

many thanks,

Slava

Eric Ehlers-2

Re: [Quantlib-users] Using QuantLibXL

Hi Slava,

On Wed, September 10, 2008 20:26, Slava D wrote:
> am I missing something - can I compile QuantLibXL without compiling
> QuantLib, genXXX and QuantLibObject?

QuantLibXL_full_vc?.sln includes all dependencies. See
http://www.quantlibaddin.org/build_qlxl.html.

Regards,
Eric

-------------------------
Eric Ehlers
nazcatech sprl | Brussels | http://www.nazcatech.be
Distributed computing for pricing analytics - Use Microsoft Excel as a client
to the Grid

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
QuantLib-dev mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-dev