Change Database Context – MSSQL

Change Database Context – MSSQL

If you use the connection “MSSQL Server” and it shows you an error called “Changed database context to 'database name' ” it's because of the MSSQL Server driver which is available from PHP, because it isn't updated frequently. So, when in this driver is used a different schema, this error message is showed. Also, the SRV and SRV PDO drivers are frequently updated.

 

 

To solve this issue, you should use the “MSSQL Server Native SRV PDO” connection and, to do it, it's necessary to install the ODBC driver which is correct to your system architecture.

Link to ODBC's driver installation:

ODBC Driver 11 64 bits

ODBC Driver 11 32 bits

    • Related Articles

    • Connection with MSSQL Database

      Scriptcase has 3types of connections that can be used to communicate with Database MSSQL Server. - MSSQL Server Native SRV PDO - MSSQL Server Native SRV - MSSQL Server ODBC 1. Connection ODBC (MSSQL Server ODBC)  This connection may be used on the ...

    • Change user "admin" permissions

      Many times it happens that we modify the permissions of the admin user, and when wanting to verify some configurations or when wanting to modify some characteristics of the ScriptCase we can not have access since the permissions were changed. So what ...

    • MSSQL Server Connection - Scriptcase - Mac OS X

      Currently we must set up the connection to SQL Server on computers running Mac OS X according to the steps below: Step 1 - We should access the connection setup, in this case MSSQL Server Click on "Set FreeTDS". Step 2 - We must set the data to ...

    • Using the Database Builder

      The DataBase Builder is a Scriptcase 'DBMS' (Database Manager System), this tool allows you to create tables, modify the structure of your tables, generate ER diagrams (Entity x Relationships), perform the export of the tables among other things. ...

    • How to change the log module table

      After creating the Scriptcase log module, it is possible to change the table. When making this change, a new table will be created from scratch with no records. The records in the previous table must be migrated to your database. How to edit log ...