# after switchServer() wrong Data

**URL:** <https://forum.servoy.com/t/after-switchserver-wrong-data/12823>\
**Category:** Classic Servoy\
**Created:** [September 7, 2010, 3:55pm UTC](https://forum.servoy.com/t/after-switchserver-wrong-data/12823 "2010-09-07T15:55:12Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![stefanoni](https://avatars.discourse-cdn.com/v4/letter/s/bb73d2/32.png) [@stefanoni](https://forum.servoy.com/u/stefanoni)\
**Post date:** [September 7, 2010, 3:55pm UTC](https://forum.servoy.com/t/after-switchserver-wrong-data/12823/1 "2010-09-07T15:55:12Z")

</div>

If I switchServer() between

**local mySql** to **www mySql** it works fine  
**www mySql** to **local mySql** it works fine

**local mySql** to **local Postgre** it works fine  
**local Postgre** to **local mySql** it works fine

**www mySql** to **local Postgre** it doesent refresh the foundset with the data from **local Postgre**

even if I use databaseManager.refreshRecordFromDatabase(currentcontroller.getDataSource(),-1) after  
the switchServer()

Do i have a possibility to realy disconnet and connect again to be sure to see the right data (something that  
works in this situation more proper then refreshRecordFromDatabase )?

Thanke you for any ideas

---

<div class="post-metadata">

**Author:** ![rgansevles](https://avatars.discourse-cdn.com/v4/letter/r/3d9bf3/32.png) [@rgansevles](https://forum.servoy.com/u/rgansevles)\
**Post date:** [September 8, 2010, 7:09pm UTC](https://forum.servoy.com/t/after-switchserver-wrong-data/12823/2 "2010-09-08T19:09:14Z")

</div>

Alessandro,

I am not sure if switch-server across different db vendors will always work.  
Are there any errors in the logs?

Rob

---

<div class="post-metadata">

**Author:** ![stefanoni](https://avatars.discourse-cdn.com/v4/letter/s/bb73d2/32.png) [@stefanoni](https://forum.servoy.com/u/stefanoni)\
**Post date:** [September 9, 2010, 6:38am UTC](https://forum.servoy.com/t/after-switchserver-wrong-data/12823/3 "2010-09-09T06:38:33Z")

</div>

> rgansevles:  
> Alessandro,  
> Are there any errors in the logs?  
> Rob

If you mean **C:\Servoy\application\_server\servoy\_log.txt**  
there are no errors.

---

<div class="post-metadata">

**Author:** ![rgansevles](https://avatars.discourse-cdn.com/v4/letter/r/3d9bf3/32.png) [@rgansevles](https://forum.servoy.com/u/rgansevles)\
**Post date:** [September 10, 2010, 7:59am UTC](https://forum.servoy.com/t/after-switchserver-wrong-data/12823/4 "2010-09-10T07:59:31Z")

</div>

Alessandro,

Please create a sample solution and file a case in our support system so we can investigate.

[http://www.servoy.com/s](http://www.servoy.com/s)

Rob

---

<div class="post-metadata">

**Author:** ![stefanoni](https://avatars.discourse-cdn.com/v4/letter/s/bb73d2/32.png) [@stefanoni](https://forum.servoy.com/u/stefanoni)\
**Post date:** [September 15, 2010, 8:07am UTC](https://forum.servoy.com/t/after-switchserver-wrong-data/12823/5 "2010-09-15T08:07:28Z")

</div>

Ok, thanke you. I’l try, but mybe i’t not so easy without the similar connections to my databasesservers on the webhosts and localhost  
Regards