Connecting with odbc18 and multisubnetfailover

General discussion of Mantis.

Moderators: Developer, Contributor

Post Reply
Phroobar
Posts: 34
Joined: 13 Dec 2022, 16:14

Connecting with odbc18 and multisubnetfailover

Post by Phroobar »

At my office we use Mantis to track business related issues. We have moved the database to MSSQL 2019. We are currently getting [microsoft][odbc driver 13]Login timeout expired. I need Mantis to use ODBC18 with multisubnetfailover=YES. What do I need to do to make this happen. I am not a PHP developer.
FireDervil
Posts: 2
Joined: 21 May 2023, 16:19

Re: Connecting with odbc18 and multisubnetfailover

Post by FireDervil »

maybe it will help you when you update the adodb driver to latest version :) from https://adodb.org/dokuwiki/doku.php?id=index

just delete everything in your folder: mantis->vendor->adodb->adodb-php an copy the content rom the extractet zip file in the folder.


hope that´s help.
Phroobar
Posts: 34
Joined: 13 Dec 2022, 16:14

Re: Connecting with odbc18 and multisubnetfailover

Post by Phroobar »

We have the latest Mantis release with no modifications. Wouldn't that include the latest ADOdb? For some reason it only selects ODBC13 and not ODBC18 when we choose sqlnative.
Phroobar
Posts: 34
Joined: 13 Dec 2022, 16:14

Re: Connecting with odbc18 and multisubnetfailover

Post by Phroobar »

I added the latest driver from adodb per instructions. We are still seeing the same timeout and ODBC13. Is there some configuration that needs to be made?
Phroobar
Posts: 34
Joined: 13 Dec 2022, 16:14

Re: Connecting with odbc18 and multisubnetfailover

Post by Phroobar »

is there a way to add multisubnetfailover=yes to the connection string?
shadymorais
Posts: 2
Joined: 21 Mar 2023, 15:18

Re: Connecting with odbc18 and multisubnetfailover

Post by shadymorais »

Phroobar wrote: 27 Sep 2023, 23:04 is there a way to add multisubnetfailover=yes to the connection string?
Did you ever figured our a way to do this?
Post Reply