Dizkus

Anybody can show me how to connect to multi databases in PostNuke?
Here's the code in config.php, which is connect to ueweb. If I have another databases to connect, where must I put the configuration?
$pnconfig['dbtype'] = 'mysql';
$pnconfig['dbtabletype'] = 'myisam';
$pnconfig['dbhost'] = '192.168.0.48';
$pnconfig['dbuname'] = 'xxxxxxxx';
$pnconfig['dbpass'] = 'xxxxxxx';
$pnconfig['dbname'] = 'ueweb';
$pnconfig['system'] = '0';
$pnconfig['prefix'] = 'PN';
$pnconfig['encoded'] = '1';
$pnconfig['pconnect'] = '0';
$pnconfig['temp'] = 'pnTemp';

Another question is, is it possible to connect to ms. SQL using PostNuke?

Do you need PostNuke to actually use that database? Of is there another external script / program?

Because at this moment only one DB connection is possible (in .8 will be multiple IIRC), and if you need an external script to use another database, you could just make a new DB connection in a separate PHP file and include that file in your own external scripts / modules.

MsSQL not yet possible untill .8

--
-- Teb
-- Dutch PostNuke Community

Support questions in a Personal Message will be ignored. Use the forums at all times!

Hi Teb, thanks for replying.
I have an external script to plug into PostNuke. Another modules but using PostNuke engine.
In this script I need to call another database, can u show me in what file I need to add and what script I need to create? I am worry to mess up original PostNuke engine since I am a newbie. Thanks for your help :)

Like I said, you can't change anything in the PostNuke files for that.

Look at http://community.postnuke.com/module-Forum-viewtopic-topic-51466-start-0.htm#pid219887 and you'll find a way to include a page / script / file integrated in PostNuke. In that file you can connect to your custom script, and have the output generated within PostNuke.

That's the only thing I can think of, it's all a bit abstract and what you're asking is not possible by defaut.

--
-- Teb
-- Dutch PostNuke Community

Support questions in a Personal Message will be ignored. Use the forums at all times!