web wiz import: Error

[yarden90]

Hi,
I try to import from web wiz system to vbulletin.
I set all the seting in ImpExConfig.php but when i get in to import link in cpadmin i get the next error:

Fatal error: Call to undefined function: mssql_connect() in D:\hshome\dachoweb\dacho.co.il\VBULLETIN\impex\db_mysql.php on line 54

the vbulletin is not in the same server as the web wiz forum, but i set in ImpExConfig.php this:


targetdatabasetype = mysql
targetserver = mysql2.dacho.co.il
targetuser = forum_user
targetpassword = password
targetdatabase = forum_db
targettableprefix =

[ Source Database ]
; If the system that is being imported from uses a database,
; enter the details for it here and set 'sourceexists' to TRUE.
; If the source data is NOT stored in a database, set 'sourceexists' to FALSE

sourceexists = true

; mysql OR mssql
sourcedatabasetype = mssql
sourceserver = mssql.dacho.co.il
sourceuser = dachowe_user
sourcepassword = password
sourcedatabase = dacho_db
sourcetableprefix =


anybody know why i get this problem?
Thn'x yarden.

[Zachery]

Well does your php instaltion have mssql support?

[yarden90]

I don't understand to what you mean... you can explain please?

[Zachery]

php must be compiled or have the module loaded to be able to access a mssql database.

In phpinfo it will show if you have it or not, but seeing that error, you do not have it.

[yarden90]

What I can to do?

[Zachery]

You would need to ask your host to recompile php with mssql support, or wait untill jerry is able to help you with the import.

[yarden90]

Ok,
When I can ask jerry?
He have ICQ? MASSNGER?

[Zachery]

Jerry is generaly not around on the weekends, you can try PM'ing him however.

[yarden90]

ok Thn'x you!

[Jerry]

With out mssql support in php it won't be able to connect to the mssql database.

Best PM me or email [email protected] and ask for me.

[Jerry]

If there is no MSSQL support in php, it will not be able to connect to the database. This can only be fixed by compiling mssql into php, this isn't something that impex or vbulletin can do.

Like so : http://uk.php.net/manual/en/ref.mssql.php

[Jerry]

Ok,
When I can ask jerry?
He have ICQ? MASSNGER?

I do, though I never give support like that.

[dacho]

doesn't works either

Dear Jerry / Support.

We did more than that.
we've created on the windows where the SQL SERVER is located, an account with all the forum's files.
we've tried to convert the webwiz to remote mysql (that is being used by the real forum that sits on the linux server)
and still we've got the same error.
now the PHP that comes for windows (as binary only ofcourse) is with mssql support.

what i recommend is either you can provide us a convert tool that works.
or either we can supply you both connection strings for mssql and mysql and you can do the convert via your server that supports somehow in the mssql in the php.

Thanks
Ofir

[Jerry]

Dear Jerry / Support.

We did more than that.
we've created on the windows where the SQL SERVER is located, an account with all the forum's files.
we've tried to convert the webwiz to remote mysql (that is being used by the real forum that sits on the linux server)
and still we've got the same error.
now the PHP that comes for windows (as binary only ofcourse) is with mssql support.

what i recommend is either you can provide us a convert tool that works.
or either we can supply you both connection strings for mssql and mysql and you can do the convert via your server that supports somehow in the mssql in the php.

Thanks
Ofir

The importer works fine, I've used it many times.

You must have mssql support in php.

I would suggest compiling php with mssql support, that way it will be able to connect to a mssql database.

[Jerry]

we've created on the windows where the SQL SERVER is located, an account with all the forum's files.
we've tried to convert the webwiz to remote mysql (that is being used by the real forum that sits on the linux server)
and still we've got the same error.
now the PHP that comes for windows (as binary only ofcourse) is with mssql support.

Install on the windows server that has the mssql support in the php binary, then move the site to the linux machine once it is installed.