dbTalk Databases Forums  

[Info-ingres] Building DBD::Ingres for ActiveState Perl

comp.databases.ingres comp.databases.ingres


Discuss [Info-ingres] Building DBD::Ingres for ActiveState Perl in the comp.databases.ingres forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Roger Hill
 
Posts: n/a

Default [Info-ingres] Building DBD::Ingres for ActiveState Perl - 08-03-2005 , 02:58 PM






Hi Gang:

I'm trying to build the Perl DBD for Ingres on Windows XP.


So, ActiveState Perl is installed.
Both nmake and dmake are installed. (dmake fails to run cleanly and
crashes, nmake runs through ok).

Ingres r3 is installed.
MinGW and Msys to provide a gcc environment are installed, and I can
satisfactorily make and install and run Math::FFT for example.

I had to tweak the makefile in several ways; the makefile as generated
was looking for the libs in abflnk.opt (libingres.lib, shell32.lib etc),
whereas it looks to me as if I need to link against shell32.a etc.
Libingres.lib is ok.

Got it to compile - lots of warnings, which I can post if it helps, but
when I try a simple connect to an r3 database perl just dies - there is
an error report that I can post too, if needed. (I can use DBD::ODBC to
connect to the same database ok, but then that was a precompiled module
from Active State)

The question is - has anyone got DBD::Ingres working on Windows with
Active State Perl? If so, pointers would be appreciated.

Roger

Reply With Quote
  #2  
Old   
ht000@nx5000.haarlev.linux.dk
 
Posts: n/a

Default Re: [Info-ingres] Building DBD::Ingres for ActiveState Perl - 08-04-2005 , 01:12 AM






Roger Hill <rhill (AT) hillconsult (DOT) com> writes:

Quote:
Ingres r3 is installed.
I know of people who have installed DBD::Ingres on Win32 and ActiveState
Perl, but using earlier versions of Ingres, ie. 6.4 or OI 1.2.
I have not heard of anyone using r3 with success on Win32 - but not of
the opposite till now.

Quote:
MinGW and Msys to provide a gcc environment are installed, and I can
satisfactorily make and install and run Math::FFT for example.

I had to tweak the makefile in several ways; the makefile as generated
was looking for the libs in abflnk.opt (libingres.lib, shell32.lib etc),
whereas it looks to me as if I need to link against shell32.a etc.
Libingres.lib is ok.
DBD::Ingres is an ESQL/C program, as you no doubt are aware, and the best
guesstimate of which libraries to use is abflnk.opt - if you can point me
at another and better place, then please do so.

Quote:
Got it to compile - lots of warnings, which I can post if it helps, but
when I try a simple connect to an r3 database perl just dies - there is
an error report that I can post too, if needed. (I can use DBD::ODBC to
connect to the same database ok, but then that was a precompiled module
from Active State)
Have you tried setting DBI_TRACE to a high value (4 or 5 should do it) and
see where it hangs?

Quote:
The question is - has anyone got DBD::Ingres working on Windows with
Active State Perl? If so, pointers would be appreciated.
Please - to me also!

--
Henrik Tougaard, DBD::Ingres maintainer
htoug (AT) cpan (DOT) org


Reply With Quote
  #3  
Old   
Croker, Grant
 
Posts: n/a

Default RE: [Info-ingres] Building DBD::Ingres for ActiveState Perl - 08-04-2005 , 04:37 AM





Quote:
Roger Hill <rhill (AT) hillconsult (DOT) com> writes:


The question is - has anyone got DBD::Ingres working on Windows with
Active State Perl? If so, pointers would be appreciated.

Please - to me also!

It is possible to build the DBI using Active State's perl - however I
have only done it with Microsoft's Visual C++ compiler. If you don't
have the compiler you can download it from
http://msdn.microsoft.com/visualc/vctoolkit2003/. Note this is just the
command line stuff no pretty gui for debugging.

After testing and installing DBI I did the following within the
DBD::Ingres source area:

- set LIB to include %II_SYSTEM%\ingres\lib otherwise the next step
fails to find libingres.lib
- perl Makefile.pl
- nmake
- set DBI_DBNAME=iidbdb
- nmake test
- nmake install

Output posted below:

perl Makefile.pl

Configuring DBD::Ingres ...

Try 'perl Makefile.PL -v'
if you have any problems.


Using Ingres in C:\IngresGC

Checking if your kit is complete...
Looks good
Writing Makefile for DBD::Ingres

nmake

cp Ingres.pm blib\lib\DBD\Ingres.pm
cp ingtest.pl blib\lib\DBD\ingtest.pl
cp ingperl.pl blib\lib/ingperl.pl
cp Ingperl.pm blib\lib/Ingperl.pm
C:\ASPerl\bin\perl.exe -p -e "s!/\*64\*!!" dbdimp.psc >
dbdimp.sc
C:\IngresGC\ingres\bin\esqlc.exe -o.h -w -p dbdimp.sc
ESQL dbdimp.sc:
C:\ASPerl\bin\perl.exe -p -e "s/~DRIVER~/Ingres/g"
<C:\ASPerl\site\lib/auto/DBI/Driver.xst >Ingres.xsi
C:\ASPerl\bin\perl.exe C:\ASPerl\lib\ExtUtils/xsubpp -typemap
C:\ASPerl\lib\ExtUtils\typemap Ingres.xs > Ingres.xsc &&
C:\ASPerl\bin\perl.exe -MExtUtils::Command -e mv Ingres.xsc Ingres.c
cl -c -IC:\ASPerl\site\lib/auto/DBI -nologo -Gf -W3 -MD -Zi
-DNDEBUG -O1 -DWIN32 -D_CONSOLE -DNO_STRICT -DHAVE_DES_FCRYPT
-DBUILT_BY_ACTIVESTATE -DNO_HASH_SEED -DUSE_SITECUSTOMIZE
-DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -DUSE_PERLIO
-DPERL_MSVCRT_READFIX -g -DVERSION=\"0.51\" -DXS_VERSION=\"0.51\"
"-IC:\ASPerl\lib\CORE" Ingres.c
Ingres.c
c1 : warning C4349: /Gf is deprecated and will not be supported in
future versions of Visual C++; remove /Gf or use /GF instead
Ingres.xs(30) : warning C4013: 'dbd_db_do' undefined; assuming extern
returning int
C:\IngresGC\ingres\bin\esqlc.exe -o.h -w -p dbdimp.sc
ESQL dbdimp.sc:
cl -c -IC:\ASPerl\site\lib/auto/DBI -nologo -Gf -W3 -MD -Zi
-DNDEBUG -O1 -DWIN32 -D_CONSOLE -DNO_STRICT -DHAVE_DES_FCRYPT
-DBUILT_BY_ACTIVESTATE -DNO_HASH_SEED -DUSE_SITECUSTOMIZE
-DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -DUSE_PERLIO
-DPERL_MSVCRT_READFIX -g -DVERSION=\"0.51\" -DXS_VERSION=\"0.51\"
"-IC:\ASPerl\lib\CORE" dbdimp.c
dbdimp.c
c1 : warning C4349: /Gf is deprecated and will not be supported in
future versions of Visual C++; remove /Gf or use /GF instead
dbdimp.sc(583) : warning C4101: 'i' : unreferenced local variable
dbdimp.sc(769) : warning C4018: '>' : signed/unsigned mismatch
dbdimp.sc(1315) : warning C4101: 'ch' : unreferenced local variable
Running Mkbootstrap for DBD::Ingres ()
C:\ASPerl\bin\perl.exe -MExtUtils::Command -e chmod 644
Ingres.bs
C:\ASPerl\bin\perl.exe -MExtUtils::Mksymlists -e
"Mksymlists('NAME'=>\"DBD::Ingres\", 'DLBASE' => 'Ingres', 'DL_FUNCS' =>
{ }, 'FUNCLIST' => [], 'IMPORTS' => { }, 'DL_VARS' => []);"
link -out:blib\arch\auto\DBD\Ingres\Ingres.dll -dll -nologo
-nodefaultlib -debug -opt:ref,icf -libpath:"C:\ASPerl\lib\CORE"
-machine:x86 Ingres.obj dbdimp.obj libingres.lib shell32.lib msvcrt.lib
libc.lib kernel32.lib user32.lib mpr.lib advapi32.lib netapi32.lib
libcmt.lib C:\ASPerl\lib\CORE\perl58.lib
C:\IngresGC\ingres\lib\libingres.lib "C:\Program Files\Microsoft Visual
Studio .NET 2003\VC7\PlatformSDK\lib\shell32.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\LIB\msvcrt.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\LIB\libc.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\LIB\kernel32.lib"
"C:\Program Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\user32.lib" "C:\Program Files\Microsoft Visual
Studio .NET 2003\VC7\PlatformSDK\lib\mpr.lib" "C:\Program
Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\advapi32.lib" "C:\Program Files\Microsoft
Visual Studio .NET 2003\VC7\PlatformSDK\lib\netapi32.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\LIB\libcmt.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\LIB\oldnames.lib"
"C:\Program Files\Microsoft Visual Studio .NET
2003\VC7\LIB\kernel32.lib" "C:\Program Files\Microsoft Visual Studio
..NET 2003\VC7\PlatformSDK\lib\user32.lib" "C:\Program Files\Microsoft
Visual Studio .NET 2003\VC7\PlatformSDK\lib\gdi32.lib" "C:\Program
Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\winspool.lib" "C:\Program Files\Microsoft
Visual Studio .NET 2003\VC7\PlatformSDK\lib\comdlg32.lib" "C:\Program
Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\advapi32.lib" "C:\Program Files\Microsoft
Visual Studio .NET 2003\VC7\PlatformSDK\lib\shell32.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\PlatformSDK\lib\ole32.lib"
"C:\Program Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\oleaut32.lib" "C:\Program Files\Microsoft
Visual Studio .NET 2003\VC7\PlatformSDK\lib\netapi32.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\PlatformSDK\lib\uuid.lib"
"C:\Program Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\ws2_32.lib" "C:\Program Files\Microsoft Visual
Studio .NET 2003\VC7\PlatformSDK\lib\mpr.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\PlatformSDK\lib\winmm.lib"
"C:\Program Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\version.lib" "C:\Program Files\Microsoft Visual
Studio .NET 2003\VC7\PlatformSDK\lib\odbc32.lib" "C:\Program
Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\odbccp32.lib" "C:\Program Files\Microsoft
Visual Studio .NET 2003\VC7\LIB\msvcrt.lib" -def:Ingres.def
Creating library blib\arch\auto\DBD\Ingres\Ingres.lib and object
blib\arch\auto\DBD\Ingres\Ingres.exp
C:\ASPerl\bin\perl.exe -MExtUtils::Command -e chmod 755
blib\arch\auto\DBD\Ingres\Ingres.dll
C:\ASPerl\bin\perl.exe -MExtUtils::Command -e cp Ingres.bs
blib\arch\auto\DBD\Ingres\Ingres.bs
C:\ASPerl\bin\perl.exe -MExtUtils::Command -e chmod 644
blib\arch\auto\DBD\Ingres\Ingres.bs

set DBI_DBNAME=iidbdb
nmake test

C:\ASPerl\bin\perl.exe "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib\lib', 'blib\arch')" t\datatypes.t t\dbi.t
t\event.t t\exec.t
t\datatypes....ok
t\dbi..........ok
t\event........ok
t\exec.........skipped
all skipped: no reason given
All tests successful, 1 test skipped.
Files=4, Tests=364, 13 wallclock secs ( 0.00 cusr + 0.00 csys = 0.00
CPU)

nmake install

Installing C:\ASPerl\site\lib\auto\DBD\Ingres\Ingres.dll
Installing C:\ASPerl\site\lib\auto\DBD\Ingres\Ingres.exp
Installing C:\ASPerl\site\lib\auto\DBD\Ingres\Ingres.lib
Installing C:\ASPerl\site\lib\auto\DBD\Ingres\Ingres.pdb
Files found in blib\arch: installing files in blib\lib into architecture
dependent library tree
Appending installation info to C:\ASPerl\lib/perllocal.pod




Reply With Quote
  #4  
Old   
Roger Hill
 
Posts: n/a

Default RE: [Info-ingres] Building DBD::Ingres for ActiveState Perl - 08-04-2005 , 05:28 AM



Thanks for the tip...I'll try again this evening.

Much appreciated.

Roger


On Thu, August 4, 2005 10:37, Croker, Grant said:
Quote:

Roger Hill <rhill (AT) hillconsult (DOT) com> writes:


The question is - has anyone got DBD::Ingres working on Windows with
Active State Perl? If so, pointers would be appreciated.

Please - to me also!


It is possible to build the DBI using Active State's perl - however I
have only done it with Microsoft's Visual C++ compiler. If you don't
have the compiler you can download it from
http://msdn.microsoft.com/visualc/vctoolkit2003/. Note this is just the
command line stuff no pretty gui for debugging.

After testing and installing DBI I did the following within the
DBD::Ingres source area:

- set LIB to include %II_SYSTEM%\ingres\lib otherwise the next step
fails to find libingres.lib
- perl Makefile.pl
- nmake
- set DBI_DBNAME=iidbdb
- nmake test
- nmake install

Output posted below:

perl Makefile.pl

Configuring DBD::Ingres ...

Try 'perl Makefile.PL -v'
if you have any problems.


Using Ingres in C:\IngresGC

Checking if your kit is complete...
Looks good
Writing Makefile for DBD::Ingres

nmake

cp Ingres.pm blib\lib\DBD\Ingres.pm
cp ingtest.pl blib\lib\DBD\ingtest.pl
cp ingperl.pl blib\lib/ingperl.pl
cp Ingperl.pm blib\lib/Ingperl.pm
C:\ASPerl\bin\perl.exe -p -e "s!/\*64\*!!" dbdimp.psc
dbdimp.sc
C:\IngresGC\ingres\bin\esqlc.exe -o.h -w -p dbdimp.sc
ESQL dbdimp.sc:
C:\ASPerl\bin\perl.exe -p -e "s/~DRIVER~/Ingres/g"
C:\ASPerl\site\lib/auto/DBI/Driver.xst >Ingres.xsi
C:\ASPerl\bin\perl.exe C:\ASPerl\lib\ExtUtils/xsubpp -typemap
C:\ASPerl\lib\ExtUtils\typemap Ingres.xs > Ingres.xsc &&
C:\ASPerl\bin\perl.exe -MExtUtils::Command -e mv Ingres.xsc Ingres.c
cl -c -IC:\ASPerl\site\lib/auto/DBI -nologo -Gf -W3 -MD -Zi
-DNDEBUG -O1 -DWIN32 -D_CONSOLE -DNO_STRICT -DHAVE_DES_FCRYPT
-DBUILT_BY_ACTIVESTATE -DNO_HASH_SEED -DUSE_SITECUSTOMIZE
-DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -DUSE_PERLIO
-DPERL_MSVCRT_READFIX -g -DVERSION=\"0.51\" -DXS_VERSION=\"0.51\"
"-IC:\ASPerl\lib\CORE" Ingres.c
Ingres.c
c1 : warning C4349: /Gf is deprecated and will not be supported in
future versions of Visual C++; remove /Gf or use /GF instead
Ingres.xs(30) : warning C4013: 'dbd_db_do' undefined; assuming extern
returning int
C:\IngresGC\ingres\bin\esqlc.exe -o.h -w -p dbdimp.sc
ESQL dbdimp.sc:
cl -c -IC:\ASPerl\site\lib/auto/DBI -nologo -Gf -W3 -MD -Zi
-DNDEBUG -O1 -DWIN32 -D_CONSOLE -DNO_STRICT -DHAVE_DES_FCRYPT
-DBUILT_BY_ACTIVESTATE -DNO_HASH_SEED -DUSE_SITECUSTOMIZE
-DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -DUSE_PERLIO
-DPERL_MSVCRT_READFIX -g -DVERSION=\"0.51\" -DXS_VERSION=\"0.51\"
"-IC:\ASPerl\lib\CORE" dbdimp.c
dbdimp.c
c1 : warning C4349: /Gf is deprecated and will not be supported in
future versions of Visual C++; remove /Gf or use /GF instead
dbdimp.sc(583) : warning C4101: 'i' : unreferenced local variable
dbdimp.sc(769) : warning C4018: '>' : signed/unsigned mismatch
dbdimp.sc(1315) : warning C4101: 'ch' : unreferenced local variable
Running Mkbootstrap for DBD::Ingres ()
C:\ASPerl\bin\perl.exe -MExtUtils::Command -e chmod 644
Ingres.bs
C:\ASPerl\bin\perl.exe -MExtUtils::Mksymlists -e
"Mksymlists('NAME'=>\"DBD::Ingres\", 'DLBASE' => 'Ingres', 'DL_FUNCS' =
{ }, 'FUNCLIST' => [], 'IMPORTS' => { }, 'DL_VARS' => []);"
link -out:blib\arch\auto\DBD\Ingres\Ingres.dll -dll -nologo
-nodefaultlib -debug -opt:ref,icf -libpath:"C:\ASPerl\lib\CORE"
-machine:x86 Ingres.obj dbdimp.obj libingres.lib shell32.lib msvcrt.lib
libc.lib kernel32.lib user32.lib mpr.lib advapi32.lib netapi32.lib
libcmt.lib C:\ASPerl\lib\CORE\perl58.lib
C:\IngresGC\ingres\lib\libingres.lib "C:\Program Files\Microsoft Visual
Studio .NET 2003\VC7\PlatformSDK\lib\shell32.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\LIB\msvcrt.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\LIB\libc.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\LIB\kernel32.lib"
"C:\Program Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\user32.lib" "C:\Program Files\Microsoft Visual
Studio .NET 2003\VC7\PlatformSDK\lib\mpr.lib" "C:\Program
Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\advapi32.lib" "C:\Program Files\Microsoft
Visual Studio .NET 2003\VC7\PlatformSDK\lib\netapi32.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\LIB\libcmt.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\LIB\oldnames.lib"
"C:\Program Files\Microsoft Visual Studio .NET
2003\VC7\LIB\kernel32.lib" "C:\Program Files\Microsoft Visual Studio
.NET 2003\VC7\PlatformSDK\lib\user32.lib" "C:\Program Files\Microsoft
Visual Studio .NET 2003\VC7\PlatformSDK\lib\gdi32.lib" "C:\Program
Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\winspool.lib" "C:\Program Files\Microsoft
Visual Studio .NET 2003\VC7\PlatformSDK\lib\comdlg32.lib" "C:\Program
Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\advapi32.lib" "C:\Program Files\Microsoft
Visual Studio .NET 2003\VC7\PlatformSDK\lib\shell32.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\PlatformSDK\lib\ole32.lib"
"C:\Program Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\oleaut32.lib" "C:\Program Files\Microsoft
Visual Studio .NET 2003\VC7\PlatformSDK\lib\netapi32.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\PlatformSDK\lib\uuid.lib"
"C:\Program Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\ws2_32.lib" "C:\Program Files\Microsoft Visual
Studio .NET 2003\VC7\PlatformSDK\lib\mpr.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\PlatformSDK\lib\winmm.lib"
"C:\Program Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\version.lib" "C:\Program Files\Microsoft Visual
Studio .NET 2003\VC7\PlatformSDK\lib\odbc32.lib" "C:\Program
Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\odbccp32.lib" "C:\Program Files\Microsoft
Visual Studio .NET 2003\VC7\LIB\msvcrt.lib" -def:Ingres.def
Creating library blib\arch\auto\DBD\Ingres\Ingres.lib and object
blib\arch\auto\DBD\Ingres\Ingres.exp
C:\ASPerl\bin\perl.exe -MExtUtils::Command -e chmod 755
blib\arch\auto\DBD\Ingres\Ingres.dll
C:\ASPerl\bin\perl.exe -MExtUtils::Command -e cp Ingres.bs
blib\arch\auto\DBD\Ingres\Ingres.bs
C:\ASPerl\bin\perl.exe -MExtUtils::Command -e chmod 644
blib\arch\auto\DBD\Ingres\Ingres.bs

set DBI_DBNAME=iidbdb
nmake test

C:\ASPerl\bin\perl.exe "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib\lib', 'blib\arch')" t\datatypes.t t\dbi.t
t\event.t t\exec.t
t\datatypes....ok
t\dbi..........ok
t\event........ok
t\exec.........skipped
all skipped: no reason given
All tests successful, 1 test skipped.
Files=4, Tests=364, 13 wallclock secs ( 0.00 cusr + 0.00 csys = 0.00
CPU)

nmake install

Installing C:\ASPerl\site\lib\auto\DBD\Ingres\Ingres.dll
Installing C:\ASPerl\site\lib\auto\DBD\Ingres\Ingres.exp
Installing C:\ASPerl\site\lib\auto\DBD\Ingres\Ingres.lib
Installing C:\ASPerl\site\lib\auto\DBD\Ingres\Ingres.pdb
Files found in blib\arch: installing files in blib\lib into architecture
dependent library tree
Appending installation info to C:\ASPerl\lib/perllocal.pod


_______________________________________________
Info-ingres mailing list
Info-ingres (AT) cariboulake (DOT) com
http://mailman.cariboulake.com/mailm...py/info-ingres



################################################
Roger Hill 07739 707 180
################################################



Reply With Quote
  #5  
Old   
Roger Hill
 
Posts: n/a

Default Re: [Info-ingres] Building DBD::Ingres for ActiveState Perl - 08-04-2005 , 12:50 PM



Hi Grant.

I still am having some problems.

Unchanged Makefile.PL at this point.

I get lots of missing libs, and then a missing header file.

Please bear in mind that I am not sure what I'm doing at this point - so
it's probably a stupid error.

Thanks
Roger

I get:
C:\Program Files\Microsoft Visual C++ Toolkit 2003>cd
\data\downloads\DBD-Ingres
-0.51

C:\Data\Downloads\DBD-Ingres-0.51>perl makefile.pl

Configuring DBD::Ingres ...

Try 'perl Makefile.PL -v'
if you have any problems.


Using Ingres in C:\Program Files\CA\Ingres [II]

Note (probably harmless): No library found for shell32.lib
Note (probably harmless): No library found for msvcrt.lib
Note (probably harmless): No library found for user32.lib
Note (probably harmless): No library found for mpr.lib
Note (probably harmless): No library found for advapi32.lib
Note (probably harmless): No library found for netapi32.lib
Note (probably harmless): No library found for user32.lib
Note (probably harmless): No library found for gdi32.lib
Note (probably harmless): No library found for winspool.lib
Note (probably harmless): No library found for comdlg32.lib
Note (probably harmless): No library found for advapi32.lib
Note (probably harmless): No library found for shell32.lib
Note (probably harmless): No library found for ole32.lib
Note (probably harmless): No library found for oleaut32.lib
Note (probably harmless): No library found for netapi32.lib
Note (probably harmless): No library found for uuid.lib
Note (probably harmless): No library found for ws2_32.lib
Note (probably harmless): No library found for mpr.lib
Note (probably harmless): No library found for winmm.lib
Note (probably harmless): No library found for version.lib
Note (probably harmless): No library found for odbc32.lib
Note (probably harmless): No library found for odbccp32.lib
Note (probably harmless): No library found for msvcrt.lib
Writing Makefile for DBD::Ingres

C:\Data\Downloads\DBD-Ingres-0.51>nmake

Microsoft (R) Program Maintenance Utility Version 1.50
Copyright (c) Microsoft Corp 1988-94. All rights reserved.

cl -c -IC:\Perl\site\lib/auto/DBI -nologo -Gf -W3 -MD -Zi
-DNDEBUG -O1
-DWIN32 -D_CONSOLE -DNO_STRICT -DHAVE_DES_FCRYPT
-DBUILT_BY_ACTIVESTATE -DNO_HA
SH_SEED -DUSE_SITECUSTOMIZE -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS
-DUSE_PE
RLIO -DPERL_MSVCRT_READFIX -g -DVERSION=\"0.51\"
-DXS_VERSION=\"0.51\" "-IC
:\Perl\lib\CORE" Ingres.c
cl : Command line warning D4002 : ignoring unknown option '-g'
Ingres.c
c1 : warning C4349: /Gf is deprecated and will not be supported in
future versio
ns of Visual C++; remove /Gf or use /GF instead
c:\Perl\lib\CORE\win32.h(61) : fatal error C1083: Cannot open include
file: 'win
dows.h': No such file or directory
NMAKE : fatal error U1077: 'C:\WINDOWS\system32\cmd.exe' : return code '0x2'
Stop.

C:\Data\Downloads\DBD-Ingres-0.51>



Croker, Grant wrote:
Quote:
Roger Hill <rhill (AT) hillconsult (DOT) com> writes:


The question is - has anyone got DBD::Ingres working on Windows with
Active State Perl? If so, pointers would be appreciated.

Please - to me also!



It is possible to build the DBI using Active State's perl - however I
have only done it with Microsoft's Visual C++ compiler. If you don't
have the compiler you can download it from
http://msdn.microsoft.com/visualc/vctoolkit2003/. Note this is just the
command line stuff no pretty gui for debugging.

After testing and installing DBI I did the following within the
DBD::Ingres source area:

- set LIB to include %II_SYSTEM%\ingres\lib otherwise the next step
fails to find libingres.lib
- perl Makefile.pl
- nmake
- set DBI_DBNAME=iidbdb
- nmake test
- nmake install

Output posted below:

perl Makefile.pl

Configuring DBD::Ingres ...

Try 'perl Makefile.PL -v'
if you have any problems.


Using Ingres in C:\IngresGC

Checking if your kit is complete...
Looks good
Writing Makefile for DBD::Ingres

nmake

cp Ingres.pm blib\lib\DBD\Ingres.pm
cp ingtest.pl blib\lib\DBD\ingtest.pl
cp ingperl.pl blib\lib/ingperl.pl
cp Ingperl.pm blib\lib/Ingperl.pm
C:\ASPerl\bin\perl.exe -p -e "s!/\*64\*!!" dbdimp.psc
dbdimp.sc
C:\IngresGC\ingres\bin\esqlc.exe -o.h -w -p dbdimp.sc
ESQL dbdimp.sc:
C:\ASPerl\bin\perl.exe -p -e "s/~DRIVER~/Ingres/g"
C:\ASPerl\site\lib/auto/DBI/Driver.xst >Ingres.xsi
C:\ASPerl\bin\perl.exe C:\ASPerl\lib\ExtUtils/xsubpp -typemap
C:\ASPerl\lib\ExtUtils\typemap Ingres.xs > Ingres.xsc &&
C:\ASPerl\bin\perl.exe -MExtUtils::Command -e mv Ingres.xsc Ingres.c
cl -c -IC:\ASPerl\site\lib/auto/DBI -nologo -Gf -W3 -MD -Zi
-DNDEBUG -O1 -DWIN32 -D_CONSOLE -DNO_STRICT -DHAVE_DES_FCRYPT
-DBUILT_BY_ACTIVESTATE -DNO_HASH_SEED -DUSE_SITECUSTOMIZE
-DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -DUSE_PERLIO
-DPERL_MSVCRT_READFIX -g -DVERSION=\"0.51\" -DXS_VERSION=\"0.51\"
"-IC:\ASPerl\lib\CORE" Ingres.c
Ingres.c
c1 : warning C4349: /Gf is deprecated and will not be supported in
future versions of Visual C++; remove /Gf or use /GF instead
Ingres.xs(30) : warning C4013: 'dbd_db_do' undefined; assuming extern
returning int
C:\IngresGC\ingres\bin\esqlc.exe -o.h -w -p dbdimp.sc
ESQL dbdimp.sc:
cl -c -IC:\ASPerl\site\lib/auto/DBI -nologo -Gf -W3 -MD -Zi
-DNDEBUG -O1 -DWIN32 -D_CONSOLE -DNO_STRICT -DHAVE_DES_FCRYPT
-DBUILT_BY_ACTIVESTATE -DNO_HASH_SEED -DUSE_SITECUSTOMIZE
-DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -DUSE_PERLIO
-DPERL_MSVCRT_READFIX -g -DVERSION=\"0.51\" -DXS_VERSION=\"0.51\"
"-IC:\ASPerl\lib\CORE" dbdimp.c
dbdimp.c
c1 : warning C4349: /Gf is deprecated and will not be supported in
future versions of Visual C++; remove /Gf or use /GF instead
dbdimp.sc(583) : warning C4101: 'i' : unreferenced local variable
dbdimp.sc(769) : warning C4018: '>' : signed/unsigned mismatch
dbdimp.sc(1315) : warning C4101: 'ch' : unreferenced local variable
Running Mkbootstrap for DBD::Ingres ()
C:\ASPerl\bin\perl.exe -MExtUtils::Command -e chmod 644
Ingres.bs
C:\ASPerl\bin\perl.exe -MExtUtils::Mksymlists -e
"Mksymlists('NAME'=>\"DBD::Ingres\", 'DLBASE' => 'Ingres', 'DL_FUNCS' =
{ }, 'FUNCLIST' => [], 'IMPORTS' => { }, 'DL_VARS' => []);"
link -out:blib\arch\auto\DBD\Ingres\Ingres.dll -dll -nologo
-nodefaultlib -debug -opt:ref,icf -libpath:"C:\ASPerl\lib\CORE"
-machine:x86 Ingres.obj dbdimp.obj libingres.lib shell32.lib msvcrt.lib
libc.lib kernel32.lib user32.lib mpr.lib advapi32.lib netapi32.lib
libcmt.lib C:\ASPerl\lib\CORE\perl58.lib
C:\IngresGC\ingres\lib\libingres.lib "C:\Program Files\Microsoft Visual
Studio .NET 2003\VC7\PlatformSDK\lib\shell32.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\LIB\msvcrt.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\LIB\libc.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\LIB\kernel32.lib"
"C:\Program Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\user32.lib" "C:\Program Files\Microsoft Visual
Studio .NET 2003\VC7\PlatformSDK\lib\mpr.lib" "C:\Program
Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\advapi32.lib" "C:\Program Files\Microsoft
Visual Studio .NET 2003\VC7\PlatformSDK\lib\netapi32.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\LIB\libcmt.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\LIB\oldnames.lib"
"C:\Program Files\Microsoft Visual Studio .NET
2003\VC7\LIB\kernel32.lib" "C:\Program Files\Microsoft Visual Studio
.NET 2003\VC7\PlatformSDK\lib\user32.lib" "C:\Program Files\Microsoft
Visual Studio .NET 2003\VC7\PlatformSDK\lib\gdi32.lib" "C:\Program
Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\winspool.lib" "C:\Program Files\Microsoft
Visual Studio .NET 2003\VC7\PlatformSDK\lib\comdlg32.lib" "C:\Program
Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\advapi32.lib" "C:\Program Files\Microsoft
Visual Studio .NET 2003\VC7\PlatformSDK\lib\shell32.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\PlatformSDK\lib\ole32.lib"
"C:\Program Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\oleaut32.lib" "C:\Program Files\Microsoft
Visual Studio .NET 2003\VC7\PlatformSDK\lib\netapi32.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\PlatformSDK\lib\uuid.lib"
"C:\Program Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\ws2_32.lib" "C:\Program Files\Microsoft Visual
Studio .NET 2003\VC7\PlatformSDK\lib\mpr.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\PlatformSDK\lib\winmm.lib"
"C:\Program Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\version.lib" "C:\Program Files\Microsoft Visual
Studio .NET 2003\VC7\PlatformSDK\lib\odbc32.lib" "C:\Program
Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\odbccp32.lib" "C:\Program Files\Microsoft
Visual Studio .NET 2003\VC7\LIB\msvcrt.lib" -def:Ingres.def
Creating library blib\arch\auto\DBD\Ingres\Ingres.lib and object
blib\arch\auto\DBD\Ingres\Ingres.exp
C:\ASPerl\bin\perl.exe -MExtUtils::Command -e chmod 755
blib\arch\auto\DBD\Ingres\Ingres.dll
C:\ASPerl\bin\perl.exe -MExtUtils::Command -e cp Ingres.bs
blib\arch\auto\DBD\Ingres\Ingres.bs
C:\ASPerl\bin\perl.exe -MExtUtils::Command -e chmod 644
blib\arch\auto\DBD\Ingres\Ingres.bs

set DBI_DBNAME=iidbdb
nmake test

C:\ASPerl\bin\perl.exe "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib\lib', 'blib\arch')" t\datatypes.t t\dbi.t
t\event.t t\exec.t
t\datatypes....ok
t\dbi..........ok
t\event........ok
t\exec.........skipped
all skipped: no reason given
All tests successful, 1 test skipped.
Files=4, Tests=364, 13 wallclock secs ( 0.00 cusr + 0.00 csys = 0.00
CPU)

nmake install

Installing C:\ASPerl\site\lib\auto\DBD\Ingres\Ingres.dll
Installing C:\ASPerl\site\lib\auto\DBD\Ingres\Ingres.exp
Installing C:\ASPerl\site\lib\auto\DBD\Ingres\Ingres.lib
Installing C:\ASPerl\site\lib\auto\DBD\Ingres\Ingres.pdb
Files found in blib\arch: installing files in blib\lib into architecture
dependent library tree
Appending installation info to C:\ASPerl\lib/perllocal.pod


_______________________________________________
Info-ingres mailing list
Info-ingres (AT) cariboulake (DOT) com
http://mailman.cariboulake.com/mailm...py/info-ingres


Reply With Quote
  #6  
Old   
Roger Hill
 
Posts: n/a

Default Re: [Info-ingres] Building DBD::Ingres for ActiveState Perl - 08-04-2005 , 02:56 PM



Hi all:

Quick update.

Downloaded the MS Platform XP 32-bit SDK.

Went into that environment (command line), and ran the C++ vcvars32.bat
script.

Perl makefile.pl now gets as far as only one 'Missing library' line:
msvcrt.lib.

That does not seem to exist on my machine, except for an AMD64 version,
and an IA64 version.

So, getting closer.....


Regards
Roger


Roger Hill wrote:
Quote:
Hi Grant.

I still am having some problems.

Unchanged Makefile.PL at this point.

I get lots of missing libs, and then a missing header file.

Please bear in mind that I am not sure what I'm doing at this point - so
it's probably a stupid error.

Thanks
Roger

I get:
C:\Program Files\Microsoft Visual C++ Toolkit 2003>cd
\data\downloads\DBD-Ingres
-0.51

C:\Data\Downloads\DBD-Ingres-0.51>perl makefile.pl

Configuring DBD::Ingres ...

Try 'perl Makefile.PL -v'
if you have any problems.


Using Ingres in C:\Program Files\CA\Ingres [II]

Note (probably harmless): No library found for shell32.lib
Note (probably harmless): No library found for msvcrt.lib
Note (probably harmless): No library found for user32.lib
Note (probably harmless): No library found for mpr.lib
Note (probably harmless): No library found for advapi32.lib
Note (probably harmless): No library found for netapi32.lib
Note (probably harmless): No library found for user32.lib
Note (probably harmless): No library found for gdi32.lib
Note (probably harmless): No library found for winspool.lib
Note (probably harmless): No library found for comdlg32.lib
Note (probably harmless): No library found for advapi32.lib
Note (probably harmless): No library found for shell32.lib
Note (probably harmless): No library found for ole32.lib
Note (probably harmless): No library found for oleaut32.lib
Note (probably harmless): No library found for netapi32.lib
Note (probably harmless): No library found for uuid.lib
Note (probably harmless): No library found for ws2_32.lib
Note (probably harmless): No library found for mpr.lib
Note (probably harmless): No library found for winmm.lib
Note (probably harmless): No library found for version.lib
Note (probably harmless): No library found for odbc32.lib
Note (probably harmless): No library found for odbccp32.lib
Note (probably harmless): No library found for msvcrt.lib
Writing Makefile for DBD::Ingres

C:\Data\Downloads\DBD-Ingres-0.51>nmake

Microsoft (R) Program Maintenance Utility Version 1.50
Copyright (c) Microsoft Corp 1988-94. All rights reserved.

cl -c -IC:\Perl\site\lib/auto/DBI -nologo -Gf -W3 -MD -Zi
-DNDEBUG -O1
-DWIN32 -D_CONSOLE -DNO_STRICT -DHAVE_DES_FCRYPT -DBUILT_BY_ACTIVESTATE
-DNO_HA
SH_SEED -DUSE_SITECUSTOMIZE -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS
-DUSE_PE
RLIO -DPERL_MSVCRT_READFIX -g -DVERSION=\"0.51\"
-DXS_VERSION=\"0.51\" "-IC
:\Perl\lib\CORE" Ingres.c
cl : Command line warning D4002 : ignoring unknown option '-g'
Ingres.c
c1 : warning C4349: /Gf is deprecated and will not be supported in
future versio
ns of Visual C++; remove /Gf or use /GF instead
c:\Perl\lib\CORE\win32.h(61) : fatal error C1083: Cannot open include
file: 'win
dows.h': No such file or directory
NMAKE : fatal error U1077: 'C:\WINDOWS\system32\cmd.exe' : return code
'0x2'
Stop.

C:\Data\Downloads\DBD-Ingres-0.51



Croker, Grant wrote:


Roger Hill <rhill (AT) hillconsult (DOT) com> writes:


The question is - has anyone got DBD::Ingres working on Windows with
Active State Perl? If so, pointers would be appreciated.


Please - to me also!



It is possible to build the DBI using Active State's perl - however I
have only done it with Microsoft's Visual C++ compiler. If you don't
have the compiler you can download it from
http://msdn.microsoft.com/visualc/vctoolkit2003/. Note this is just the
command line stuff no pretty gui for debugging.

After testing and installing DBI I did the following within the
DBD::Ingres source area:

- set LIB to include %II_SYSTEM%\ingres\lib otherwise the next step
fails to find libingres.lib
- perl Makefile.pl
- nmake - set DBI_DBNAME=iidbdb
- nmake test
- nmake install

Output posted below:

perl Makefile.pl

Configuring DBD::Ingres ...

Try 'perl Makefile.PL -v'
if you have any problems.


Using Ingres in C:\IngresGC

Checking if your kit is complete...
Looks good
Writing Makefile for DBD::Ingres

nmake

cp Ingres.pm blib\lib\DBD\Ingres.pm
cp ingtest.pl blib\lib\DBD\ingtest.pl
cp ingperl.pl blib\lib/ingperl.pl
cp Ingperl.pm blib\lib/Ingperl.pm
C:\ASPerl\bin\perl.exe -p -e "s!/\*64\*!!" dbdimp.psc
dbdimp.sc
C:\IngresGC\ingres\bin\esqlc.exe -o.h -w -p dbdimp.sc
ESQL dbdimp.sc:
C:\ASPerl\bin\perl.exe -p -e "s/~DRIVER~/Ingres/g"
C:\ASPerl\site\lib/auto/DBI/Driver.xst >Ingres.xsi
C:\ASPerl\bin\perl.exe C:\ASPerl\lib\ExtUtils/xsubpp -typemap
C:\ASPerl\lib\ExtUtils\typemap Ingres.xs > Ingres.xsc &&
C:\ASPerl\bin\perl.exe -MExtUtils::Command -e mv Ingres.xsc Ingres.c
cl -c -IC:\ASPerl\site\lib/auto/DBI -nologo -Gf -W3 -MD -Zi
-DNDEBUG -O1 -DWIN32 -D_CONSOLE -DNO_STRICT -DHAVE_DES_FCRYPT
-DBUILT_BY_ACTIVESTATE -DNO_HASH_SEED -DUSE_SITECUSTOMIZE
-DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -DUSE_PERLIO
-DPERL_MSVCRT_READFIX -g -DVERSION=\"0.51\" -DXS_VERSION=\"0.51\"
"-IC:\ASPerl\lib\CORE" Ingres.c
Ingres.c
c1 : warning C4349: /Gf is deprecated and will not be supported in
future versions of Visual C++; remove /Gf or use /GF instead
Ingres.xs(30) : warning C4013: 'dbd_db_do' undefined; assuming extern
returning int
C:\IngresGC\ingres\bin\esqlc.exe -o.h -w -p dbdimp.sc
ESQL dbdimp.sc:
cl -c -IC:\ASPerl\site\lib/auto/DBI -nologo -Gf -W3 -MD -Zi
-DNDEBUG -O1 -DWIN32 -D_CONSOLE -DNO_STRICT -DHAVE_DES_FCRYPT
-DBUILT_BY_ACTIVESTATE -DNO_HASH_SEED -DUSE_SITECUSTOMIZE
-DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -DUSE_PERLIO
-DPERL_MSVCRT_READFIX -g -DVERSION=\"0.51\" -DXS_VERSION=\"0.51\"
"-IC:\ASPerl\lib\CORE" dbdimp.c
dbdimp.c
c1 : warning C4349: /Gf is deprecated and will not be supported in
future versions of Visual C++; remove /Gf or use /GF instead
dbdimp.sc(583) : warning C4101: 'i' : unreferenced local variable
dbdimp.sc(769) : warning C4018: '>' : signed/unsigned mismatch
dbdimp.sc(1315) : warning C4101: 'ch' : unreferenced local variable
Running Mkbootstrap for DBD::Ingres ()
C:\ASPerl\bin\perl.exe -MExtUtils::Command -e chmod 644
Ingres.bs
C:\ASPerl\bin\perl.exe -MExtUtils::Mksymlists -e
"Mksymlists('NAME'=>\"DBD::Ingres\", 'DLBASE' => 'Ingres', 'DL_FUNCS' =
{ }, 'FUNCLIST' => [], 'IMPORTS' => { }, 'DL_VARS' => []);"
link -out:blib\arch\auto\DBD\Ingres\Ingres.dll -dll -nologo
-nodefaultlib -debug -opt:ref,icf -libpath:"C:\ASPerl\lib\CORE"
-machine:x86 Ingres.obj dbdimp.obj libingres.lib shell32.lib msvcrt.lib
libc.lib kernel32.lib user32.lib mpr.lib advapi32.lib netapi32.lib
libcmt.lib C:\ASPerl\lib\CORE\perl58.lib
C:\IngresGC\ingres\lib\libingres.lib "C:\Program Files\Microsoft Visual
Studio .NET 2003\VC7\PlatformSDK\lib\shell32.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\LIB\msvcrt.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\LIB\libc.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\LIB\kernel32.lib"
"C:\Program Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\user32.lib" "C:\Program Files\Microsoft Visual
Studio .NET 2003\VC7\PlatformSDK\lib\mpr.lib" "C:\Program
Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\advapi32.lib" "C:\Program Files\Microsoft
Visual Studio .NET 2003\VC7\PlatformSDK\lib\netapi32.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\LIB\libcmt.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\LIB\oldnames.lib"
"C:\Program Files\Microsoft Visual Studio .NET
2003\VC7\LIB\kernel32.lib" "C:\Program Files\Microsoft Visual Studio
.NET 2003\VC7\PlatformSDK\lib\user32.lib" "C:\Program Files\Microsoft
Visual Studio .NET 2003\VC7\PlatformSDK\lib\gdi32.lib" "C:\Program
Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\winspool.lib" "C:\Program Files\Microsoft
Visual Studio .NET 2003\VC7\PlatformSDK\lib\comdlg32.lib" "C:\Program
Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\advapi32.lib" "C:\Program Files\Microsoft
Visual Studio .NET 2003\VC7\PlatformSDK\lib\shell32.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\PlatformSDK\lib\ole32.lib"
"C:\Program Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\oleaut32.lib" "C:\Program Files\Microsoft
Visual Studio .NET 2003\VC7\PlatformSDK\lib\netapi32.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\PlatformSDK\lib\uuid.lib"
"C:\Program Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\ws2_32.lib" "C:\Program Files\Microsoft Visual
Studio .NET 2003\VC7\PlatformSDK\lib\mpr.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\PlatformSDK\lib\winmm.lib"
"C:\Program Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\version.lib" "C:\Program Files\Microsoft Visual
Studio .NET 2003\VC7\PlatformSDK\lib\odbc32.lib" "C:\Program
Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\odbccp32.lib" "C:\Program Files\Microsoft
Visual Studio .NET 2003\VC7\LIB\msvcrt.lib" -def:Ingres.def
Creating library blib\arch\auto\DBD\Ingres\Ingres.lib and object
blib\arch\auto\DBD\Ingres\Ingres.exp
C:\ASPerl\bin\perl.exe -MExtUtils::Command -e chmod 755
blib\arch\auto\DBD\Ingres\Ingres.dll
C:\ASPerl\bin\perl.exe -MExtUtils::Command -e cp Ingres.bs
blib\arch\auto\DBD\Ingres\Ingres.bs
C:\ASPerl\bin\perl.exe -MExtUtils::Command -e chmod 644
blib\arch\auto\DBD\Ingres\Ingres.bs

set DBI_DBNAME=iidbdb
nmake test

C:\ASPerl\bin\perl.exe "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib\lib', 'blib\arch')" t\datatypes.t t\dbi.t
t\event.t t\exec.t
t\datatypes....ok
t\dbi..........ok
t\event........ok
t\exec.........skipped
all skipped: no reason given
All tests successful, 1 test skipped.
Files=4, Tests=364, 13 wallclock secs ( 0.00 cusr + 0.00 csys = 0.00
CPU)

nmake install

Installing C:\ASPerl\site\lib\auto\DBD\Ingres\Ingres.dll
Installing C:\ASPerl\site\lib\auto\DBD\Ingres\Ingres.exp
Installing C:\ASPerl\site\lib\auto\DBD\Ingres\Ingres.lib
Installing C:\ASPerl\site\lib\auto\DBD\Ingres\Ingres.pdb
Files found in blib\arch: installing files in blib\lib into architecture
dependent library tree
Appending installation info to C:\ASPerl\lib/perllocal.pod


_______________________________________________
Info-ingres mailing list
Info-ingres (AT) cariboulake (DOT) com
http://mailman.cariboulake.com/mailm...py/info-ingres

_______________________________________________
Info-ingres mailing list
Info-ingres (AT) cariboulake (DOT) com
http://mailman.cariboulake.com/mailm...py/info-ingres


Reply With Quote
  #7  
Old   
Roger Hill
 
Posts: n/a

Default Re: [Info-ingres] Building DBD::Ingres for ActiveState Perl - 08-05-2005 , 01:07 AM



HI Grant, Sisyphus and all others:

BINGO!

Ok got it done and working.


Afetr an abortive attempt to use MinGW and Msys, which probably failed
because I did not know what I was doing, I ended up downloading:

- nmake from
http://download.microsoft.com/downlo...us/nmake15.exe
(so I had a make)

- the C++ compiler from http://msdn.microsoft.com/visualc/vctoolkit2003/
(this gave me the cl compiler)

- the microsoft platform SDK for windows server 2003 (that might have
been the wrong thing, in hindsight) from
http://www.microsoft.com/downloads/d...displaylang=en
(This gave me all the needed libs except for msvcrt.lib for 32 bit)

- the .NET Framework redistributable package from
http://msdn.microsoft.com/netframewo...work1_1redist/

- the .NET FRamework SDK 1.1 from a link off the previous page
(Which gave me the 32 bit msvcsrt.lib)
Then:

Copy the vcvars32.bat script from the C++ distribution to the
DBD::Ingres directory (just to make it easier to run), and the
msvcrt.lib library from the .NET distribution to the lib directory of
the Platform SDK distribution (to save messing with paths).

So, Crank up the Platform SDK command line environment - RETAIL (vs DEBUG).
Go to the DBD folder
Run vcvars32.bat (adds in the PATHS for cl etc)

Bog standard install from there. No changes to Makefile.pl.
- perl Makefile.pl
- nmake
- set DBI_DBNAME=testdb
- nmake test
- nmake install


The one thing I now need to do is work out what the minimal set of all
the above is...I suspect I could get away with nmake, the C++ compiler,
and copying all the libs somewhere into the C++ compiler hierarchy, to
make a minimal install environment, but I need to try that. (Ideas and
comments on that idea welcomed).

This was painful - anyone got a better strategy?

Dump of the install process below.

Thanks to all who helped...hope this tale will help others.

Roger

C:\Data\Downloads\DBD-Ingres-0.51>perl makefile.pl

Configuring DBD::Ingres ...

Try 'perl Makefile.PL -v'
if you have any problems.


Using Ingres in C:\Program Files\CA\Ingres [II]

Writing Makefile for DBD::Ingres

C:\Data\Downloads\DBD-Ingres-0.51>nmake

Microsoft (R) Program Maintenance Utility Version 7.00.8882
Copyright (C) Microsoft Corp 1988-2000. All rights reserved.

cl -c -IC:\Perl\site\lib/auto/DBI -nologo -Gf -W3 -MD -Zi
-DNDEBUG -O1
-DWIN32 -D_CONSOLE -DNO_STRICT -DHAVE_DES_FCRYPT
-DBUILT_BY_ACTIVESTATE -DNO_HA
SH_SEED -DUSE_SITECUSTOMIZE -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS
-DUSE_PE
RLIO -DPERL_MSVCRT_READFIX -g -DVERSION=\"0.51\"
-DXS_VERSION=\"0.51\" "-IC
:\Perl\lib\CORE" Ingres.c
cl : Command line warning D4002 : ignoring unknown option '-g'
Ingres.c
c1 : warning C4349: /Gf is deprecated and will not be supported in
future versio
ns of Visual C++; remove /Gf or use /GF instead
Ingres.xs(30) : warning C4013: 'dbd_db_do' undefined; assuming extern
returning
int
cl -c -IC:\Perl\site\lib/auto/DBI -nologo -Gf -W3 -MD -Zi
-DNDEBUG -O1
-DWIN32 -D_CONSOLE -DNO_STRICT -DHAVE_DES_FCRYPT
-DBUILT_BY_ACTIVESTATE -DNO_HA
SH_SEED -DUSE_SITECUSTOMIZE -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS
-DUSE_PE
RLIO -DPERL_MSVCRT_READFIX -g -DVERSION=\"0.51\"
-DXS_VERSION=\"0.51\" "-IC
:\Perl\lib\CORE" dbdimp.c
cl : Command line warning D4002 : ignoring unknown option '-g'
dbdimp.c
c1 : warning C4349: /Gf is deprecated and will not be supported in
future versio
ns of Visual C++; remove /Gf or use /GF instead
dbdimp.sc(583) : warning C4101: 'i' : unreferenced local variable
dbdimp.sc(769) : warning C4018: '>' : signed/unsigned mismatch
dbdimp.sc(1315) : warning C4101: 'ch' : unreferenced local variable
Running Mkbootstrap for DBD::Ingres ()
C:\Perl\bin\perl.exe -MExtUtils::Command -e chmod 644 Ingres.bs
link -out:blib\arch\auto\DBD\Ingres\Ingres.dll -dll -nologo
-nodefaultli
b -debug -opt:ref,icf -libpath:"C:\Perl\lib\CORE" -machine:x86
Ingres.obj dbdi
mp.obj libingres.lib shell32.lib msvcrt.lib libc.lib kernel32.lib
user32.lib mpr
..lib advapi32.lib netapi32.lib libcmt.lib C:\Perl\lib\CORE\perl58.lib
"C:\Prog
ram Files\CA\Ingres [II]\ingres\lib\libingres.lib" "C:\Program
Files\Microsoft P
latform SDK\Lib\shell32.lib" "C:\Program Files\Microsoft Platform
SDK\Lib\msvcrt
..lib" "C:\Program Files\Microsoft Visual C++ Toolkit 2003\lib\libc.lib"
"C:\Prog
ram Files\Microsoft Visual C++ Toolkit 2003\lib\kernel32.lib"
"C:\Program Files\
Microsoft Platform SDK\Lib\user32.lib" "C:\Program Files\Microsoft
Platform SDK\
Lib\mpr.lib" "C:\Program Files\Microsoft Platform SDK\Lib\advapi32.lib"
"C:\Prog
ram Files\Microsoft Platform SDK\Lib\netapi32.lib" "C:\Program
Files\Microsoft V
isual C++ Toolkit 2003\lib\libcmt.lib" "C:\Program Files\Microsoft
Visual C++ To
olkit 2003\lib\oldnames.lib" "C:\Program Files\Microsoft Visual C++
Toolkit 2003
\lib\kernel32.lib" "C:\Program Files\Microsoft Platform
SDK\Lib\user32.lib" "C:\
Program Files\Microsoft Platform SDK\Lib\gdi32.lib" "C:\Program
Files\Microsoft
Platform SDK\Lib\winspool.lib" "C:\Program Files\Microsoft Platform
SDK\Lib\comd
lg32.lib" "C:\Program Files\Microsoft Platform SDK\Lib\advapi32.lib"
"C:\Program
Files\Microsoft Platform SDK\Lib\shell32.lib" "C:\Program
Files\Microsoft Platf
orm SDK\Lib\ole32.lib" "C:\Program Files\Microsoft Platform
SDK\Lib\oleaut32.lib
" "C:\Program Files\Microsoft Platform SDK\Lib\netapi32.lib" "C:\Program
Files\M
icrosoft Platform SDK\Lib\uuid.lib" "C:\Program Files\Microsoft Platform
SDK\Lib
\ws2_32.lib" "C:\Program Files\Microsoft Platform SDK\Lib\mpr.lib"
"C:\Program F
iles\Microsoft Platform SDK\Lib\winmm.lib" "C:\Program Files\Microsoft
Platform
SDK\Lib\version.lib" "C:\Program Files\Microsoft Platform
SDK\Lib\odbc32.lib" "C
:\Program Files\Microsoft Platform SDK\Lib\odbccp32.lib" "C:\Program
Files\Micro
soft Platform SDK\Lib\msvcrt.lib" -def:Ingres.def
Creating library blib\arch\auto\DBD\Ingres\Ingres.lib and object
blib\arch\au
to\DBD\Ingres\Ingres.exp
C:\Perl\bin\perl.exe -MExtUtils::Command -e chmod 755
blib\arch\auto\DBD
\Ingres\Ingres.dll
C:\Perl\bin\perl.exe -MExtUtils::Command -e cp Ingres.bs
blib\arch\auto\
DBD\Ingres\Ingres.bs
C:\Perl\bin\perl.exe -MExtUtils::Command -e chmod 644
blib\arch\auto\DBD
\Ingres\Ingres.bs

C:\Data\Downloads\DBD-Ingres-0.51>DBI_DSN=testdb nmake test
'DBI_DSN' is not recognized as an internal or external command,
operable program or batch file.

C:\Data\Downloads\DBD-Ingres-0.51>set DBI_DBNAME=testdb

C:\Data\Downloads\DBD-Ingres-0.51>nmake test

Microsoft (R) Program Maintenance Utility Version 7.00.8882
Copyright (C) Microsoft Corp 1988-2000. All rights reserved.

C:\Perl\bin\perl.exe "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'bl
ib\lib', 'blib\arch')" t\datatypes.t t\dbi.t t\event.t t\exec.t
t\datatypes....ok
t\dbi..........ok
t\event........ok
t\exec.........skipped
all skipped: no reason given
All tests successful, 1 test skipped.
Files=4, Tests=364, 18 wallclock secs ( 0.00 cusr + 0.00 csys = 0.00 CPU)

C:\Data\Downloads\DBD-Ingres-0.51>nmake install

Microsoft (R) Program Maintenance Utility Version 7.00.8882
Copyright (C) Microsoft Corp 1988-2000. All rights reserved.

Installing C:\Perl\site\lib\auto\DBD\Ingres\Ingres.dll
Installing C:\Perl\site\lib\auto\DBD\Ingres\Ingres.exp
Installing C:\Perl\site\lib\auto\DBD\Ingres\Ingres.lib
Installing C:\Perl\site\lib\auto\DBD\Ingres\Ingres.pdb
Files found in blib\arch: installing files in blib\lib into architecture
depende
nt library tree
Appending installation info to C:\Perl\lib/perllocal.pod

C:\Data\Downloads\DBD-Ingres-0.51>
End Dump-----------------------------

Quote:
Roger Hill <rhill (AT) hillconsult (DOT) com> writes:


The question is - has anyone got DBD::Ingres working on Windows with
Active State Perl? If so, pointers would be appreciated.

Please - to me also!



It is possible to build the DBI using Active State's perl - however I
have only done it with Microsoft's Visual C++ compiler. If you don't
have the compiler you can download it from
http://msdn.microsoft.com/visualc/vctoolkit2003/. Note this is just the
command line stuff no pretty gui for debugging.

After testing and installing DBI I did the following within the
DBD::Ingres source area:

- set LIB to include %II_SYSTEM%\ingres\lib otherwise the next step
fails to find libingres.lib
- perl Makefile.pl
- nmake
- set DBI_DBNAME=iidbdb
- nmake test
- nmake install

Output posted below:

perl Makefile.pl

Configuring DBD::Ingres ...

Try 'perl Makefile.PL -v'
if you have any problems.


Using Ingres in C:\IngresGC

Checking if your kit is complete...
Looks good
Writing Makefile for DBD::Ingres

nmake

cp Ingres.pm blib\lib\DBD\Ingres.pm
cp ingtest.pl blib\lib\DBD\ingtest.pl
cp ingperl.pl blib\lib/ingperl.pl
cp Ingperl.pm blib\lib/Ingperl.pm
C:\ASPerl\bin\perl.exe -p -e "s!/\*64\*!!" dbdimp.psc
dbdimp.sc
C:\IngresGC\ingres\bin\esqlc.exe -o.h -w -p dbdimp.sc
ESQL dbdimp.sc:
C:\ASPerl\bin\perl.exe -p -e "s/~DRIVER~/Ingres/g"
C:\ASPerl\site\lib/auto/DBI/Driver.xst >Ingres.xsi
C:\ASPerl\bin\perl.exe C:\ASPerl\lib\ExtUtils/xsubpp -typemap
C:\ASPerl\lib\ExtUtils\typemap Ingres.xs > Ingres.xsc &&
C:\ASPerl\bin\perl.exe -MExtUtils::Command -e mv Ingres.xsc Ingres.c
cl -c -IC:\ASPerl\site\lib/auto/DBI -nologo -Gf -W3 -MD -Zi
-DNDEBUG -O1 -DWIN32 -D_CONSOLE -DNO_STRICT -DHAVE_DES_FCRYPT
-DBUILT_BY_ACTIVESTATE -DNO_HASH_SEED -DUSE_SITECUSTOMIZE
-DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -DUSE_PERLIO
-DPERL_MSVCRT_READFIX -g -DVERSION=\"0.51\" -DXS_VERSION=\"0.51\"
"-IC:\ASPerl\lib\CORE" Ingres.c
Ingres.c
c1 : warning C4349: /Gf is deprecated and will not be supported in
future versions of Visual C++; remove /Gf or use /GF instead
Ingres.xs(30) : warning C4013: 'dbd_db_do' undefined; assuming extern
returning int
C:\IngresGC\ingres\bin\esqlc.exe -o.h -w -p dbdimp.sc
ESQL dbdimp.sc:
cl -c -IC:\ASPerl\site\lib/auto/DBI -nologo -Gf -W3 -MD -Zi
-DNDEBUG -O1 -DWIN32 -D_CONSOLE -DNO_STRICT -DHAVE_DES_FCRYPT
-DBUILT_BY_ACTIVESTATE -DNO_HASH_SEED -DUSE_SITECUSTOMIZE
-DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -DUSE_PERLIO
-DPERL_MSVCRT_READFIX -g -DVERSION=\"0.51\" -DXS_VERSION=\"0.51\"
"-IC:\ASPerl\lib\CORE" dbdimp.c
dbdimp.c
c1 : warning C4349: /Gf is deprecated and will not be supported in
future versions of Visual C++; remove /Gf or use /GF instead
dbdimp.sc(583) : warning C4101: 'i' : unreferenced local variable
dbdimp.sc(769) : warning C4018: '>' : signed/unsigned mismatch
dbdimp.sc(1315) : warning C4101: 'ch' : unreferenced local variable
Running Mkbootstrap for DBD::Ingres ()
C:\ASPerl\bin\perl.exe -MExtUtils::Command -e chmod 644
Ingres.bs
C:\ASPerl\bin\perl.exe -MExtUtils::Mksymlists -e
"Mksymlists('NAME'=>\"DBD::Ingres\", 'DLBASE' => 'Ingres', 'DL_FUNCS' =
{ }, 'FUNCLIST' => [], 'IMPORTS' => { }, 'DL_VARS' => []);"
link -out:blib\arch\auto\DBD\Ingres\Ingres.dll -dll -nologo
-nodefaultlib -debug -opt:ref,icf -libpath:"C:\ASPerl\lib\CORE"
-machine:x86 Ingres.obj dbdimp.obj libingres.lib shell32.lib msvcrt.lib
libc.lib kernel32.lib user32.lib mpr.lib advapi32.lib netapi32.lib
libcmt.lib C:\ASPerl\lib\CORE\perl58.lib
C:\IngresGC\ingres\lib\libingres.lib "C:\Program Files\Microsoft Visual
Studio .NET 2003\VC7\PlatformSDK\lib\shell32.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\LIB\msvcrt.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\LIB\libc.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\LIB\kernel32.lib"
"C:\Program Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\user32.lib" "C:\Program Files\Microsoft Visual
Studio .NET 2003\VC7\PlatformSDK\lib\mpr.lib" "C:\Program
Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\advapi32.lib" "C:\Program Files\Microsoft
Visual Studio .NET 2003\VC7\PlatformSDK\lib\netapi32.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\LIB\libcmt.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\LIB\oldnames.lib"
"C:\Program Files\Microsoft Visual Studio .NET
2003\VC7\LIB\kernel32.lib" "C:\Program Files\Microsoft Visual Studio
.NET 2003\VC7\PlatformSDK\lib\user32.lib" "C:\Program Files\Microsoft
Visual Studio .NET 2003\VC7\PlatformSDK\lib\gdi32.lib" "C:\Program
Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\winspool.lib" "C:\Program Files\Microsoft
Visual Studio .NET 2003\VC7\PlatformSDK\lib\comdlg32.lib" "C:\Program
Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\advapi32.lib" "C:\Program Files\Microsoft
Visual Studio .NET 2003\VC7\PlatformSDK\lib\shell32.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\PlatformSDK\lib\ole32.lib"
"C:\Program Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\oleaut32.lib" "C:\Program Files\Microsoft
Visual Studio .NET 2003\VC7\PlatformSDK\lib\netapi32.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\PlatformSDK\lib\uuid.lib"
"C:\Program Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\ws2_32.lib" "C:\Program Files\Microsoft Visual
Studio .NET 2003\VC7\PlatformSDK\lib\mpr.lib" "C:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\PlatformSDK\lib\winmm.lib"
"C:\Program Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\version.lib" "C:\Program Files\Microsoft Visual
Studio .NET 2003\VC7\PlatformSDK\lib\odbc32.lib" "C:\Program
Files\Microsoft Visual Studio .NET
2003\VC7\PlatformSDK\lib\odbccp32.lib" "C:\Program Files\Microsoft
Visual Studio .NET 2003\VC7\LIB\msvcrt.lib" -def:Ingres.def
Creating library blib\arch\auto\DBD\Ingres\Ingres.lib and object
blib\arch\auto\DBD\Ingres\Ingres.exp
C:\ASPerl\bin\perl.exe -MExtUtils::Command -e chmod 755
blib\arch\auto\DBD\Ingres\Ingres.dll
C:\ASPerl\bin\perl.exe -MExtUtils::Command -e cp Ingres.bs
blib\arch\auto\DBD\Ingres\Ingres.bs
C:\ASPerl\bin\perl.exe -MExtUtils::Command -e chmod 644
blib\arch\auto\DBD\Ingres\Ingres.bs

set DBI_DBNAME=iidbdb
nmake test

C:\ASPerl\bin\perl.exe "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib\lib', 'blib\arch')" t\datatypes.t t\dbi.t
t\event.t t\exec.t
t\datatypes....ok
t\dbi..........ok
t\event........ok
t\exec.........skipped
all skipped: no reason given
All tests successful, 1 test skipped.
Files=4, Tests=364, 13 wallclock secs ( 0.00 cusr + 0.00 csys = 0.00
CPU)

nmake install

Installing C:\ASPerl\site\lib\auto\DBD\Ingres\Ingres.dll
Installing C:\ASPerl\site\lib\auto\DBD\Ingres\Ingres.exp
Installing C:\ASPerl\site\lib\auto\DBD\Ingres\Ingres.lib
Installing C:\ASPerl\site\lib\auto\DBD\Ingres\Ingres.pdb
Files found in blib\arch: installing files in blib\lib into architecture
dependent library tree
Appending installation info to C:\ASPerl\lib/perllocal.pod


_______________________________________________
Info-ingres mailing list
Info-ingres (AT) cariboulake (DOT) com
http://mailman.cariboulake.com/mailm...py/info-ingres


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.