Node content from MySQL query

[peterbanik]

Hello all,

I am trying to pull content from a MySQL database in order to populate a text node. I've come across the below old post that has some examples but as these are from way back in 2005 the current Ventuz PLE can no longer open them. Is there perhaps an updated example on how to accomplish this?

http://forum-archive.ventuz.com/forums/ ... wPost.aspx

Any help/hints/pointers would be much appreciated.

Many thanks,

Peter

[ErikB]

Hello all,

I am trying to pull content from a MySQL database in order to populate a text node. I've come across the below old post that has some examples but as these are from way back in 2005 the current Ventuz PLE can no longer open them. Is there perhaps an updated example on how to accomplish this?

http://forum-archive.ventuz.com/forums/ ... wPost.aspx

Any help/hints/pointers would be much appreciated.

Many thanks,

Peter

Hover over the database node in the toolbox and press F1, then open the example scene!

[peterbanik]

Thanks for the hint Erik.

Peter

[Kobbi]

Hi Ventuz,
i'm not shure what is wrong but i'm unable to connect to my localhost MySQL database. I'm using DataBase node with Type value set to MySQL and connection string:
Server=127.0.0.1;Port=3307;Database=ventuztest;Uid=kobbi;Pwd=password;

The interactive example uses oleDB connection and its type of connection string.

I'm using V3 x86. The DB server is running and i have no problems to connect with db viewer. DataBase nod is connected to Query with simple sql command:
select * from vt1

Is there something wrong? Am I using not correct connection string?

Best regards,
Kobbi