206
edits
Changes
From SME Server
Jump to navigationJump to search
mLine 59:
Line 59: − + Line 135:
Line 135: − ====Check PHP configuration====+ Line 143:
Line 143: + + + + + + + + +
Added troubleshooting section
yum remove gcc}}
yum remove gcc}}
====Test # 1====
====Test #1====
TSQL is a database client included in FreeTDS package for testing and troubleshooting.
TSQL is a database client included in FreeTDS package for testing and troubleshooting.
Check compile settings:
Check compile settings:
expand-template /etc/odbc.ini
expand-template /etc/odbc.ini
===Check PHP===
phpinfo(), section Configure Command, outputs: --with-unixODBC=shared,/usr
phpinfo(), section Configure Command, outputs: --with-unixODBC=shared,/usr
There should also be a section "odbc".
There should also be a section "odbc".
=== Additional information ===
=== Additional information ===
[http://forums.contribs.org/index.php?topic=44185.0 Current forum discussion]
[http://forums.contribs.org/index.php?topic=44185.0 Current forum discussion]
FreeTDS [http://www.freetds.org/userguide/ user guide] with [http://www.freetds.org/userguide/troubleshooting.htm troubleshooting section].
[http://se2.php.net/manual/en/book.uodbc.php php.net ODBC]
[http://se2.php.net/manual/en/book.uodbc.php php.net ODBC]
Input from and credit to Nick Critten [http://bends.se/it/smeserver/filer/HowTo_NickCritten_freetds.html unofficial copy of his HowTo] and [http://www.calio.it/docs/doku.php/sqlserver calio.it] [http://translate.google.se/translate?u=http%3A%2F%2Fwww.calio.it%2Fdocs%2Fdoku.php%2Fsqlserver&sl=it&tl=en&hl=sv&ie=UTF-8 translated]
Input from and credit to Nick Critten [http://bends.se/it/smeserver/filer/HowTo_NickCritten_freetds.html unofficial copy of his HowTo] and [http://www.calio.it/docs/doku.php/sqlserver calio.it] [http://translate.google.se/translate?u=http%3A%2F%2Fwww.calio.it%2Fdocs%2Fdoku.php%2Fsqlserver&sl=it&tl=en&hl=sv&ie=UTF-8 translated]
===Troubleshooting===
Tab spaces in config files may cause troubles, use single space before and after =.
If your Ms SQL Server are using instances, add the line "instance = db_kalle" in your freetds.conf template fragment (replace db_kalle with the name of your instance).
----
----
[[Category:Howto]]
[[Category:Howto]]
