xitzee has asked for the wisdom of the Perl Monks concerning the following question:

Hello,

ive got an app (on windows) which is using DMO (Database management objects) to access and manage SQL Server. I am very well aware DMO is old and long time deprecate but well worked so far. However with release of TLS 1.2 and by disabling TLS 1.0 protocol which is used by DMO app cant connect.

Ive tried to replace DMO code with SMO (Shared management objects) as its quite natural evaluation but i struggle on it really badly.

Only information with exampels which i found was here: https://blog.pythian.com/perl-and-server-management-objects-smo/
However mentioned CLR module just wont compile on Windows for me, and PPM doesnt have it in its base as it failed to build there in every version of Perl as well.

Is there any monk capable to help me here?

Replies are listed 'Best First'.
Re: SMO in Perl
by syphilis (Archbishop) on Feb 05, 2019 at 13:16 UTC
    Is there any monk capable to help me here?

    Ooooo ... Win32::CLR requires Visual C++ 2005 or later, and a perl that has been built using that compiler.
    There's plenty of monks working with perl on Windows, but not with Visual C++ 2005 or later.
    The fact that the module has not been updated in over 10 years is also a little worrying.

    If you have "Visual C++ 2005 or later", I would suggest that you start by building perl-5.28.x from source with that compiler. (I, and probably others, could help you if you strike difficulty with that.)
    Then, build and install Win32::CLR on that perl, and see how it goes from there.

    I don't think it's worth trying with perls that have been built with mingw ports of gcc.

    Cheers,
    Rob