SQLServer

In the current version, access to SQLServer is performed by setting up an ADO connection. Before you can, you must install a 64 bits ODBC/ADO driver that you must download from Microsoft.

In the above sample, we have installed the database on the local development system. This is why the servername, is actually the pc name and database server. The DSN Name is only a placeholder, for the PDO string you must use the Driver name. The installed drivers are populated by PHsPeed, so that you select the correct one from a drop-down list.

Then you can set up the SQLServer connection (for versions before 2.0):

In the case of ADO/ODBC, you must set a datatype mapping to translate ODBC datatypes into SQL datatypes. Depending on the database, you might need to change the port, user id and password. After setting these, use the test/show databases to verify the connection. If all goes well, then you are able to select the database and database schema.

Since version 2.0 PHsPeed does not use the odbc connection any more. To setup the new connection use:

Notice that you do NOT need to setup a port, in fact this will lead to a connect error, unless you have modified the PDO string (see below)..

PDO String

If you select SQLServer, then the PDO string will show. You need to select the ODBC driver in the final column. You can select it from a drop down if you have set the connection ok.

Before version 2.0 and some production environments:

sqlsrv:server={%host%},{%port%};Database={%dbname%};ConnectionPooling=0

After version 2.0 (modify the setting by hand:)

sqlsrv:server={%host%};Database={%dbname%};ConnectionPooling=0