Tuesday, September 15, 2009

upgrade windows xp->2008 &oracle 9->10 (ms4w/gdal)

Today i performed an upgrade on a ms4w/chameleon app from win xp -> 2008 and oracle 9 -> 10 (non-spatial). I met the following difficulties:

Register apache as a service by rightclicking cmd and choose 'run as administrator', next type apache_install

Open up the firewall by running cmd as administrator and typing:
netsh firewall set portopening TCP 80 "Apache Web Server"

I couldn't get the instant oracle client working in combination with odbc, so in the end i installed the full oracle 10.2 client (error 126, could not load translation library)

Next ogrinfo didn't want to show my virtual odbc layer, it appears the table_name should be in capitals in Oracle 10, (ERROR 1: No column definitions found for table 'mpm_gisonline_mv', layer not usable. and Failed to find layer 'xxx' on datasource)

ogrinfo ODBC:user/pw@tns,XXXX (use table_name here to prevent that all tables are scanned at each request)

1 comment:

Anonymous said...
This comment has been removed by a blog administrator.