Mssql

[Extron]

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?

[MentaL]

[_Varis_]

mssql_connect($host, $user, $pass)

You mean that?

Also make sure permissions are set up right.

[Extron]

lol. yea. I'm not a idiot like that. My scripts and mssql connects are true.. for sure.

[General]

PCNAME\SQLEXPRESS for Express edition...

PCNAME\MSSQLSERVER for Standard or higher

put that instead of localhost

[Extron]

PCNAME\SQLEXPRESS for Express edition...

PCNAME\MSSQLSERVER for Standard or higher

put that instead of localhost

I also know that, too. Didnt work =)

[DJBL]

If its x64 System try changing all mssql_ Commands to odbc_

Help can be found on Microsoft SQL 2005 Site

[Extron]

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.

[Ace-SG1-]

if you tell us what the errors say, we can help a lot better

[Extron]

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 (?)

[General]

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

[Extron]

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.

[Ace-SG1-]

did u enable mssql in php.ini?

[Extron]

did u enable mssql in php.ini?

I think its automatcly enabled? Else.. in witch line I see that?

[Ace-SG1-]

line 568, or search for "mssql".

[Extron]

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..