Hello,
First of all. The SQL- server is runing on a windows web server 2008.
MSSQL (2005 edition) is working as well, ODBC is also working, too.
Now the problem: When I want to connect the website scripts with the database isn't it working... I also tryed it via direct connect, also $mssql_connect = ("host","user","pass") and via ODBC connect.. But nothing happens...
Can anyone help me?
mssql_connect($host, $user, $pass)
You mean that?
Also make sure permissions are set up right.
lol. yea. I'm not a idiot like that. My scripts and mssql connects are true.. for sure.
PCNAME\SQLEXPRESS for Express edition...
PCNAME\MSSQLSERVER for Standard or higher
put that instead of localhost
I also know that, too. Didnt work =)Originally Posted by BjornVH
If its x64 System try changing all mssql_ Commands to odbc_
Help can be found on Microsoft SQL 2005 Site
Yes. It is x64. I also tryed it.. But it wont work.
if you tell us what the errors say, we can help a lot better
Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: GOLF873\SQLEXPRESS in C:\inetpub\bla\bla\bla on line 19
How i said.. The database works fine.. I think anything is blocking the connection to my scripts (?)
Check in "Start -> Programs -> Microsoft SQL Server 2005 -> (Native) Client Network tool / Server network tools" if your TCP/IP is enabled, and if a port is set (should be 1433)
Oh yes, XAMPP doesnt work with MSSQL 2005. You need to find a fixed ntwdblib.dll and place it under apache/bin
TCP/IP is enabled. Oh I don't use XAMPP, its just PLESK.
did u enable mssql in php.ini?
I think its automatcly enabled? Else.. in witch line I see that?
line 568, or search for "mssql".
Line 568 in my php.ini = ";extension=php_ming.dll".
And yea.. all is enabled. Damn I dont understand that shit..
PLESK as in from here?
http://www.parallels.com/products/plesk/demo/
It's PLESK 8.6
your going to have to contact them, or your host ask them why cant i connet. and is it even MSSQL?
How I said. The database (MSSQL '05) works well.
Stop using plesk, start using xampp, and like Bjorn said: "You need to find a fixed ntwdblib.dll and place it under apache/bin" Then it will work with mssql_connect('pcname\SQLEXPRESS','sa','pwd');
Thank you all guys, this forum is really helpfully. If anyone got these fixed "ntwdblib.dll" let me know please.
fyi. xampp you need to replace that .dll... xD lol and PLESK is something like "cPanel" it controls the server.
Here ya go, 1min on google and i got it.
I allready had it, thanks anyway. Works fine :)!
Now I have the trouble with PLESK. I still need PLESK.
I also used another port for XAMPP (2500), works also fine.
But when I want to join the site, its opening the site first. But after 10 seconds is there a timeout.
And the mainpage (also this one witch is running on PLESK) shows now the PLESK-START-SITE Oo.
well why the hell are you using plesk on a dedicated server? get rid of it. its just ristrictive and annoying. kill it and put xampp on port 80. should fix most of your issues
Reply With Quote