Okay
  Public Ticket #2474692
mssql connection
Closed

Comments

  • Vedant Saraf started the conversation

    sir , 

    When i tried to connect to a sql database located on my own server .

    I found this problem (driver not found).

    Hope to hear from you soon !

  •  2,507
    Aleksandar replied

    Hello Vedant

    Can you please check if you have the following drivers installed, and activated?

    3255840116.png

    You don't really need "firebird", but the others need to be installed and activated in order to use external connections.

    These need to be installed on the server where your WordPress site resides.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  • Vedant Saraf replied

    Sir,

    plaese guide me how to install these drivers on my godaddy hosted wordpress website .

    Thanking You !

  •  2,507
    Aleksandar replied

    Hello Vedant

    That's not included in the provided support for the plugin, and if you don't know how to install the drivers on your server, you should reach out to your hosting provider and ask them to do this for you.

    I can only give you advice for the Linux server, so if you have that, you can run these commands:

    sudo apt-get install php7.0-odbcsudo apt-get install php7.2-odbcsudo apt-get install php7.3-odbcsudo apt-get install php7.4-odbcsudo phpenmod pdo_odbcsudo service apache2 restartsudo apt-get install php7.0-mysqlsudo apt-get install php7.2-mysqlsudo apt-get install php7.3-mysqlsudo apt-get install php7.4-mysqlsudo phpenmod pdo_mysqlsudo wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add - sudo add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-preview.list)" sudo apt-get updatesudo apt-get install mssql-server -ysudo service apache2 restartsudo apt-get install -y php7.0-pdo-dblibsudo apt-get install -y php7.2-pdo-dblibsudo apt-get install -y php7.3-pdo-dblibsudo apt-get install -y php7.4-pdo-dblibsudo phpenmod pdo_dblibsudo service apache2 restartsudo apt-get install php7.0-pgsqlsudo apt-get install php7.2-pgsqlsudo apt-get install php7.3-pgsqlsudo apt-get install php7.4-pgsqlsudo phpenmod pdo_pgsqlsudo service apache2 restartsudo apt-get install php7.0-sqlitesudo apt-get install php7.2-sqlitesudo apt-get install php7.3-sqlitesudo apt-get install php7.4-sqlitesudo phpenmod pdo_sqlitesudo service apache2 restartsudo apt-get install -y php7.0-pdo-firebirdsudo apt-get install -y php7.2-pdo-firebirdsudo apt-get install -y php7.3-pdo-firebirdsudo apt-get install -y php7.4-pdo-firebirdsudo phpenmod pdo_firebirdsudo service apache2 restart

    Versions depend on the PHP versions you have on the server.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables