• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1281
  • Last Modified:

PHP 5 MSSQL 2005 Connection

I have install php 5.2.4 on my machine and apache 2.2.4 and it is working perfect exept that i can conect to the bd. i create a ODBCto cheeck if it was a problem with the configuration of my db but with the ODBC works pewrfect. but i dont want to use ODBC how can i set up the conection?

And one more quiestion why if i write this <? ......?>  it display the php on the screen and if i do this <?php ......?>  execute the code?

0
dentrita
Asked:
dentrita
  • 4
  • 2
1 Solution
 
gowniCommented:
Hi,

What database you are using? For the second part, for <? ?> to work you have to enable short_tags in php.ini file
0
 
dentritaAuthor Commented:
i am usung MSSQL 2005 db
0
 
gowniCommented:
Hi,
Can you paste your code here so that we can take a look
0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
dentritaAuthor Commented:
the php configuration file you can see it on this link http://felipeholguin.no-ip.info/phpinfo.php
is a old web site that i had and i want to chance the db to mssql2005 the code was working perfect with mssql2000
here is the line where i connect to the db
define ('DB_USER','XXXX');
define ('DB_PASSWORD','XXXXX');
define ('DB_HOST','XXXXXX');
define ('DB_NAME','XXXXX');

$dbconn = mssql_connect(DB_HOST,DB_USER,DB_PASSWORD) or die("Could not connect...");


thanks
0
 
dentritaAuthor Commented:
No clue anyone?
please help
0
 
dentritaAuthor Commented:
i already found the problem how can i get my points back

the answer is

ntwdblib.dll Version - On some systems the ntwdblib.dll version is too old to work correctly with PHP. If your version does not end in 80.194.0 it's probably too old. You can download the 80.194 version here.

http://www.userscape.com/helpdesk/index.php?pg=kb.page&id=13
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now