- Moderated by:
- Support
Postnuke with MsSQL
-
- rank:
-
Professional
- registered:
- January 2004
- Status:
- offline
- last visit:
- 22.03.06
- Posts:
- 958
Nope sorry. PostNuke only works with MySQL at the moment. You could try to use MSSQL but you would have to fix all the instances where PN uses MySQL specific SQL. :?
Just curious: why do you want to use MSSQL?
HTH
-
- rank:
-
Professional
- registered:
- January 2004
- Status:
- offline
- last visit:
- 22.03.06
- Posts:
- 958
Well the ADODB layer can handle MSSQL so you could do some custom connection from PN to the MSSQL database.
Maybe you could give some more details on what it is you're trying to do?
HTH
-
- rank:
-
Freshman
- registered:
- January 2006
- Status:
- offline
- last visit:
- 11.10.06
- Posts:
- 39
Thanks for your reply....
1. Is it possible to use PostNuke as an interface to insert/grab data from MsSQL
2. Can I install MySQL and MsSQL on the same server ( I know it sounds stupid but I'm really desperate)
Thanks in advance.
-
- rank:
-
Professional
- registered:
- January 2004
- Status:
- offline
- last visit:
- 22.03.06
- Posts:
- 958
To answer the last question first: I don't have any experience with it but I think you can.
If you want to use both MySQL and MsSQL from PostNuke you would have to create a module that uses it's own ADODB connection to retrieve data from the MSSQL DB.
It might be tricky but I think it is possible.
To get started on a module fast you should try the module generator on http://openstar.postnuke.com
HTH
-
- rank:
-
Steering Committee
- registered:
- December 2002
- Status:
- offline
- last visit:
- 02.12.08
- Posts:
- 13418
Quote
If you want to use both MySQL and MsSQL from PostNuke you would have to create a module that uses it's own ADODB connection to retrieve data from the MSSQL DB.
It might be tricky but I think it is possible.
It's possible, and easier than you realise.
The .8 codebase currently under development aims to be cross DB compatible, however we've only tested on MySQL and PostgreSQL at this stage. Additionally, the CVS is not stable and therefore should not be used on a production website. You're better off using an alternate integration method.
--
Regards,
Simon
itbegins.co.uk - Zikula Consulting
Please read the Support Guide
-
- rank:
-
Steering Committee
- registered:
- December 2002
- Status:
- offline
- last visit:
- 02.12.08
- Posts:
- 13418
Quote
Can you predict the release date for .8 ??
Nope, but what I can predict is that it won't be stable for a long time even if we release a Milestone release tomorrow (which won't happen anyway)
--
Regards,
Simon
itbegins.co.uk - Zikula Consulting
Please read the Support Guide
|
