hello, I am using
WAMP on Windows7, PHP 5.5, Apache 2.4.9, Moodle on MySQL and trying to connect
to MSSQL, If I go to the external database plugin it shows me the connection is
well configured and names of the table in MSSQL; I will list everything I've
done and please if anyone can help or transfer the thread to development since
all over Moodle forum I find the same question and then no luck in connecting
or it connects but the steps are not specified.
I am not the PC administrator
The PC is on a network
No local antivirus or firewall shown
The MSSQL and MySQL are on the same PC
Localhost:8080
php_sqlsrv_55_ts
(extension installed, php.ini modified, right sign next to it in
wamp-php-extensions)
php_pdo_sqlsrv_55_ts (extension installed, php.ini modified,
right sign next to it in wamp-php-extensions)
sybase_ct
active (though I read it might need other dll dependencies, please anyone knows
them?)
ntwdblib.dll
added to php and apache though useless (wamp-php-extensions php_mssql shows a
red square)
phpdblib.dll
added with freetds.conf file located in C:\ (I'm using wamp shall it be located
elsewhere?) the file contains
[global]
host
= 127.0.0.1 #shall
I add an instance? how to do that please?
port
= 1433
client
charset = UTF-8
tds
version = 7.2 # tdsversion shall it be 8.0 and whats the difference?
text
size = 40971520
debug
level = 1
odbc.ini added to it
a line at the end tds_version = 7.2 (if freetds.conf modified to 8.0 this must
be modified as well?)
php.ini
added the extension of dblib and it has a right check in wamp-php-extensions;
The extensions that show
exclamation mark in php-extensions php-opcache, php_enchant are those necessary
for our case? (there are some extensions that are not "on" but
without exclamation mark so I guess those are ok)
Is
there any Apache module that needs to be added?
My
PHP info says without-mssql"
"--without-pdo-mssql"
PDO support
|
enabled
|
PDO
drivers
|
sqlsrv,
mysql, odbc, sqlite
|
pdo_sqlsrv
pdo_sqlsrv support
|
enabled
|
Directive
|
Local Value
|
Master Value
|
pdo_sqlsrv.client_buffer_max_kb_size
|
10240
|
10240
|
pdo_sqlsrv.log_severity
|
0
|
0
|
sqlsrv
Directive
|
Local Value
|
Master Value
|
sqlsrv.ClientBufferMaxKBSize
|
10240
|
10240
|
sqlsrv.LogSeverity
|
0
|
0
|
sqlsrv.LogSubsystems
|
0
|
0
|
sqlsrv.WarningsReturnAsErrors
|
On
|
On
|
Do
you think 10240 must be changed, do you think without-mssql"
"--without-pdo-mssql" (is a normal message?)
dblib is not
shown anwhere in php.info is that normal?
shall I add
• mssql.textlimit = 20971520
• mssql.textsize = 20971520 to php.ini although I am not using mssql? if not under what
name shall I put those in php.ini
is there anything
else that needs to be modified in php.ini such as mssql.secure_connection
= On?
I tried even to install
Moodle on MSSQL it reached the enter your admin credentials then gives an error
though the database is created (i followed step by step the documentation on
Moodle: IP, Port, collation, Ansi....)
I think its a
timeout error, security error or ODBC error, any suggestions?
A Colleague told
me about odbtp drive, I didn't know how to install it, anyone has any idea
baout that?
Sorry for all the
information above, but I thought maybe this issue lacks clarity, since its been
asked a lot and there is not much step by step and debugging info mentioned