[Opensim-dev] Opensim 0.7 tidying up the MySQL DB connection string

[Frank Nichols]

Alex Ra,

Agreed you "should" be able to use the connection string - however all
attempts to do that have failed. I did read some discussion about that in a
.net support forum and the conclusion was that it was by design that you
could not override the default command timeout using the connection string
argument. I am not a mysql person, so, I would be very happy to be wrong on
this - if someone can test it and show how to make the connection string
change work. Nebadon and I failed in several days of testing.

On Fri, Jun 18, 2010 at 11:45 AM, Alex Ra <info at adeptsql.com> wrote:

> FN> The use of the MysqlScript class is at the heart of most of the
> FN> problems I have seen with the migration of mysql databases from
> FN> 0.6.9 to 0.7.0. The problem seems to be that the default command
> FN> timeout value for processing a sql statement with this class is 30
>
> Hello Frank,
>
> You should be able to control the command timeout from the connection
> string:
>
> "Server=myServerAddress;Database=...;Default Command Timeout=20000;"
>
>
>
> Best regards,
>
> Alex
>
> _______________________________________________
> 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/20100618/0578f204/attachment-0001.html>