[Opensim-dev] MSSQL runtime error in latest build..

[Ruud Lathrop]

Hi,

Check out the patch #2124 in Mantis. (
http://opensimulator.org/mantis/view.php?id=2124). A lot off problems are
solved in there. Also check out a function called "CreateParameter" in
MSSQLManager. Use this to create parameters for a SQLCommand, it does a
translation from OpenSim types to SQL types.

Met vriendelijke groet,
Ruud

On Wed, Sep 10, 2008 at 4:15 PM, Garrett Hussey <garrett.hussey at gmail.com>wrote:

> Hi, I found the cause of this problem
>
> Its in MSSQLRegionData.cs in LoadLandObjects
>
> cmdAccessList.Parameters.AddWithValue(
> "@LandUUID", landData.GlobalID);
>
> needs to be
>
> cmdAccessList.Parameters.AddWithValue(
> "@LandUUID", landData.GlobalID.ToString());
>
> 2008/9/10 Garrett Hussey <garrett.hussey at gmail.com>
>
>  Hi, has anyone come across an error when running up the latest
>> build of opensim against an sql server 2005 DB?
>>
>>   - the error I get is ...
>>
>> "No mapping exists from object type OpenMetaverse.UUID to a known managed
>> provider native type."
>>
>> It occurs when trying to select data from the DB and a parameter of type
>> OpenMetaVerse.UUID is
>> specified in the command. It looks like it cant figure out how to map the
>> string in the Db onto the UUID
>> struct. Is this a problem with OpenMetaverse or the MSSQL provider ??
>>
>> Cheers
>>     Garrett
>>
>
>
> _______________________________________________
> Opensim-dev mailing list
> Opensim-dev at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-dev
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-dev/attachments/20080912/a6a6da19/attachment-0001.html>