Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

SQL 2012 connection issues

Experienced Elementalist
Joined
Oct 18, 2008
Messages
206
Reaction score
19
hi guys please advise i am getting errors trying to connect to a database using SQL2012 and xampp 1.7.3
PHP:
$connect = mssql_pconnect('127.0.0.1:','Anton','1993');
what am i missing here :huh::huh:
 
Joined
Aug 19, 2010
Messages
2,737
Reaction score
2,603
hi guys please advise i am getting errors trying to connect to a database using SQL2012 and xampp 1.7.3
PHP:
$connect = mssql_pconnect('127.0.0.1:','Anton','1993');
what am i missing here :huh::huh:

Maybe try:

PHP:
$connect = mssql_connect('127.0.0.1:','Anton','1993');

So it's not looking for a persistent link.
 
Experienced Elementalist
Joined
Oct 18, 2008
Messages
206
Reaction score
19
maybe now it will be more clearly what i am getting as an error
sh attached
Untitled - SQL 2012 connection issues - RaGEZONE Forums
Bl4ck I0t4 - SQL 2012 connection issues - RaGEZONE Forums
 

Attachments

You must be registered for see attachments list
Newbie Spellweaver
Joined
Dec 26, 2013
Messages
44
Reaction score
12
Make sure in your php.ini (in XAMPP config for Apache) you uncomment the line:

extension=php_mssql.dll
 
Experienced Elementalist
Joined
Jul 3, 2020
Messages
299
Reaction score
24
on some servers sometime when i can't connect with the ip i connect with name of the sql server INSTANCE for example sqlexpress/pcname NOT the ip address ...
 
Graveyard Networks
Joined
Dec 19, 2005
Messages
472
Reaction score
264
on some servers sometime when i can't connect with the ip i connect with name of the sql server INSTANCE for example sqlexpress/pcname NOT the ip address ...
Yes if the tcip is not enabled on the sql configuration and if the connection as well is local
 
Experienced Elementalist
Joined
Jul 3, 2020
Messages
299
Reaction score
24
if you are on express edition on the sql server you have some limitations is very depends on the version on the sql who you use ... sql surface network tcp ip etc... configuration is the solution right
 
Back
Top