Connecting Tech Pros Worldwide Help | Site Map
 
 
LinkBack Thread Tools Search this Thread
  #1  
Old November 22nd, 2005, 12:05 AM
David Haynes
Guest
 
Posts: n/a
Default Example of mssql_connect that works with SQL Server 2005?

I can't seem to get the magic to work to connect to SQL Server via
mssql_connect(). I can get odbc_connect to work just fine, but not
mssql_connect. Could someone please post an example of how the hostname
field should be set up?

The SQL Server is on the same system as my php session.

Obviously, I am missing something because mssql_connect('localhost', '',
'') comes back with 'connection refused'.

-david-




  #2  
Old November 22nd, 2005, 12:05 AM
Chung Leong
Guest
 
Posts: n/a
Default Re: Example of mssql_connect that works with SQL Server 2005?

Try setting mssql.secure_connection in php.ini to on.

  #3  
Old November 22nd, 2005, 12:05 AM
David Haynes
Guest
 
Posts: n/a
Default Re: Example of mssql_connect that works with SQL Server 2005?

Chung Leong wrote:[color=blue]
> Try setting mssql.secure_connection in php.ini to on.
>[/color]
Thanks for the suggestion but, unfortunately, it made no difference.

-david-

 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 205,414 network members.