Markus Lassfolk

Hi there,
Anyone who's got experience from converting InstantForum running on MSSQL to IPBoard (on MYSQL)?

I've tried myself with the MSSQL Driver for IPB 3.1.4 but not managed to get it right. It's complaining that some columns are nText and can't proceed.
Like this:

Error: 4004 - Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier.
IP Address: 127.0.0.1 - /admin/index.php?adsess=19475f8f5195c83c3bed9f2650c31ff1&app=convert&app=convert&module=board&section=instantforum&do=forum_perms&st=&cycle=100&total=6
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
MSSQL query error:
SELECT TOP 100 * FROM InstantForum_PermissionSets ORDER BY PermissionID ASC

I dont know enough about DB's to really know what to do about it. But with some googling I've managed to get around it by exporting the Table, editing the scriptfile and changed it to a NVARCHAR(MAX) and then recreated the table plus data with that modified script. It does not feel like the best or optimal solution. Especially not for the Threads/Posts table where I had to split the script file into multiple pieces or MSSQL Management Studio would crash...
OR would it be better to use FreeTDS instead of the IPB MSSQL Driver?

I'm unsure if it's related or not, but I also got some character conversion issues. Where all Swedish characters Å Ä Ö were replaced by garbage.
The MSSQL Database got Collation: Finnish_Swedish_CI_AS and I were unsure what to enter in the conversion tool, so I've tried to leave it blank and also use UTF-8 but I don't think there were any difference in result.


So is there anyone out there who's got some experience in this area and are interested in helping out. And of course get paid for it!

// Markus

Hi,
I've just been working with IPC for a few days and trying to learn along the road... But realize this problem/challenge I'm trying to fix is beyond my basic knowledge.

I'm using a installation in the root folder (so no /Forum).
I would like my users, when the access www.website.com to see a welcome CSS page and also "highlight" the far left tab (Home Tab) but I would also like to use another Frontpage page when they click "Articles" which highlights the Articles Tab.

I've somewhat managed to show a Welcome page (by providing the full Page ID URL in General Settings), but it then highlights the "Article" Tab.
And if I set the welcome page as default in CSS, it will show that when clicking "Articles".

So it feels like I've got a catch 22    and that I'm missing something obvious.

Any pointers?