$conn = new PDO("sqlsrv:server=$host;database=$acc;ConnectionPooling=0",$user,$pass);
$host="XXXXXXX\SQLEXPRESS"
exampleQuote:
Hey I'm trying to setup a simple Website to create Accounts on my Server, but i can't connect to database.
But what if its not local? is there sth like "ip:XXXXXXX\SQLEXPRESS"Code:$conn = new PDO("sqlsrv:server=$host;database=$acc;ConnectionPooling=0",$user,$pass); $host="XXXXXXX\SQLEXPRESS"
yes you can add via IPQuote:
I did exactly what you said, but i still can't connect. :confused:Quote:
$host = "VALTYR-PC\SQLEXPRESS"; //SQL Host name
$user = "sa"; //SQL server username
$password = "YouTubeValtyr"; //SQL Server password
$dbs = array(
'ACC'=>"SRO_VT_ACCOUNT",
'SHARD'=>"SRO_VT_SHARD",
'LOG'=>"SRO_VT_SHARDLOG",
'WEB'=>"SRO_VT_VALTYR"); //Databases
yes you can add via IP
open the port in SQL Server Configuration Manager
Click down SQL Server Network Configuration
click on Protocols for SQLEXPRESS and than Enable TCP/IP
after this double klick left and IP Addresses
Scroll down IPAll add in TCP Dynamic Port 1443
and done
Dont forget Restart SQL Server
and done
if you want to add via via sql host use your ip with port 1443 dont forget after your IP ,1443
example $host="127.0.0.1,1443"
<?php
$dbhost="XX.XXX.XX.XXX,1443";
$dbname="SRO_VT_ACCOUNT";
$dbusername="sa";
$dbpassword="XXXXXXXXXXXXXXXX";
$link = new PDO("mysql:host=$dbhost;dbname=$dbname", $dbusername, $dbpassword);
$statement = $link->prepare("INSERT INTO dbo.TB_User(StrUserID, password, sec_primary, sec_content)
VALUES(:name, :pass, :sec_p, :sec_c)");
$statement->execute(array(
"name" => "testname",
"pass" => "e22a63fb76874c99488435f26b117e37",
"sec_p" => 3,
"sec_c" => 3
));
?>
Quote:
Already did this a few days ago.
THC/IP at Protocols for SQLEXPRESS is already activated. Used another port for dynamic, but changed it to 1443 too.
Is there maybe another solution?
Thanks.
--------------------
Fatal error: Uncaught exception 'PDOException' with message 'could not find driver' in /xxxxxxxxxxxxxxxxxxxxxxx/sql.php:13 Stack trace: #0
#push
Port is open (checked) ✓
SQL Server is Running ✓
Password & Username are right ✓
Don't know what to do..
Thats the full connecting code (PDO)..
I always get error code 500 and don't know what to do.. the SQL Port shall be open ([Only registered and activated users can see links. Click Here To Register...] Proofed)..PHP Code:<?php
$dbhost="XX.XXX.XX.XXX,1443";
$dbname="SRO_VT_ACCOUNT";
$dbusername="sa";
$dbpassword="XXXXXXXXXXXXXXXX";
$link = new PDO("mysql:host=$dbhost;dbname=$dbname", $dbusername, $dbpassword);
$statement = $link->prepare("INSERT INTO dbo.TB_User(StrUserID, password, sec_primary, sec_content)
VALUES(:name, :pass, :sec_p, :sec_c)");
$statement->execute(array(
"name" => "testname",
"pass" => "e22a63fb76874c99488435f26b117e37",
"sec_p" => 3,
"sec_c" => 3
));
?>
Please Help
you will connect to mysql ??Quote:
$link = new PDO("mysql:host=$dbhost;dbname=$dbname", $dbusername, $dbpassword);
also i never see that any create silkroad database for mysql :DQuote:
$this->connect = new PDO("sqlsrv:Server=$host;Database=$dbs[WEB]",$user,$password);
Quote:
im connecting is via mssql also sqlsrv
also i never see that any create silkroad database for mysql :D
also change mysql:host to sqlsrv:host
<?php
$cfg['sql_host'] = "xxxxxxxxxxxxx,1443";
$cfg['sql_user'] = "sa";
$cfg['sql_pass'] = "xxxxxxxxxxxxx";
$cfg['sql_db'] = "SRO_VT_ACCOUNT";
$sqlLink = mssql_connect($cfg[sql_host],$cfg[sql_user],$cfg[sql_pass]);
if(!$sqlLink) die("MSSQL server is not accessable, why should we try to select database ?");
else
{
mssql_select_db($cfg[sql_db],$sqlLink);
}
?>
$sql = new PDO("sqlsrv:server=192.168.81.128,1433;database=SRO_VT_SHARD","sa","sqlpw");
Who the fuck cares? I started with sqlsrv, as you see. I't didn't worked. I read all treads within those who were 7 yeas old. Now im pretty sure, its not the way of connection, causing my troubles..Quote:
couldnt you just tell me, "you have to install sqlsrv extensions" A WEEK AGO?Quote:
download wamp or some other webserver for development
install the sqlsrv extensions (download based on your php version 5.6+ advised)
pdo connection string
Code:$sql = new PDO("sqlsrv:server=192.168.81.128,1433;database=SRO_VT_SHARD","sa","sqlpw");
use zend is one of the best webserver install sqlsrv and setup your webpage :)Quote:
My first way of connection is 100% correct.. ;)
couldnt you just tell me, "you have to install sqlsrv extensions" A WEEK AGO?
i don't like posting dms on public forum but here it isQuote: