Line 4: |
Line 4: |
| Adding support in SME Server for a universal connection to foreign datebase servers using Open Database Connectivity (ODBC) with focus on PHP. | | Adding support in SME Server for a universal connection to foreign datebase servers using Open Database Connectivity (ODBC) with focus on PHP. |
| | | |
− | We will assume that you have an Ms SQL Server 2000/2005 running somewhere. The SQL Server should allow remote access and support connections using TCP/IP. As of my knowledge, connections using named pipes are unsupported. Of course; you will want a login id and password. | + | We will assume that you have an Microsoft SQL Server 2000/2005 running somewhere. The SQL Server should allow remote access and support connections using TCP/IP. As of my knowledge, connections using named pipes are unsupported. Of course; you will want a login id and password. |
| | | |
| It should be similar with Sybase and other versions of SQL Server, consult FreeTDS and unixODBC documentation for details. | | It should be similar with Sybase and other versions of SQL Server, consult FreeTDS and unixODBC documentation for details. |
Line 140: |
Line 140: |
| | | |
| [FreeTDS] | | [FreeTDS] |
− | Description = Access Ms SQL Server with FreeTDS driver | + | Description = Access Microsoft SQL Server with FreeTDS driver |
| Driver = /usr/lib/libtdsodbc.so | | Driver = /usr/lib/libtdsodbc.so |
| | | |
Line 257: |
Line 257: |
| From SQL Server 2000 TDS version 8.0 should be used. Add the line <tds version = 8.0> in your template fragment for freetds.conf | | From SQL Server 2000 TDS version 8.0 should be used. Add the line <tds version = 8.0> in your template fragment for freetds.conf |
| | | |
− | Ms SQL Server might not allow the db system user "sa" to connect from outside the server, create another account with proper permissions.
| + | Microsoft SQL Server might not allow the db system user "sa" to connect from outside the server, create another account with proper permissions. |
| | | |
| Express edition have remote access disabled by default. Can be changed in the menu "Surface Area Configuration". [http://support.microsoft.com/kb/914277 More info here] | | Express edition have remote access disabled by default. Can be changed in the menu "Surface Area Configuration". [http://support.microsoft.com/kb/914277 More info here] |