Help needed with compiling postgre sql with mapserver

Fri May 26 13:00:17 EDT 2006

Hi fleuren, thanks for all your help. I am able to solve the problem now, the lib or include paths are not the problem as they were already set in the environment variables on my machine. What i did was since i got an error with "shgetfolderpath" i saw that this function was being called in "fe-connect.c" but the relavant .h file was not included in this c file which is beyond my imagination. So i included the "shfolder.h" file which was in the MS platform sdk include folder and recompiled and it worked perfectly with no errors.

  I really appreciate your help and thanks ...

  Thanks for all you guys who helped me with this problem ....

  kris

Huub Fleuren <hfl at home.nl> wrote:
  Hi Kris.

Well, in my situation it still goes oke. we need : latest postgres 
Windows source, latest platform SDK, visualC servicepack 4.
try a reinstall of vc and sdk

here's what happens on my machine

E:\projects\postgresql-8.1.3\src>cl
'cl' is not recognized as an internal or external command, operable 
program or batch file.

E:\projects\postgresql-8.1.3\src>set include
Environment variable include not defined

E:\projects\postgresql-8.1.3\src>set lib
Environment variable lib not defined

so begin.

E:\projects\postgresql-8.1.3\src>vcvars32

E:\projects\postgresql-8.1.3\src>path
PATH=f:\PROGRA~1\MICROS~2\Common\msdev98\BIN;
F:\PROGRA~1\MICROS~2\VC98\BIN;
f:\PROGRA~1\MICROS~2\Common\TOOLS\WINNT;
f:\PROGRA~1\MICROS~2\Common\TOOLS;
C:\WINNT\system32;
C:\WINNT;C:\WINNT\System32\Wbem;
d:\myutilsandcopiedbatchfiles;

E:\projects\postgresql-8.1.3\src>set lib
LIB=F:\PROGRA~1\MICROS~2\VC98\LIB;F:\PROGRA~1\MICROS~2\VC98\MFC\LIB;

E:\projects\postgresql-8.1.3\src>set include
INCLUDE=F:\PROGRA~1\MICROS~2\VC98\ATL\INCLUDE;F:\PROGRA~1\MICROS~2\VC98\INCLUDE;F:\PROGRA~1\MICROS~2
\VC98\MFC\INCLUDE;

E:\projects\postgresql-8.1.3\src>setenv

Attempting to detect a Microsoft Visual Studio installation

Targeting Windows XP 32 DEBUG

E:\projects\postgresql-8.1.3\src>set lib
LIB=F:\Program Files\Microsoft Platform SDK for Windows Server 2003 
R2\Lib;F:\PR
OGRA~1\MICROS~2\VC98\LIB;F:\PROGRA~1\MICROS~2\VC98\MFC\LIB;

E:\projects\postgresql-8.1.3\src>set include
INCLUDE=F:\Program Files\Microsoft Platform SDK for Windows Server 2003 
R2\Inclu
de;F:\PROGRA~1\MICROS~2\VC98\ATL\INCLUDE;F:\PROGRA~1\MICROS~2\VC98\INCLUDE;F:\PR
OGRA~1\MICROS~2\VC98\MFC\INCLUDE;

E:\projects\postgresql-8.1.3\src>nmake /f win32.mak
rattle... rattle
(...)
All Win32 parts have been built!

it's not that we're supposed to understand why or how...

Regards, Huub.

rock well schreef:
> yes i did install the platform sdk and there is also an shfolder.lib 
> file in the sdk folder, though it gives me an error .....
> 
> Thanks for your reply .....
>
> */"Bart van den Eijnden (OSGIS)" /* wrote:
>
> Did you install the Platform SDK form Microsoft? See also:
>
> http://mapserver.gis.umn.edu/bugs/show_bug.cgi?id=1251
>
> Best regards,
> Bart
>
> rock well wrote: Hi fleuren the reason i dont want to use hobus
> mapserver is i guess it doesnt have the support for mrsid format and
> also sde libraries which i already have configured using the
> conventional mapserver. i was able to get rid of these error and was
> able to create the libpadll.lib but i wasnt able to create the
> libpq.dll
> file as it gave me the following error
>
> >
> > libpq.lib(fe-connect.obj) : error LNK2001: unresolved external
> symbol
> > _SHGetFolderpath
> > .\Release\libpq.dll : fatal error LNK1120: 1 unresolved externals
> >
> > and the execution stopped .....
> >
> > i guess someone might have encountered this problem, if so can you
> > give me some tips to solve it .....
> >
> > If you dont mind fleuren can you send me the libpq.dll as an
> > attachment as thats the only file i need to get going ....
> >
> > Thanks a lot for your help ....
> > kris
> >
> > */Huub Fleuren /* wrote:
> >
> > Hi Kris,
> >
> > I did feel lucky that the compile did not end with the word Stop.
> > I'm afraid experience problems like this now with the ECW library.
> >
> > Maybe try the very rich .\bin directory of
> >
> http://hobu.stat.iastate.edu/mapserver/build_output/mapserver-4.8.3-msvc71-build-kit.zip
> >
> >
> > this is a set for msvc7, so probably, issues on vc6
> >
> > Regards, Huub
> >
> >
> > rock well schreef:
> > > Thanks for your reply fleuren, yes i did the same way you told but
> > > still it give the following errors
> > >
> > > LINK : fatal error LNK1181: cannot open input file "shfolder.lib"
> > > NMAKE : fatal error U1077: 'link.exe' : return code '0x49d'
> > >
> > > Do you know why we get these errors, or else all we need is i
> guess
> > > the libpqdll.lib and some dlls right, if anything doesnt work
> > can you
> > > send me those dlls.
> > >
> > > Thanks verymuch for your help and time ...
> > > kris
> > >
> > > */Huub Fleuren /* wrote:
> > >
> > > Hi Rock,
> > >
> > > i recently compiled postgreql-8.1.3 with vc6sp4 and
> > > 5.2.3790.2075.51.PlatformSDK_Svr2003R2_rtm.img
> > > (install from virtual CD)
> > >
> > > first vcvars32
> > > then setenv
> > > then nmake /f win32.mak
> > >
> > > after a failure you always do nmake /f win32.mak clean
> > >
> > > Regards, Huub
> > >
> > > rock well schreef:
> > > > Hi all, i am trying to compile mapserver with postgre sql
> > > support. I
> > > > found this documentation in the mapserver website
> > > > http://mapserver.gis.umn.edu/docs/howto/win32_compiling
> > > >
> > > > I downloaded the MS platform sdk and installed it, when i try to
> > > run
> > > > the win32.mak file in the libpq directory it still says
> > > >
> > > > LINK : fatal error LNK1181: cannot open input file
> "shfolder.lib"
> > > >
> > > > the shfolder.lib does exist in the the default MS platform sdk
> > > folder,
> > > > do i have to change something or am i doing something wrong ...
> > > >
> > > > Thanks for your time ....
> > > > kris
> > > >
> > > >
> > >
> >
> ------------------------------------------------------------------------
> > > > Blab-away for as little as 1¢/min. Make PC-to-Phone Calls
> > > >
> > > > using Yahoo! Messenger with Voice.
> > >
> > >
> > >
> >
> ------------------------------------------------------------------------
> > > Love cheap thrills? Enjoy PC-to-Phone calls to 30+ countries
> > >
> > > for just 2¢/min with Yahoo! Messenger with Voice.
> >
> >
> > Ring'em or ping'em. Make PC-to-phone calls as low as 1¢/min
> >
> > with Yahoo! Messenger with Voice.
>
>
>
> -- 
> Bart van den Eijnden
> OSGIS, Open Source GIS
> http://www.osgis.nl
>
>
> ------------------------------------------------------------------------
> Do you Yahoo!?
> Everyone is raving about the all-new Yahoo! Mail Beta. 
> 

---------------------------------
Sneak preview the  all-new Yahoo.com. It's not radically different. Just radically better. 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20060526/2df12f9f/attachment.html