connecting sqlserver2000 standard

ooglenz

Hi,

I want to connect my database on my iss server with my sql server who's also on that server does anyone knows the code so far i got this

<?php
$con = mysql_pconnect( "localhost", "username", "pass")

mysql_select_db( "username")

but if i look at the webpage in IE it will return the following :

Warning: mysql_pconnect(): Can't connect to MySQL server on 'localhost' (10061) in C:\Inetpub\wwwroot\Rasor\index.php on line 6
Unable to connect to SQL server

the fault is in
$con = mysql_pconnect( "localhost", "username", "pass")

but i dont know whats wrong

i hope someone can help me

tommynanda

did u start ur mysql server?

goto mysql>bin folder and start winmysqladmin to start mysql server... Next u dont need
user and pass if u are admin

use:
mysql_connect( "localhost","","");

Good Luck
TommYNandA

TheDefender

Are you connecting to a MySQL database, or to a SQL2000 Standard database? According to your title, it is the latter, in which case, the [man]mysql[/man] functions won't work, since they are for MySQL. You should look in the manual at the [man]mssql[/man] functions instead, as these functions provide what you need for MS SQL connectivity. (Keep in mind, you have some specific configuring to do in the php.ini file to be able to use the mssql functions.)

ooglenz

indeed i need configuration for sql2000 and not mysql if you got any advise for me i thank you

ooglenz

sorry to bother further but i still dont get it if i adjust my php.ini without the ; still i cant coonect to mssql.

maybe anobody got an example which should work? or provide me with some information on how to set dsn in odbc etc.?

I think the problem is odbc if that works everything should be ok