Urgent : please ! Acces to a distant Mysql Database ?

[fakher]

Hello everybody,
I'm asking myself about how to access to a distant mysql database.I dont really understand samples where you find something like that using namefile.db :

Code: Select all

//Session ses(SessionFactory::instance().create(connector, [b]connectionString[/b]));
Session ses("SQLite", "dummy.db");


I need to know how and where i should put database' parameters like : password, user,database name etc.. Should they be put in the connectionString variable ? if yes, how please ?
Should I use something else than Session object ? Thank you, I need an example please ..

fakher,

[guenter]

You specify a connection string, like this:

Code: Select all

Poco::Data::MySQL::Connector::registerConnector();
Poco::Data::Session sess("MySQL", "user=joe;password=s3cr3t;db=mydatabase;compress=true;auto-reconnect=true");


[fakher]

Thank you, but how do you specify the host parameter in this string ?

[guenter]

"host=localhost;user=joe;password=s3cr3t;db=mydatabase;compress=true;auto-reconnect=true"