So, finally I got fed up with working from a 32 bit XP virtual machine and spent a little more time on this issue.  I’ve managed to get my Vista Ultimate a la x64 mostly working.  Where I went wrong the last time (aside from trying to figure this out in the middle of the night in a shitty mood because I had spent so much time head banging with a wall) was using the 64 bit client. 

The correct path to Oracle happiness in my case was the 11g client.  It works great with my 10.2 server.  The important bit in was to use the 32 bit install rather than the 64 bit install.  One of my primary tools for accessing Oracle is Toad for Oracle 9.x.  Quest Software states that Toad for Oracle 9.6 is the first version to really support the 11g client.  However, it does NOT support the x64 client.

So the last time I tried to solve this, after a long day, and a fun night of head banging with a wall – when I tried the 11g client, I used x64 cbuild – and saw that Toad wouldn’t work, I threw a little hissyfit and went to bed.  Long story short, installing both the 32bit 11g client and 11g ODAC/ODP seems to have done the trick.  Now – there is one important little piece o’ information that you will need to know.  Though I have not confirmed this, I suspect that x64 applications will not be able to use the driver. 

That said, from a development point of view you will need to set IIS to run at 32 bit.  On IIS 5.x/6.x this is a server wide setting from a dos window:

   1: cscript %SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 1

   2: %SYSTEMROOT%\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i

If you’re running Vista or Server 2008 with IIS7, you have things a little better.  You can configure each application pool to run as 32 or 64 bit.  For winform development, change the compile properties of the project to set the target platform to be x86.

I’m really glad that’s over…but I still want a proper x64 ODAC.  Come on Oracle .. =)

Yay.  Autodesk today released an update for both the Mapguide Enterprise Web Tier, Server and Studio.  This release should catch Enterprise up a little more closely to the Open Source edition.  A PDF with containing some of the changes can be found here.  Check out the updates.  Some of these updates are pretty critical (ie. the FireFox 3 takes out your Mapguide server).  Looks like many performances updates have made it in also.

Thanks Autodesk! =)

ORA-13226: Interface not supported without a spatial index.

I hate that error.  Someone would give me a new Oracle dump file.  I’d try to view the spatial data and boom - ORA-13226.  If I was lucky, there was only a couple of tables in it.  Chances are, there were hundreds of tables in it.  Sometimes I’d need to add the reference to the USER_SDO_GEOM_METADATA view, sometimes I wouldn’t.   Sometimes the index would already exist and just need to be rebuilt.

Regardless of the scenario, it would often involve a lot of SQL – or messing around to try and remember the SQL.  Every time this would pop up I would think to myself, “I really should write an app…”.  Well I finally did.

So, here is my announcement.  The RADE Spatial Indexer is just about ready for beta.  Initially this app does three things.

• It will list tables and views with geometry columns that are not part of the USER_SDO_GEOM_META data view and help you add them.
• It will list spatial tables without indexes and help you create them.
• It will list spatial tables with indexes and help you re-index them.

No more exporting queries to text files and using a macro to edit them to build your SQL for rebuilding those indexes.  I’ve tried to add some nice friendly helpers, such as a button that will suggest the spatial metadata settings for a table based on the existing meta data records.  The ability to mass create or rebuild indexes is also been a fantastic helper.

I’m recruiting brave individuals for a small closed beta program that will begin in about two weeks.  If you are interested in being a tester please e-mail indexer (at) webrade.com and let me know.  Alternately you can contact me with the contact me link on the blog here  Remember, this is a beta – so I really do not suggest you run this on a production, or important server.  That said, I have been using it in various states on my own ‘production’ development Oracle server.

As an incentive for helping me out.  If you submit feedback (be it a bug report or feature request) – I will set you up with a free license once we release 1.0.  I know you’re hooked and want to sign up.  I know it.  Just in case you need a little more, here is a few screen caps..

Look at how easy it could be to define metadata.  Click the suggest button and it will iterate through the metadata settings for other spatial tables in the schema.  Once you have one row defined, use the sync button to set all rows to the same values.  Click process and its done.

Within seconds, have hundreds of spatial indexes being re-created…Creating new indexes is almost as easy.

I have enough junk running on my development machine.  In an effort to try and keep my workstation speedy - I don't install any unnecessary services (Oracle server, Mapguide Server etc) on this machine.  In a larger development environment, running multiple servers on local development machines has a few other less than desirable results.  For example licensing issues and costs could increase, data management can become more complex, and just managing the extra services on N machines could cause a lot more work for your already overworked IT guy.

So instead I have centralized my server resources into a nice VM setup running on my beefy Dell server.  Now, regardless of which machine I use to develop I can still access the same data sets.  This is especially nice when traveling.  Specifically Mapguide Server and web tier are installed on my development web server.  When coding, I will either use my local IIS or the built in Visual Studio web server.  This poses one problem when working with Mapguide.  Referencing the web tier on the shared server from another web server will result in cross site scripting (XSS) errors.  Basically, javascript on one web server cannot access javascript code on another web server, which under most circumstances is a good thing.  When trying to develop using the Mapguide Web API on a central Mapguide server this poses a problem as the web tier API is wholly contained within the virtual directory on another server.  Gotta love when 'security' jumps up bites us in the behind.

The simple solution to this problem is to install the Mapguide web tier on every development machine.  This will require that each development machine have a web server installed, but chances are that is already the case.  When installing the web tier be sure to have the IP address of the Mapguide server handy as it will needed during the install.  Once the web tier is running locally, reference the local web tier in your URLs and the cross site scripting vulnerabilities go away!  If you're running the 64 Bit version of Vista on your development machine, check out my post installing the web tier on Vista x64

Over the years, this problem has sporadically appeared (probably once or twice a year).  In the Mapguide 6.5 server admin when creating a new data source the Autodesk Spatial Data Provider for Oracle Spatial doesn't appear as an option.  Every time this comes up I end up wracking my brain to remember what the solution is.  I know I've dealt with this many times - but I cannot remember the details.  Usually it's occurring on a customer's production server which is not a place I like to mess around.  This time, it was my development server - let the messing around begin!

In a nutshell this is a result of installing Mapguide server before the Oracle client is installed on the server.  The solution is to do a repair install of Mapguide Server (or a re-install if you prefer) once the Oracle client is installed.  Hopefully next year when this comes up again - writing this down will help me remember.  Worst case Google might pick this up and I'll find my own post when I search for it...