Page 1 of 1

Node content from MySQL query

Posted: 27 Feb 2012, 12:51
by 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

Re: Node content from MySQL query

Posted: 27 Feb 2012, 13:29
by ErikB
peterbanik wrote: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!

Re: Node content from MySQL query

Posted: 27 Feb 2012, 14:25
by peterbanik
Thanks for the hint Erik.

Peter

Re: Node content from MySQL query

Posted: 25 Mar 2013, 16:23
by 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