Quote:
Originally Posted by SROAsia
I just edit this
Code:
$server_name = "TEST"; // Server name;
$host = "***\SQLEXPRESS"; // SQL server name for example PC-NAME\SQLEXPRESS
$user = "sa"; // SQL username
$pass = "123456"; // SQL password
$db = "SRO_VT_ACCOUNT"; // SQL Database
is work fine at my pc but is not to my server (other pc)
what my problem? Please. |
i think this problem with sql 2005
Quote:
Originally Posted by elitebi
Why when this reg page, it allows me to register the same username like I want, it doesn't say username is in use, it just accepts any username even if it in _User db table and it gives me this error:
Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'SRO_VT_SHARD'., SQL state 01000 in SQLExecDirect in C:\AppServ\www\index.php on line 355
If I register with username not used, it doesn't show error
|
smth is wrong with ur db, or maybe you edited the reg page
fix for sql 2005
odbc_exec($connect, "INSERT INTO SK_Silk(JID, silk_own, silk_gift, silk_point) VALUES ({$gift}, {$silk}, 0, 0)");
line 354