Re: MSSQL_CONNECT problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



>
>  Sorry for "top posting", that's how my email client sets up the reply...
>
> Anyway, I don't know what CLI is....? I see the error on the web. As for
> a DSN, I didn't think I need one connecting this way. That is why the
> uname, password, database is supplied, no? This should be a "dsn-less"
> connection....
>
> Either way - I tried adding a DNS on the web server, that points to the
> SQL database, and that connection works...but the code I'm using from
> the web page still does not....
>
> If I use the code you gave me, this is what I get:
>
> Warning: mssql_connect() [function.mssql-connect]: Unable to connect to
> server: INTRA_SQL,1433 in D:\Inetpub\wwwroot\cratos\test.php on line 2
>
> Fatal error: Call to undefined function mssql_error() in
> D:\Inetpub\wwwroot\cratos\test.php on line 2
>
> Please advise...
>

Try something like this:

$dbhost=\\\\SERVER\\INSTANCE_NAME,PORT;
$dbuser="USERNAME";
$dbpass="PASSWORD";
$db_connect=mssql_connect($dbhost,$dbuser,$dbpass) or die ('Server
connection failed');

$mssql_database = mssql_select_db("DATABASE", $db_connect) or die ('DB
selection failed');

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux