[mapguide-users] AutoDesk Oracle Driver and NLS Variables

[Gordon Luckett]

The Autodesk Driver for oracle is not tested with mgos 4.  If possible, try
the same query, with the FDO, using AutoCAD Map where the FDO driver was
originally installed. This will rule out if the issue is with the mgos/adsk
FDO driver first

If it is repeatable in AutoCAD Map,  then I would recommend submitting a
bug to Autodesk directly.



On Fri, 8 Mar 2024, 06:08 David Bowen via mapguide-users, <
mapguide-users at lists.osgeo.org> wrote:

> We're testing using the AutoDesk Oracle driver in MGOS Beta 1, running on
> Apache on Windows Server 2022 Standard, and are encountering an issue when
> we select an object to query against the database (Oracle 19).
> Instead of returning results, that are being returned when using the
> Oracle SLKING driver, we're getting an error message (image 1).
>
> Image 1:
> [image: image.png]
>
> The relevant section of code is as follows:
>
>     function _setEnvironment() {
>         ////  Set Oracle NLS variables
>         $NLS_ENV = "ALTER SESSION SET NLS_NUMERIC_CHARACTERS='.,'";
>         $set = $this->db_app->simple_query( $NLS_ENV );
>         $NLS_ENV = "ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD'";
>         $set = $this->db_app->simple_query( $NLS_ENV );
>     }
>
> It fails when attempting to run the first simple_query, and I presume it
> will fail when attempting to run the second simple_query. Has anyone
> encountered this or are using the AutoDesk Oracle driver where the NLS
> variables are being set?
>
> Thanks,
> David
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapguide-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapguide-users/attachments/20240308/bda2c1a1/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 12266 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/mapguide-users/attachments/20240308/bda2c1a1/attachment.png>