VHT
Sat 18th Apr '09, 7:53am
Hi,
I have problem when i try convert ASPPlayground to VB 3.8.x.
Here is error:
Warning: mssql_connect() [function.mssql-connect (http://chotnho.it-4vn.com/impex/function.mssql-connect)]: Unable to connect to server: 127.78.1.17 in [path]\impex\db_mysql.php on line 57
Warning: mssql_select_db(): supplied argument is not a valid MS SQL-Link resource in [path]\impex\db_mysql.php on line 193
Here is my ImpExConfig.php:
<?php
################################################## ################## |;
# vBulletin [#]version[#] - Licence Number [#]license[#]
# ---------------------------------------------------------------- # |;
# Copyright ©2000–[#]year[#] Jelsoft Enterprises Ltd. All Rights Reserved. |;
# This file may not be redistributed in whole or significant part. # |;
# ---------------- VBULLETIN IS NOT FREE SOFTWARE ---------------- # |;
# http://www.vbulletin.com | http://www.vbulletin.com/license.html # |;
################################################## ################## |;
# The following settings allow ImpEx to connect to the vBulletin 3
# database into which you will be importing data.
# If impex is installed in vBulletin you can ignore the target details
# as includes/config.php
$impexconfig['target']['databasetype'] = 'mysql';
$impexconfig['target']['server'] = 'localhost';
$impexconfig['target']['user'] = 'myvbb_user';
$impexconfig['target']['password'] = 'myvbbsqlpass';
$impexconfig['target']['database'] = 'myvbbsqldb';
$impexconfig['target']['tableprefix'] = '';
# 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
$impexconfig['sourceexists'] = true;
# mysql / mssql
$impexconfig['source']['databasetype'] = 'mssql';
$impexconfig['source']['server'] = '127.78.1.17';
$impexconfig['source']['user'] = 'sa';
$impexconfig['source']['password'] = 'my-sa-password';
$impexconfig['source']['database'] = 'ASPPlayground-DB';
$impexconfig['source']['tableprefix'] = 'pgd_';
# Error logging will log import errors to a database table impexerror
# for use with support.
# Language file is the file of phrases to be used, default is english.
# pagespeed is the second(s) wait before the page refreshes.
$impexconfig['system']['errorlogging'] = true;
$impexconfig['system']['language'] = '/impex_language.php';
$impexconfig['system']['pagespeed'] = 1;
define('impexdebug', false);
define('emailcasesensitive', false);
define('forcesqlmode', false);
define('skipparentids', false);
?>
Server running Plesk 9.0.1 + MSSQL 2005.
Here is phpinfo:
http://chotnho.it-4vn.com/impex/info.php
Anyone can help me fix this problem ? Thank you
I have problem when i try convert ASPPlayground to VB 3.8.x.
Here is error:
Warning: mssql_connect() [function.mssql-connect (http://chotnho.it-4vn.com/impex/function.mssql-connect)]: Unable to connect to server: 127.78.1.17 in [path]\impex\db_mysql.php on line 57
Warning: mssql_select_db(): supplied argument is not a valid MS SQL-Link resource in [path]\impex\db_mysql.php on line 193
Here is my ImpExConfig.php:
<?php
################################################## ################## |;
# vBulletin [#]version[#] - Licence Number [#]license[#]
# ---------------------------------------------------------------- # |;
# Copyright ©2000–[#]year[#] Jelsoft Enterprises Ltd. All Rights Reserved. |;
# This file may not be redistributed in whole or significant part. # |;
# ---------------- VBULLETIN IS NOT FREE SOFTWARE ---------------- # |;
# http://www.vbulletin.com | http://www.vbulletin.com/license.html # |;
################################################## ################## |;
# The following settings allow ImpEx to connect to the vBulletin 3
# database into which you will be importing data.
# If impex is installed in vBulletin you can ignore the target details
# as includes/config.php
$impexconfig['target']['databasetype'] = 'mysql';
$impexconfig['target']['server'] = 'localhost';
$impexconfig['target']['user'] = 'myvbb_user';
$impexconfig['target']['password'] = 'myvbbsqlpass';
$impexconfig['target']['database'] = 'myvbbsqldb';
$impexconfig['target']['tableprefix'] = '';
# 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
$impexconfig['sourceexists'] = true;
# mysql / mssql
$impexconfig['source']['databasetype'] = 'mssql';
$impexconfig['source']['server'] = '127.78.1.17';
$impexconfig['source']['user'] = 'sa';
$impexconfig['source']['password'] = 'my-sa-password';
$impexconfig['source']['database'] = 'ASPPlayground-DB';
$impexconfig['source']['tableprefix'] = 'pgd_';
# Error logging will log import errors to a database table impexerror
# for use with support.
# Language file is the file of phrases to be used, default is english.
# pagespeed is the second(s) wait before the page refreshes.
$impexconfig['system']['errorlogging'] = true;
$impexconfig['system']['language'] = '/impex_language.php';
$impexconfig['system']['pagespeed'] = 1;
define('impexdebug', false);
define('emailcasesensitive', false);
define('forcesqlmode', false);
define('skipparentids', false);
?>
Server running Plesk 9.0.1 + MSSQL 2005.
Here is phpinfo:
http://chotnho.it-4vn.com/impex/info.php
Anyone can help me fix this problem ? Thank you