subject:"\[PHP\-DB\] Re\: MS SQL error...I've come a long way to get this far"

RE: [PHP-DB] Re: MS SQL error...I've come a long way to get this far

2008-12-09 Thread Fred Silsbee

--- On Mon, 12/8/08, Fortuno, Adam [EMAIL PROTECTED] wrote:

 From: Fortuno, Adam [EMAIL PROTECTED]
 Subject: RE: [PHP-DB] Re: MS SQL error...I've come a long way to get this far
 To: [EMAIL PROTECTED]
 Date: Monday, December 8, 2008, 10:56 PM
 Fred,

 Hmm, that makes me think the extension didn't load.
 When you fire up a
 page with ?php php_info(); ? do you see the
 module's information?

 If it makes you feel any better, I'm working thru
 integration with
 Oracle, and I'm not fairing too much better.

 A-

 -Original Message-
 From: Fred Silsbee [mailto:[EMAIL PROTECTED] 
 Sent: Monday, December 08, 2008 5:53 PM
 To: Fortuno, Adam
 Subject: RE: [PHP-DB] Re: MS SQL error...I've come a
 long way to get
 this far

 --- On Mon, 12/8/08, Fortuno, Adam
 [EMAIL PROTECTED] wrote:

  From: Fortuno, Adam [EMAIL PROTECTED]
  Subject: RE: [PHP-DB] Re: MS SQL error...I've come
 a long way to get
 this far
  To: [EMAIL PROTECTED], php-db@lists.php.net
  Date: Monday, December 8, 2008, 9:26 PM
  Fred,

  If you're using integrated security (e.g., a
 domain
  account such as
  domain\bob), you won't supply a
  password. However, the sa account is
  a SQL login (v.s. a domain login). In that case, it
 would
  make sense
  that you supply a password. See the following page for
 some
  code to
  connect using integrated security:

 http://msdn.microsoft.com/en-us/library/cc296205(SQL.90).aspx

  See the following page for some code to connect using
 a SQL
  login:

 http://msdn.microsoft.com/en-us/library/cc296182(SQL.90).aspx

  If you're curious if this is even an
  authentication/permissions issue,
  try to login using a domain login. The login event
 will be
  recorded in
  the `Event Viewer`. If you're attempt isn't
  recorded, you've got a
  communication problem with the server instance. If it
 is
  recorded,
  you'll be able to tell what the problem is
  authenticating.

  Good luck, and let us know how it turns out.

  A-

  -Original Message-
  From: Fred Silsbee [mailto:[EMAIL PROTECTED] 
  Sent: Monday, December 08, 2008 3:30 PM
  To: php-db@lists.php.net
  Subject: [PHP-DB] Re: MS SQL error...I've come a
 long
  way to get this
  far

  I was just thinking about something I've never
  understood completely!

  mssql_connect($server, 'sa', 'PW');
  presumes the server doesn't have all
  the permissions in spite of the fact that it has the
  password.

  The password I gave is the XP Prof login PW.

  Maybe some other PW. 

  --- On Mon, 12/8/08, Fred Silsbee
  [EMAIL PROTECTED] wrote:

   From: Fred Silsbee [EMAIL PROTECTED]
   Subject: MS SQL error...I've come a long way
 to
  get this far
   To: php-db@lists.php.net
   Date: Monday, December 8, 2008, 7:13 PM
   many changes to php.ini to get this far..whew!

   PHP 5.2.7 just got jerked out from underneathe me
 (I
   have't replaced it since this is a simple
 script)

   phpinfo works!

   ?php
   // Server in the this format:
   computer\instance name or 
   // server,port when using a non
  default
   port number
   $server = 'LANDON\SQLEXPRESS';

   $link = mssql_connect($server, 'sa',
  'PW');
  line 6

   if(!$link)
   {
   die('Something went wrong while
 connecting to
   MSSQL');
   }
   ?

   Warning: mssql_connect()
 [function.mssql-connect]:
  Unable
   to connect to server: LANDON\SQLEXPRESS in
   C:\Inetpub\wwwroot\trymssql.php on
 line 6
   Something went wrong while connecting to MSSQL

  -- 
  PHP Database Mailing List (http://www.php.net/)
  To unsubscribe, visit: http://www.php.net/unsub.php

 thanks!

 using the integrated server login code (first link you
 included, I get:

 Fatal error: Call to undefined function sqlsrv_connect() in
 C:\Inetpub\wwwroot\trymssql_1.php on line 7

 still banging away

meticulously loaded the new MS PHP upgrade update and still no luck

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Re: MS SQL error...I've come a long way to get this far

2008-12-09 Thread Fred Silsbee

--- On Tue, 12/9/08, Fortuno, Adam [EMAIL PROTECTED] wrote:

 From: Fortuno, Adam [EMAIL PROTECTED]
 Subject: RE: [PHP-DB] Re: MS SQL error...I've come a long way to get this far
 To: [EMAIL PROTECTED]
 Date: Tuesday, December 9, 2008, 5:14 PM
 Sorry! I've been swamped today, and I needed to install
 the PHP module
 for SQL Server before I could respond.

 Fred integration with Oracle...Linux or Windows?
 Fred I've got the Linux Oracle 11g1/PHP 5.2.6/ and
 MySQL 
 Fred connection down...I can email working code.

 Windows. I'm running PHP (in ISAPI mode) on IIS
 integrating with a 9i
 instance on a RedHat box.

 Fred When I run :
 Fred ?php
 Fred // Server in the this format:
 computer\instance name or 
 Fred // server,port when using a non
 default port number
 Fred $server = 'LANDON\SQLEXPRESS';
 Fred
 Fred $link = mssql_connect($server, 'sa',
 'K^a_t^e_a_u_x_3141');
 Fred
 Fred if(!$link)
 Fred {
 Fred die('Something went wrong while connecting
 to MSSQL');
 Fred }
 Fred?
 Fred
 Fred I get
 Fred
 Fred Warning: mssql_connect() [function.mssql-connect]:
 Unable to
 connect 
 Fred to server: LANDON\SQLEXPRESS in
 C:\Inetpub\wwwroot\trymssql.php on

 Fred line 6 Something went wrong while connecting to
 MSSQL

 I installed the PHP module for SQL Server 2005 this
 morning, and I
 updated my php.ini file then restarted IIS. I dumped the
 following into
 a page, and I ran it.

 $server = 'Babylon';
 $uid = 'UserName';
 $pwd = '[EMAIL PROTECTED]';

 $connectionInfo = array(UID = $uid,
 PWD = $pwd);
 $link = sqlsrv_connect($server, $connectionInfo);

 if(!$link)
 {
   die('Something went wrong while connecting to
 MSSQL');
 }

 It worked without a problem. I downloaded whatever B.S.
 module Microsoft
 had on their site, and here is what I added to my ini:

 My php.ini file includes:

 [SQL_Server_2005]
 extension=php_sqlsrv_ts.dll

 I'm trying a different function than you did. Give my
 script a try.

 A-

THANKS I'll try it

I downloaded the adventure works .msi file and successfully installed it but 
found no new tables in my SQL SERVER 2005.

This is from Microsoft:
?php
/* Specify the server and connection string attributes. */
$serverName = (local);
$connectionInfo = array( Database=AdventureWorks);

/* Connect using Windows Authentication. */
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn === false )
{
 echo Unable to connect./br;
 die( print_r( sqlsrv_errors(), true));
}

/* Query SQL Server for the login of the user accessing the
database. */
$tsql = SELECT CONVERT(varchar(32), SUSER_SNAME());
$stmt = sqlsrv_query( $conn, $tsql);
if( $stmt === false )
{
 echo Error in executing query./br;
 die( print_r( sqlsrv_errors(), true));
}

/* Retrieve and display the results of the query. */
$row = sqlsrv_fetch_array($stmt);
echo User login: .$row[0]./br;

/* Free statement and connection resources. */
sqlsrv_free_stmt( $stmt);
sqlsrv_close( $conn);
?

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Re: MS SQL error...I've come a long way to get this far

2008-12-09 Thread Fred Silsbee

--- On Tue, 12/9/08, Fortuno, Adam [EMAIL PROTECTED] wrote:

 From: Fortuno, Adam [EMAIL PROTECTED]
 Subject: RE: [PHP-DB] Re: MS SQL error...I've come a long way to get this far
 To: [EMAIL PROTECTED]
 Date: Tuesday, December 9, 2008, 5:14 PM
 Sorry! I've been swamped today, and I needed to install
 the PHP module
 for SQL Server before I could respond.

 Fred integration with Oracle...Linux or Windows?
 Fred I've got the Linux Oracle 11g1/PHP 5.2.6/ and
 MySQL 
 Fred connection down...I can email working code.

 Windows. I'm running PHP (in ISAPI mode) on IIS
 integrating with a 9i
 instance on a RedHat box.

 Fred When I run :
 Fred ?php
 Fred // Server in the this format:
 computer\instance name or 
 Fred // server,port when using a non
 default port number
 Fred $server = 'LANDON\SQLEXPRESS';
 Fred
 Fred $link = mssql_connect($server, 'sa',
 'K^a_t^e_a_u_x_3141');
 Fred
 Fred if(!$link)
 Fred {
 Fred die('Something went wrong while connecting
 to MSSQL');
 Fred }
 Fred?
 Fred
 Fred I get
 Fred
 Fred Warning: mssql_connect() [function.mssql-connect]:
 Unable to
 connect 
 Fred to server: LANDON\SQLEXPRESS in
 C:\Inetpub\wwwroot\trymssql.php on

 Fred line 6 Something went wrong while connecting to
 MSSQL

 I installed the PHP module for SQL Server 2005 this
 morning, and I
 updated my php.ini file then restarted IIS. I dumped the
 following into
 a page, and I ran it.

 $server = 'Babylon';
 $uid = 'UserName';
 $pwd = '[EMAIL PROTECTED]';

 $connectionInfo = array(UID = $uid,
 PWD = $pwd);
 $link = sqlsrv_connect($server, $connectionInfo);

 if(!$link)
 {
   die('Something went wrong while connecting to
 MSSQL');
 }

 It worked without a problem. I downloaded whatever B.S.
 module Microsoft
 had on their site, and here is what I added to my ini:

 My php.ini file includes:

 [SQL_Server_2005]
 extension=php_sqlsrv_ts.dll

 I'm trying a different function than you did. Give my
 script a try.

 A-

I've truly gotten lots of help from this forum/list

I tried the following and got:Something went wrong while connecting to MSSQL

?php
// Server in the this format: computer\instance name or 
// server,port when using a non default port number
$server = 'LANDON\SQLEXPRESS';

//$server = '(local)\sqlexpress';
// $server = 'Babylon';
$uid = 'sa';
$pwd = 'xyxyxyxyx';

$connectionInfo = array(UID = $uid, PWD = $pwd);
$link = sqlsrv_connect($server, $connectionInfo);

if(!$link)
{
die('Something went wrong while connecting to MSSQL');
}

?

I only have the 2nd statement of your:

[SQL_Server_2005]
extension=php_sqlsrv_ts.dll

I'll try anything at this point!  thanks again!

I have added to my path both directories where I downloaded PHP files

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Re: MS SQL error...I've come a long way to get this far

2008-12-09 Thread Fred Silsbee

--- On Tue, 12/9/08, Fortuno, Adam [EMAIL PROTECTED] wrote:

 From: Fortuno, Adam [EMAIL PROTECTED]
 Subject: RE: [PHP-DB] Re: MS SQL error...I've come a long way to get this far
 To: [EMAIL PROTECTED]
 Date: Tuesday, December 9, 2008, 8:20 PM
 Fred,

 Have you checked the permissions on the extensions to make
 sure that the
 process running your site has access? Since you're able
 to call the
 function, I don't think this is the problem, but
 I'm running out of
 ideas. Also, are you seeing anything in SQL Server's
 error log or the
 event log, which might be helpful?  You have SQL Server
 Native Client
 installed? I assume you've quadruple-checked the
 credentials?

 A-

 -Original Message-
 From: Fred Silsbee [mailto:[EMAIL PROTECTED] 
 Sent: Tuesday, December 09, 2008 1:39 PM
 To: Fortuno, Adam
 Cc: php-db@lists.php.net
 Subject: RE: [PHP-DB] Re: MS SQL error...I've come a
 long way to get
 this far

 --- On Tue, 12/9/08, Fortuno, Adam
 [EMAIL PROTECTED] wrote:

  From: Fortuno, Adam [EMAIL PROTECTED]
  Subject: RE: [PHP-DB] Re: MS SQL error...I've come
 a long way to get
 this far
  To: [EMAIL PROTECTED]
  Date: Tuesday, December 9, 2008, 5:14 PM
  Sorry! I've been swamped today, and I needed to
 install
  the PHP module
  for SQL Server before I could respond.

  Fred integration with Oracle...Linux or Windows?
  Fred I've got the Linux Oracle 11g1/PHP 5.2.6/
 and
  MySQL 
  Fred connection down...I can email working code.

  Windows. I'm running PHP (in ISAPI mode) on IIS
  integrating with a 9i
  instance on a RedHat box.

  Fred When I run :
  Fred ?php
  Fred // Server in the this format:
  computer\instance name or 
  Fred // server,port when using a
 non
  default port number
  Fred $server = 'LANDON\SQLEXPRESS';
  Fred
  Fred $link = mssql_connect($server, 'sa',
  'K^a_t^e_a_u_x_3141');
  Fred
  Fred if(!$link)
  Fred {
  Fred die('Something went wrong while
 connecting
  to MSSQL');
  Fred }
  Fred?
  Fred
  Fred I get
  Fred
  Fred Warning: mssql_connect()
 [function.mssql-connect]:
  Unable to
  connect 
  Fred to server: LANDON\SQLEXPRESS in
  C:\Inetpub\wwwroot\trymssql.php on

  Fred line 6 Something went wrong while connecting
 to
  MSSQL

  I installed the PHP module for SQL Server 2005 this
  morning, and I
  updated my php.ini file then restarted IIS. I dumped
 the
  following into
  a page, and I ran it.

  $server = 'Babylon';
  $uid = 'UserName';
  $pwd = '[EMAIL PROTECTED]';

  $connectionInfo = array(UID = $uid,
  PWD = $pwd);
  $link = sqlsrv_connect($server, $connectionInfo);

  if(!$link)
  {
  die('Something went wrong while connecting to
  MSSQL');
  }

  It worked without a problem. I downloaded whatever
 B.S.
  module Microsoft
  had on their site, and here is what I added to my ini:

  My php.ini file includes:

  [SQL_Server_2005]
  extension=php_sqlsrv_ts.dll

  I'm trying a different function than you did. Give
 my
  script a try.

  A-

 I've truly gotten lots of help from this
 forum/list

 I tried the following and got:Something went wrong while
 connecting to
 MSSQL

 ?php
 // Server in the this format:
 computer\instance name or 
 // server,port when using a non default
 port number
 $server = 'LANDON\SQLEXPRESS';

 //$server = '(local)\sqlexpress';
 // $server = 'Babylon';
 $uid = 'sa';
 $pwd = 'xyxyxyxyx';

 $connectionInfo = array(UID = $uid,
 PWD = $pwd);
 $link = sqlsrv_connect($server, $connectionInfo);

 if(!$link)
 {
 die('Something went wrong while connecting to
 MSSQL');
 }

 ?

 I only have the 2nd statement of your:

 [SQL_Server_2005]
 extension=php_sqlsrv_ts.dll

 I'll try anything at this point!  thanks again!

 I have added to my path both directories where I downloaded
 PHP files

permissions sound viable...problem is that the only way I see permissions can 
be set is on directories

Problem put on MSDN forum if you are interested:

http://forums.microsoft.com/forums/ShowPost.aspx?PostID=4227666SiteID=1

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: MS SQL error...I've come a long way to get this far

2008-12-08 Thread Fred Silsbee

I was just thinking about something I've never understood completely!

mssql_connect($server, 'sa', 'PW'); presumes the server doesn't have all the 
permissions in spite of the fact that it has the password.

The password I gave is the XP Prof login PW.

Maybe some other PW. 


--- On Mon, 12/8/08, Fred Silsbee [EMAIL PROTECTED] wrote:

 From: Fred Silsbee [EMAIL PROTECTED]
 Subject: MS SQL error...I've come a long way to get this far
 To: php-db@lists.php.net
 Date: Monday, December 8, 2008, 7:13 PM
 many changes to php.ini to get this far..whew!
 
 PHP 5.2.7 just got jerked out from underneathe me (I
 have't replaced it since this is a simple script)
 
 phpinfo works!
 
 ?php
 // Server in the this format:
 computer\instance name or 
 // server,port when using a non default
 port number
 $server = 'LANDON\SQLEXPRESS';
 
 $link = mssql_connect($server, 'sa', 'PW');
line 6
 
 if(!$link)
 {
 die('Something went wrong while connecting to
 MSSQL');
 }
 ?
 
 
 Warning: mssql_connect() [function.mssql-connect]: Unable
 to connect to server: LANDON\SQLEXPRESS in
 C:\Inetpub\wwwroot\trymssql.php on line 6
 Something went wrong while connecting to MSSQL


  


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Re: MS SQL error...I've come a long way to get this far

2008-12-08 Thread Fortuno, Adam

Fred,

If you're using integrated security (e.g., a domain account such as
domain\bob), you won't supply a password. However, the sa account is
a SQL login (v.s. a domain login). In that case, it would make sense
that you supply a password. See the following page for some code to
connect using integrated security:

http://msdn.microsoft.com/en-us/library/cc296205(SQL.90).aspx

See the following page for some code to connect using a SQL login:

http://msdn.microsoft.com/en-us/library/cc296182(SQL.90).aspx

If you're curious if this is even an authentication/permissions issue,
try to login using a domain login. The login event will be recorded in
the `Event Viewer`. If you're attempt isn't recorded, you've got a
communication problem with the server instance. If it is recorded,
you'll be able to tell what the problem is authenticating.

Good luck, and let us know how it turns out.

A-


-Original Message-
From: Fred Silsbee [mailto:[EMAIL PROTECTED] 
Sent: Monday, December 08, 2008 3:30 PM
To: php-db@lists.php.net
Subject: [PHP-DB] Re: MS SQL error...I've come a long way to get this
far

I was just thinking about something I've never understood completely!

mssql_connect($server, 'sa', 'PW'); presumes the server doesn't have all
the permissions in spite of the fact that it has the password.

The password I gave is the XP Prof login PW.

Maybe some other PW. 


--- On Mon, 12/8/08, Fred Silsbee [EMAIL PROTECTED] wrote:

 From: Fred Silsbee [EMAIL PROTECTED]
 Subject: MS SQL error...I've come a long way to get this far
 To: php-db@lists.php.net
 Date: Monday, December 8, 2008, 7:13 PM
 many changes to php.ini to get this far..whew!
 
 PHP 5.2.7 just got jerked out from underneathe me (I
 have't replaced it since this is a simple script)
 
 phpinfo works!
 
 ?php
 // Server in the this format:
 computer\instance name or 
 // server,port when using a non default
 port number
 $server = 'LANDON\SQLEXPRESS';
 
 $link = mssql_connect($server, 'sa', 'PW');
line 6
 
 if(!$link)
 {
 die('Something went wrong while connecting to
 MSSQL');
 }
 ?
 
 
 Warning: mssql_connect() [function.mssql-connect]: Unable
 to connect to server: LANDON\SQLEXPRESS in
 C:\Inetpub\wwwroot\trymssql.php on line 6
 Something went wrong while connecting to MSSQL


  


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Re: MS SQL error...I've come a long way to get this far

2008-12-08 Thread Fred Silsbee

--- On Mon, 12/8/08, Fortuno, Adam [EMAIL PROTECTED] wrote:

 From: Fortuno, Adam [EMAIL PROTECTED]
 Subject: RE: [PHP-DB] Re: MS SQL error...I've come a long way to get this far
 To: [EMAIL PROTECTED]
 Date: Monday, December 8, 2008, 10:56 PM
 Fred,

 Hmm, that makes me think the extension didn't load.
 When you fire up a
 page with ?php php_info(); ? do you see the
 module's information?

 If it makes you feel any better, I'm working thru
 integration with
 Oracle, and I'm not fairing too much better.

 A-

 -Original Message-
 From: Fred Silsbee [mailto:[EMAIL PROTECTED] 
 Sent: Monday, December 08, 2008 5:53 PM
 To: Fortuno, Adam
 Subject: RE: [PHP-DB] Re: MS SQL error...I've come a
 long way to get
 this far

 --- On Mon, 12/8/08, Fortuno, Adam
 [EMAIL PROTECTED] wrote:

  From: Fortuno, Adam [EMAIL PROTECTED]
  Subject: RE: [PHP-DB] Re: MS SQL error...I've come
 a long way to get
 this far
  To: [EMAIL PROTECTED], php-db@lists.php.net
  Date: Monday, December 8, 2008, 9:26 PM
  Fred,

  If you're using integrated security (e.g., a
 domain
  account such as
  domain\bob), you won't supply a
  password. However, the sa account is
  a SQL login (v.s. a domain login). In that case, it
 would
  make sense
  that you supply a password. See the following page for
 some
  code to
  connect using integrated security:

 http://msdn.microsoft.com/en-us/library/cc296205(SQL.90).aspx

  See the following page for some code to connect using
 a SQL
  login:

 http://msdn.microsoft.com/en-us/library/cc296182(SQL.90).aspx

  If you're curious if this is even an
  authentication/permissions issue,
  try to login using a domain login. The login event
 will be
  recorded in
  the `Event Viewer`. If you're attempt isn't
  recorded, you've got a
  communication problem with the server instance. If it
 is
  recorded,
  you'll be able to tell what the problem is
  authenticating.

  Good luck, and let us know how it turns out.

  A-

  -Original Message-
  From: Fred Silsbee [mailto:[EMAIL PROTECTED] 
  Sent: Monday, December 08, 2008 3:30 PM
  To: php-db@lists.php.net
  Subject: [PHP-DB] Re: MS SQL error...I've come a
 long
  way to get this
  far

  I was just thinking about something I've never
  understood completely!

  mssql_connect($server, 'sa', 'PW');
  presumes the server doesn't have all
  the permissions in spite of the fact that it has the
  password.

  The password I gave is the XP Prof login PW.

  Maybe some other PW. 

  --- On Mon, 12/8/08, Fred Silsbee
  [EMAIL PROTECTED] wrote:

   From: Fred Silsbee [EMAIL PROTECTED]
   Subject: MS SQL error...I've come a long way
 to
  get this far
   To: php-db@lists.php.net
   Date: Monday, December 8, 2008, 7:13 PM
   many changes to php.ini to get this far..whew!

   PHP 5.2.7 just got jerked out from underneathe me
 (I
   have't replaced it since this is a simple
 script)

   phpinfo works!

   ?php
   // Server in the this format:
   computer\instance name or 
   // server,port when using a non
  default
   port number
   $server = 'LANDON\SQLEXPRESS';

   $link = mssql_connect($server, 'sa',
  'PW');
  line 6

   if(!$link)
   {
   die('Something went wrong while
 connecting to
   MSSQL');
   }
   ?

   Warning: mssql_connect()
 [function.mssql-connect]:
  Unable
   to connect to server: LANDON\SQLEXPRESS in
   C:\Inetpub\wwwroot\trymssql.php on
 line 6
   Something went wrong while connecting to MSSQL

  -- 
  PHP Database Mailing List (http://www.php.net/)
  To unsubscribe, visit: http://www.php.net/unsub.php

 thanks!

 using the integrated server login code (first link you
 included, I get:

 Fatal error: Call to undefined function sqlsrv_connect() in
 C:\Inetpub\wwwroot\trymssql_1.php on line 7

 still banging away

integration with Oracle...Linux or Windows?

I've got the Linux Oracle 11g1/PHP 5.2.6/ and MySQL connection down...I can 
email working code.

When I run :
?php
// Server in the this format: computer\instance name or 
// server,port when using a non default port number
$server = 'LANDON\SQLEXPRESS';

$link = mssql_connect($server, 'sa', 'K^a_t^e_a_u_x_3141');

if(!$link)
{
die('Something went wrong while connecting to MSSQL');
}
?

I get

Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: 
LANDON\SQLEXPRESS in C:\Inetpub\wwwroot\trymssql.php on line 6
Something went wrong while connecting to MSSQL

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Re: MS SQL error...I've come a long way to get this far

RE: [PHP-DB] Re: MS SQL error...I've come a long way to get this far

RE: [PHP-DB] Re: MS SQL error...I've come a long way to get this far

RE: [PHP-DB] Re: MS SQL error...I've come a long way to get this far

[PHP-DB] Re: MS SQL error...I've come a long way to get this far

RE: [PHP-DB] Re: MS SQL error...I've come a long way to get this far

RE: [PHP-DB] Re: MS SQL error...I've come a long way to get this far

7 matches

Site Navigation

Mail list logo

Footer information