Welcome Guest, Not a member yet? Register   Sign In
CodeIgniter Forums CodeIgniter 4 CodeIgniter 4 Support connection SQL Server
connection SQL Server
  • Offline Engenharia 2
    Newbie
  • *
  • Posts: 3
    Threads: 1
    Joined: Mar 2022
    Reputation: 0
#1
03-24-2022, 01:47 PM
(This post was last modified: 03-25-2022, 04:53 AM by Engenharia 2.)

I have a problem connecting to the server  SQL SERVER, with pdo and without codeigniter it works perfectly but when we use codeigniter version4.1.9 the error: Main connection [SQLSRV]: Login timeout expired TCP Provider: Error code 0x2749 appers.
Database SQL Server version 2012 ODBC version 17
Php version 7.4.3
Codeigniter 4.1.9
Reply
  • Offline snelledre
    Junior Member
  • **
  • Posts: 38
    Threads: 10
    Joined: Jun 2018
    Reputation: 2
#2
03-26-2022, 12:45 AM

(03-24-2022, 01:47 PM)Engenharia 2 Wrote: I have a problem connecting to the server  SQL SERVER, with pdo and without codeigniter it works perfectly but when we use codeigniter version4.1.9 the error: Main connection [SQLSRV]: Login timeout expired TCP Provider: Error code 0x2749 appers.
Database SQL Server version 2012 ODBC version 17
Php version 7.4.3
Codeigniter 4.1.9
I have no problems to connect to a mssqlserver the free one.
I use the settings as below:

database.default.hostname = 192.36.247.5\SQLEXPRESS   You see I use the direct ip-adres of the server
database.default.database = Your database name
database.default.username = your username
database.default.password = your password
database.default.DBDriver = SQLSRV
database.default.port = 1433
database.default.DBPrefix =
Reply
  • Offline Engenharia 2
    Newbie
  • *
  • Posts: 3
    Threads: 1
    Joined: Mar 2022
    Reputation: 0
#3
Photo  03-29-2022, 12:03 PM

My connection is as shown in the image. with the same data I normally connect to the database through heidiSQL
[Image: error2.png?1648580379][Image: error.png?1648580568]
Reply
  • Offline snelledre
    Junior Member
  • **
  • Posts: 38
    Threads: 10
    Joined: Jun 2018
    Reputation: 2
#4
03-30-2022, 05:19 AM

(03-29-2022, 12:03 PM)Engenharia 2 Wrote: My connection is as shown in the image. with the same data I normally connect to the database through heidiSQL
[Image: error2.png?1648580379][Image: error.png?1648580568]

Why do you use port: 391?
Standard MsSqlserver uses port: 1433
Reply
  • Offline Engenharia 2
    Newbie
  • *
  • Posts: 3
    Threads: 1
    Joined: Mar 2022
    Reputation: 0
#5
03-30-2022, 01:30 PM

the port used in my database is 391, so it is 391
Reply




Theme © iAndrew 2016 - Forum software by © MyBB