Different messages while connecting to MSSQL Server - El Forum - 01-27-2010
[eluser]FutureKing[/eluser]
When I try to connect to MSSQL Server I am getting following message :
Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: GEEK-PC\SQLSERVER in G:\websites\localhost\test.php on line 7
But if I run the same script via command line I get this message:
Fatel Error: Call to undefined function mssql_connect() in .....
two different messages for same script? Why am I not able to connect to sql server.
SQL Server Version: 2005
OS : Windows
Server WAMP Server
PHP 5.2
Code:
Code: $server = 'GEEK-PC\SQLSERVER';
$link = mssql_connect($server, 'username', 'password');
if (!$link) {
die('Something went wrong while connecting to MSSQL');
}else{
echo "connected";
}
phpinfo is showing that MSSQL extension for php is active.
Different messages while connecting to MSSQL Server - El Forum - 01-27-2010
[eluser]rogierb[/eluser]
command line = PHP CLI
Script = PHP CGI
They might be compiled differently.
Different messages while connecting to MSSQL Server - El Forum - 01-27-2010
[eluser]FutureKing[/eluser]
[quote author="rogierb" date="1264627045"]command line = PHP CLI
Script = PHP CGI
They might be compiled differently.[/quote]
Okey. But why am I not able to connect to mssql?
Different messages while connecting to MSSQL Server - El Forum - 01-27-2010
[eluser]FutureKing[/eluser]
sqlsrv_connect is also not working. If I run from browser then I get die message, i.e. die('Something went wrong while connecting to MSSQL');
If I run from command line I get:
Fatal error: Call to undefined function sqlsrv_connect() in....
Different messages while connecting to MSSQL Server - El Forum - 01-27-2010
[eluser]FutureKing[/eluser]
Okey. Now I am able to connect to MSSQL using sqlsrv_connect(). But I have to run this script from command line. And sqlsrv_connect is working only on browser not via commandline.
I am still getting this error:
Code: Fatal error: Call to undefined function sqlsrv_connect() in..
in command line
Different messages while connecting to MSSQL Server - El Forum - 01-27-2010
[eluser]FutureKing[/eluser]
I run command php -i
And got the following output:
Code: phpinfo()
PHP Version => 5.2.9-2
System => Windows NT GEEK-PC 5.1 build 2600
Build Date => Apr 9 2009 08:22:37
Configure Command => cscript /nologo configure.js "--enable-snapshot-build" "--enable-debug-pack" "--with-snapshot-template=d:\php-sdk\snap_5_2\vc6\x
e" "--with-php-build=d:\php-sdk\snap_5_2\vc6\x86\php_build" "--with-pdo-oci=D:\php-sdk\oracle\instantclient10\sdk,shared" "--with-oci8=D:\php-sdk\orac
client10\sdk,shared"
Server API => Command Line Interface
Virtual Directory Support => enabled
Configuration File (php.ini) Path => C:\WINDOWS
Loaded Configuration File => G:\websites\wamp\bin\php\php5.2.9-2\php.ini
Scan this dir for additional .ini files => (none)
additional .ini files parsed => (none)
PHP API => 20041225
PHP Extension => 20060613
Zend Extension => 220060519
Debug Build => no
Thread Safety => enabled
Zend Memory Manager => enabled
IPv6 Support => enabled
Registered PHP Streams => php, file, data, http, ftp, compress.zlib
Registered Stream Socket Transports => tcp, udp
Registered Stream Filters => convert.iconv.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, zlib.*
This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.2.0, Copyright (c) 1998-2009 Zend Technologies
_______________________________________________________________________
Configuration
PHP Core
Directive => Local Value => Master Value
allow_call_time_pass_reference => Off => Off
allow_url_fopen => On => On
allow_url_include => Off => Off
always_populate_raw_post_data => Off => Off
arg_separator.input => & => &
arg_separator.output => & => &
asp_tags => Off => Off
auto_append_file => no value => no value
auto_globals_jit => On => On
auto_prepend_file => no value => no value
browscap => no value => no value
default_charset => no value => no value
default_mimetype => text/html => text/html
define_syslog_variables => Off => Off
disable_classes => no value => no value
disable_functions => no value => no value
display_errors => STDOUT => STDOUT
display_startup_errors => Off => Off
doc_root => no value => no value
docref_ext => no value => no value
docref_root => no value => no value
enable_dl => On => On
error_append_string => no value => no value
error_log => g:/websites/wamp/logs/php_error.log => g:/websites/wamp/logs/php_error.log
error_prepend_string => no value => no value
error_reporting => 6143 => 6143
expose_php => On => On
extension_dir => g:/websites/wamp/bin/php/php5.2.9-2/ext/ => g:/websites/wamp/bin/php/php5.2.9-2/ext/
file_uploads => On => On
highlight.bg => <font style="color: #FFFFFF">#FFFFFF</font> => <font style="color: #FFFFFF">#FFFFFF</font>
highlight.comment => <font style="color: #FF8000">#FF8000</font> => <font style="color: #FF8000">#FF8000</font>
highlight.default => <font style="color: #0000BB">#0000BB</font> => <font style="color: #0000BB">#0000BB</font>
highlight.html => <font style="color: #000000">#000000</font> => <font style="color: #000000">#000000</font>
highlight.keyword => <font style="color: #007700">#007700</font> => <font style="color: #007700">#007700</font>
highlight.string => <font style="color: #DD0000">#DD0000</font> => <font style="color: #DD0000">#DD0000</font>
html_errors => Off => Off
ignore_repeated_errors => Off => Off
ignore_repeated_source => Off => Off
ignore_user_abort => Off => Off
implicit_flush => On => On
include_path => .;C:\php5\pear => .;C:\php5\pear
log_errors => On => On
log_errors_max_len => 1024 => 1024
magic_quotes_gpc => Off => Off
magic_quotes_runtime => Off => Off
magic_quotes_sybase => Off => Off
mail.force_extra_parameters => no value => no value
max_execution_time => 0 => 0
max_input_nesting_level => 64 => 64
max_input_time => -1 => -1
memory_limit => 128M => 128M
open_basedir => no value => no value
output_buffering => 0 => 0
output_handler => no value => no value
post_max_size => 8M => 8M
precision => 14 => 14
realpath_cache_size => 16K => 16K
realpath_cache_ttl => 120 => 120
register_argc_argv => On => On
register_globals => Off => Off
register_long_arrays => Off => Off
report_memleaks => On => On
report_zend_debug => Off => Off
safe_mode => Off => Off
safe_mode_exec_dir => no value => no value
safe_mode_gid => Off => Off
safe_mode_include_dir => no value => no value
sendmail_from => admin@localhost => admin@localhost
sendmail_path => no value => no value
serialize_precision => 100 => 100
short_open_tag => Off => Off
SMTP => localhost => localhost
smtp_port => 25 => 25
sql.safe_mode => Off => Off
track_errors => Off => Off
unserialize_callback_func => no value => no value
upload_max_filesize => 2M => 2M
upload_tmp_dir => g:/websites/wamp/tmp => g:/websites/wamp/tmp
user_dir => no value => no value
variables_order => GPCS => GPCS
xmlrpc_error_number => 0 => 0
xmlrpc_errors => Off => Off
y2k_compliance => On => On
zend.ze1_compatibility_mode => Off => Off
bcmath
BCMath support => enabled
calendar
Calendar support => enabled
com_dotnet
COM support => enabled
DCOM support => disabled
.Net support => enabled
Directive => Local Value => Master Value
com.allow_dcom => 0 => 0
com.autoregister_casesensitive => 1 => 1
com.autoregister_typelib => 0 => 0
com.autoregister_verbose => 0 => 0
com.code_page => no value => no value
com.typelib_file => no value => no value
ctype
ctype functions => enabled
date
date/time support => enabled
"Olson" Timezone Database Version => 2009.1
Timezone Database => internal
Default timezone => UTC
Directive => Local Value => Master Value
date.default_latitude => 31.7667 => 31.7667
date.default_longitude => 35.2333 => 35.2333
date.sunrise_zenith => 90.583333 => 90.583333
date.sunset_zenith => 90.583333 => 90.583333
date.timezone => no value => no value
Different messages while connecting to MSSQL Server - El Forum - 01-27-2010
[eluser]FutureKing[/eluser]
Code: dom
DOM/XML => enabled
DOM/XML API Version => 20031129
libxml Version => 2.7.3
HTML Support => enabled
XPath Support => enabled
XPointer Support => enabled
Schema Support => enabled
RelaxNG Support => enabled
filter
Input Validation and Filtering => enabled
Revision => $Revision: 1.52.2.45 $
Directive => Local Value => Master Value
filter.default => unsafe_raw => unsafe_raw
filter.default_flags => no value => no value
ftp
FTP support => enabled
gd
GD Support => enabled
GD Version => bundled (2.0.34 compatible)
FreeType Support => enabled
FreeType Linkage => with freetype
FreeType Version => 2.1.9
T1Lib Support => enabled
GIF Read Support => enabled
GIF Create Support => enabled
JPG Support => enabled
PNG Support => enabled
WBMP Support => enabled
XBM Support => enabled
hash
hash support => enabled
Hashing Engines => md2 md4 md5 sha1 sha256 sha384 sha512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4
4 tiger192,4 snefru gost adler32 crc32 crc32b haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval
l128,5 haval160,5 haval192,5 haval224,5 haval256,5
iconv
iconv support => enabled
iconv implementation => "libiconv"
iconv library version => 1.11
Directive => Local Value => Master Value
iconv.input_encoding => ISO-8859-1 => ISO-8859-1
iconv.internal_encoding => ISO-8859-1 => ISO-8859-1
iconv.output_encoding => ISO-8859-1 => ISO-8859-1
json
json support => enabled
json version => 1.2.1
libxml
libXML support => active
libXML Version => 2.7.3
libXML streams => enabled
mbstring
Multibyte Support => enabled
Multibyte string engine => libmbfl
Multibyte (japanese) regex support => enabled
Multibyte regex (oniguruma) version => 4.4.4
Multibyte regex (oniguruma) backtrack check => On
mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version
Directive => Local Value => Master Value
mbstring.detect_order => no value => no value
mbstring.encoding_translation => Off => Off
mbstring.func_overload => 0 => 0
mbstring.http_input => pass => pass
mbstring.http_output => pass => pass
mbstring.internal_encoding => no value => no value
mbstring.language => neutral => neutral
mbstring.strict_detection => Off => Off
mbstring.substitute_character => no value => no value
mysql
MySQL Support => enabled
Active Persistent Links => 0
Active Links => 0
Client API version => 5.0.51a
Directive => Local Value => Master Value
mysql.allow_persistent => On => On
mysql.connect_timeout => 60 => 60
mysql.default_host => no value => no value
mysql.default_password => no value => no value
mysql.default_port => no value => no value
mysql.default_socket => no value => no value
mysql.default_user => no value => no value
mysql.max_links => Unlimited => Unlimited
mysql.max_persistent => Unlimited => Unlimited
mysql.trace_mode => Off => Off
mysqli
MysqlI Support => enabled
Client API library version => 5.0.51a
Client API header version => 5.0.51a
MYSQLI_SOCKET => /tmp/mysql.sock
Directive => Local Value => Master Value
mysqli.default_host => no value => no value
mysqli.default_port => 3306 => 3306
mysqli.default_pw => no value => no value
mysqli.default_socket => no value => no value
mysqli.default_user => no value => no value
mysqli.max_links => Unlimited => Unlimited
mysqli.reconnect => Off => Off
odbc
ODBC Support => enabled
Active Persistent Links => 0
Active Links => 0
ODBC library => Win32
Directive => Local Value => Master Value
odbc.allow_persistent => On => On
odbc.check_persistent => On => On
odbc.default_cursortype => Static cursor => Static cursor
odbc.default_db => no value => no value
odbc.default_pw => no value => no value
odbc.default_user => no value => no value
odbc.defaultbinmode => return as is => return as is
odbc.defaultlrl => return up to 4096 bytes => return up to 4096 bytes
odbc.max_links => Unlimited => Unlimited
odbc.max_persistent => Unlimited => Unlimited
pcre
PCRE (Perl Compatible Regular Expressions) Support => enabled
PCRE Library Version => 7.8 2008-09-05
Directive => Local Value => Master Value
pcre.backtrack_limit => 100000 => 100000
pcre.recursion_limit => 100000 => 100000
PDO
PDO support => enabled
PDO drivers => mysql, sqlite
pdo_mysql
PDO Driver for MySQL, client library version => 5.0.51a
pdo_sqlite
PDO Driver for SQLite 3.x => enabled
PECL Module version => 1.0.1 $Id: pdo_sqlite.c,v 1.10.2.6.2.4 2008/12/31 11:17:42 sebastian Exp $
SQLite Library => 3.3.7undefined
Reflection
Reflection => enabled
Version => $Id: php_reflection.c,v 1.164.2.33.2.55 2008/12/31 11:17:42 sebastian Exp $
session
Session Support => enabled
Registered save handlers => files user
Registered serializer handlers => php php_binary wddx
Directive => Local Value => Master Value
session.auto_start => Off => Off
session.bug_compat_42 => Off => Off
session.bug_compat_warn => On => On
session.cache_expire => 180 => 180
session.cache_limiter => nocache => nocache
session.cookie_domain => no value => no value
session.cookie_httponly => Off => Off
session.cookie_lifetime => 0 => 0
session.cookie_path => / => /
session.cookie_secure => Off => Off
session.entropy_file => no value => no value
session.entropy_length => 0 => 0
session.gc_divisor => 1000 => 1000
session.gc_maxlifetime => 1440 => 1440
session.gc_probability => 1 => 1
session.hash_bits_per_character => 5 => 5
session.hash_function => 0 => 0
session.name => PHPSESSID => PHPSESSID
session.referer_check => no value => no value
session.save_handler => files => files
session.save_path => g:/websites/wamp/tmp => g:/websites/wamp/tmp
session.serialize_handler => php => php
session.use_cookies => On => On
session.use_only_cookies => Off => Off
session.use_trans_sid => 0 => 0
SimpleXML
Simplexml support => enabled
Revision => $Revision: 1.151.2.22.2.46 $
Schema support => enabled
Different messages while connecting to MSSQL Server - El Forum - 01-27-2010
[eluser]FutureKing[/eluser]
Code: SPL
SPL support => enabled
Interfaces => Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject
Classes => AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, DirectoryIterator, DomainExc
ptyIterator, FilterIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, NoRewindIte
OfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, Recursive
terator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RegexIterator, RuntimeException, SimpleXMLIterator, SplFileInfo,
ect, SplObjectStorage, SplTempFileObject, UnderflowException, UnexpectedValueException
standard
Regex Library => Bundled library enabled
Dynamic Library Support => enabled
Internal Sendmail Support for Windows => enabled
Directive => Local Value => Master Value
assert.active => 1 => 1
assert.bail => 0 => 0
assert.callback => no value => no value
assert.quiet_eval => 0 => 0
assert.warning => 1 => 1
auto_detect_line_endings => 0 => 0
default_socket_timeout => 60 => 60
safe_mode_allowed_env_vars => PHP_ => PHP_
safe_mode_protected_env_vars => LD_LIBRARY_PATH => LD_LIBRARY_PATH
url_rewriter.tags => a=href,area=href,frame=src,input=src,form=fakeentry => a=href,area=href,frame=src,input=src,form=fakeentry
user_agent => no value => no value
tokenizer
Tokenizer Support => enabled
wddx
WDDX Support => enabled
WDDX Session Serializer => enabled
xml
XML Support => active
XML Namespace Support => active
libxml2 Version => 2.7.3
xmlreader
XMLReader => enabled
xmlwriter
XMLWriter => enabled
zlib
ZLib Support => enabled
Stream Wrapper support => compress.zlib://
Stream Filter support => zlib.inflate, zlib.deflate
Compiled Version => 1.2.3
Linked Version => 1.2.3
Directive => Local Value => Master Value
zlib.output_compression => Off => Off
zlib.output_compression_level => -1 => -1
zlib.output_handler => no value => no value
Additional Modules
Module Name
Different messages while connecting to MSSQL Server - El Forum - 01-27-2010
[eluser]FutureKing[/eluser]
Code: Environment
Variable => Value
ALLUSERSPROFILE => C:\Documents and Settings\All Users
APPDATA => C:\Documents and Settings\Geek\Application Data
CLASSPATH => .;C:\Program Files\Java\jre6\lib\ext\QTJava.zip
CLIENTNAME => Console
CommonProgramFiles => C:\Program Files\Common Files
COMPUTERNAME => GeekGUPTA-PC
ComSpec => C:\WINDOWS\system32\cmd.exe
FP_NO_HOST_CHECK => NO
HOMEDRIVE => C:
HOMEPATH => \Documents and Settings\Geek
lib => C:\Program Files\SQLXML 4.0\bin\
LOGONSERVER => \\GeekGUPTA-PC
NUMBER_OF_PROCESSORS => 1
OS => Windows_NT
Path => C:\Program Files\PC Connectivity Solution\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Microsoft SQL Server\80\To
C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\Microsoft SQL Server\90\DTS\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools
ell\Common7\IDE\;C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\;C:\Program Files\QuickTime\QTSystem\;C:\Program Files\Micro
erver\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;G:\websites\wamp\bin\mysql\mysql5.1.36\bin\bin;G:\websites\wamp\bin\php\php5
PATHEXT => .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE => x86
PROCESSOR_IDENTIFIER => x86 Family 15 Model 4 Stepping 1, GenuineIntel
PROCESSOR_LEVEL => 15
PROCESSOR_REVISION => 0401
ProgramFiles => C:\Program Files
PROMPT => $P$G
QTJAVA => C:\Program Files\Java\jre6\lib\ext\QTJava.zip
SESSIONNAME => Console
SystemDrive => C:
SystemRoot => C:\WINDOWS
TEMP => C:\DOCUME~1\GeekG~1\LOCALS~1\Temp
TMP => C:\DOCUME~1\GeekG~1\LOCALS~1\Temp
tvdumpflags => 8
USERDOMAIN => GeekGUPTA-PC
USERNAME => Geek
USERPROFILE => C:\Documents and Settings\Geek
VS100COMNTOOLS => E:\Program Files\Microsoft Visual Studio 10.0\Common7\Tools\
VS90COMNTOOLS => C:\Program Files\Microsoft Visual Studio 9.0\Common7\Tools\
windir => C:\WINDOWS
__COMPAT_LAYER => EnableNXShowUI
PHP Variables
Variable => Value
_SERVER["ALLUSERSPROFILE"] => C:\Documents and Settings\All Users
_SERVER["APPDATA"] => C:\Documents and Settings\Geek\Application Data
_SERVER["CLASSPATH"] => .;C:\Program Files\Java\jre6\lib\ext\QTJava.zip
_SERVER["CLIENTNAME"] => Console
_SERVER["CommonProgramFiles"] => C:\Program Files\Common Files
_SERVER["COMPUTERNAME"] => GeekGUPTA-PC
_SERVER["ComSpec"] => C:\WINDOWS\system32\cmd.exe
_SERVER["FP_NO_HOST_CHECK"] => NO
_SERVER["HOMEDRIVE"] => C:
_SERVER["HOMEPATH"] => \Documents and Settings\Geek
_SERVER["lib"] => C:\Program Files\SQLXML 4.0\bin\
_SERVER["LOGONSERVER"] => \\GeekGUPTA-PC
_SERVER["NUMBER_OF_PROCESSORS"] => 1
_SERVER["OS"] => Windows_NT
_SERVER["Path"] => C:\Program Files\PC Connectivity Solution\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Microsoft SQL S
ools\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\Microsoft SQL Server\90\DTS\Binn\;C:\Program Files\Microsoft SQL Serv
s\Binn\VSShell\Common7\IDE\;C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\;C:\Program Files\QuickTime\QTSystem\;C:\Program
osoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;G:\websites\wamp\bin\mysql\mysql5.1.36\bin\bin;G:\websites\wamp\b
5.2.9-2
_SERVER["PATHEXT"] => .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
_SERVER["PROCESSOR_ARCHITECTURE"] => x86
_SERVER["PROCESSOR_IDENTIFIER"] => x86 Family 15 Model 4 Stepping 1, GenuineIntel
_SERVER["PROCESSOR_LEVEL"] => 15
_SERVER["PROCESSOR_REVISION"] => 0401
_SERVER["ProgramFiles"] => C:\Program Files
_SERVER["PROMPT"] => $P$G
_SERVER["QTJAVA"] => C:\Program Files\Java\jre6\lib\ext\QTJava.zip
_SERVER["SESSIONNAME"] => Console
_SERVER["SystemDrive"] => C:
_SERVER["SystemRoot"] => C:\WINDOWS
_SERVER["TEMP"] => C:\DOCUME~1\GeekG~1\LOCALS~1\Temp
_SERVER["TMP"] => C:\DOCUME~1\GeekG~1\LOCALS~1\Temp
_SERVER["tvdumpflags"] => 8
_SERVER["USERDOMAIN"] => GeekGUPTA-PC
_SERVER["USERNAME"] => Geek
_SERVER["USERPROFILE"] => C:\Documents and Settings\Geek
_SERVER["VS100COMNTOOLS"] => E:\Program Files\Microsoft Visual Studio 10.0\Common7\Tools\
_SERVER["VS90COMNTOOLS"] => C:\Program Files\Microsoft Visual Studio 9.0\Common7\Tools\
_SERVER["windir"] => C:\WINDOWS
_SERVER["__COMPAT_LAYER"] => EnableNXShowUI
_SERVER["PHP_SELF"] =>
_SERVER["SCRIPT_NAME"] =>
_SERVER["SCRIPT_FILENAME"] =>
_SERVER["PATH_TRANSLATED"] =>
_SERVER["DOCUMENT_ROOT"] =>
_SERVER["REQUEST_TIME"] => 1264607333
_SERVER["argv"] => Array
(
)
_SERVER["argc"] => 0
Different messages while connecting to MSSQL Server - El Forum - 01-27-2010
[eluser]FutureKing[/eluser]
The above PHP information I got from command line. As you can see there is no Sqlsrv extension.
But if I run a file contains "phpinfo function" from my web broweser I get this info:
sqlsrv
sqlsrv support enabled
Directive Local Value Master Value
sqlsrv.LogSeverity 0 0
sqlsrv.LogSubsystems 0 0
sqlsrv.WarningsReturnAsErrors On On
I think php command line is not loading sqlsrv extension. Can you help me to load sqlsrv extension in commandline php.
|