Solo usuarios registrados pueden comentar y agradecer, Logueate o Registrate

Autor Topic: MSSQL extension  (Visto 815 veces)

0 Miembros and 1 Guest are viewing this topic.

Offline Wikko0 Posteado: November 26, 2021, 10:39:12 AM

  • 0 puntos por ventas
  • *
  • Rank: Usuario activo
  • Posts: 60
  • Gracias recibida: 364
  • bg
Hello! I try to install CMN CMS but i get error:
Citar
You are missing mssql extension. Please select different or enable this in your php settings.
when i try to use MSSQL for option. When i try to use pdo sqlsrv i get error:
Citar
SQLSTATE[08001]: [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: No connection could be made because the target machine actively refused it.


I use php 7.4 with xampp.
In php.ini i put this -


Where is problem

Discord: Wikko0#8525

Gracias:


Offline Gaboo; #1 Posteado: November 26, 2021, 12:23:22 PM

  • 0 puntos por ventas
  • *
  • Rank: Puto amo
  • Posts: 1.415
  • Gracias recibida: 2357
  • ve
Good afternoon, to work with xamp you must use the ODBC or SqlSrv eextension, remember to enable the SQL Server extension 1433.


Offline Wikko0 #2 Posteado: November 26, 2021, 12:38:04 PM

  • 0 puntos por ventas
  • *
  • Rank: Usuario activo
  • Posts: 60
  • Gracias recibida: 364
  • bg
I try to enable sql server extension but dont work. When i add extension=php_sqlsrv_74_ts_x64.dll in php.ini i have same error.

Discord: Wikko0#8525

Offline Gaboo; #3 Posteado: November 26, 2021, 12:41:55 PM

  • 0 puntos por ventas
  • *
  • Rank: Puto amo
  • Posts: 1.415
  • Gracias recibida: 2357
  • ve
I try to enable sql server extension but dont work. When i add extension=php_sqlsrv_74_ts_x64.dll in php.ini i have same error.

In the installation panel you must select pdo. ODBC or pdo.sqlsrv.


Offline Wikko0 #4 Posteado: November 26, 2021, 01:20:41 PM

  • 0 puntos por ventas
  • *
  • Rank: Usuario activo
  • Posts: 60
  • Gracias recibida: 364
  • bg
I get this error when i try use pdo.sqlsrv -> SQLSTATE[08001]: [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: No connection could be made because the target machine actively refused it.

Discord: Wikko0#8525

Offline Gaboo; #5 Posteado: November 26, 2021, 01:48:48 PM

  • 0 puntos por ventas
  • *
  • Rank: Puto amo
  • Posts: 1.415
  • Gracias recibida: 2357
  • ve
select pdo.odbc.


Offline Wikko0 #6 Posteado: November 26, 2021, 02:05:01 PM

  • 0 puntos por ventas
  • *
  • Rank: Usuario activo
  • Posts: 60
  • Gracias recibida: 364
  • bg
select pdo.odbc.
SQLSTATE[08001] SQLDriverConnect: 17 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

Discord: Wikko0#8525

Offline Gaboo; #7 Posteado: November 26, 2021, 03:31:47 PM

  • 0 puntos por ventas
  • *
  • Rank: Puto amo
  • Posts: 1.415
  • Gracias recibida: 2357
  • ve
check in SQL Configuration Manager, check port 1433 is open.


Offline Wikko0 #8 Posteado: November 26, 2021, 04:00:56 PM

  • 0 puntos por ventas
  • *
  • Rank: Usuario activo
  • Posts: 60
  • Gracias recibida: 364
  • bg
Thank.
Now i have new error :D

In database_error_log
Citar
      SET IDENTITY_INSERT [dbo].[DmN_Shopp] OFF
================================================================================
PDOException: SQLSTATE[HY000]: General error: 0 [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt (SQLExecute[0] at ext\pdo_odbc\odbc_stmt.c:259) in C:\xampp\htdocs\application\libraries\lib.db.php:98
Stack trace:
#0 C:\xampp\htdocs\application\libraries\lib.db.php(98): PDO->query('SET IDENTITY_IN...')
#1 C:\xampp\htdocs\setup\application\models\model.setup.php(367): db->query('SET IDENTITY_IN...')
#2 C:\xampp\htdocs\setup\application\controllers\controller.setup.php(429): Msetup->insert_sql_data('SET IDENTITY_IN...', 'web')
#3 C:\xampp\htdocs\system\router.class.php(80): setup->step8()
#4 C:\xampp\htdocs\setup\index.php(29): router->route(Object(request))
#5 {main}
================================================================================

Discord: Wikko0#8525

Online mu2020 #9 Posteado: November 27, 2021, 03:24:35 AM

  • 0 puntos por ventas
  • *
  • Rank: Principiante
  • Posts: 25
  • Gracias recibida: 2
  • cn
Does he not support working on W2008 system?


Offline Wikko0 #10 Posteado: November 27, 2021, 05:16:02 AM

  • 0 puntos por ventas
  • *
  • Rank: Usuario activo
  • Posts: 60
  • Gracias recibida: 364
  • bg
Does he not support working on W2008 system?
Im with Windows 10 and what is common?

Discord: Wikko0#8525

Offline Wikko0 #11 Posteado: November 28, 2021, 01:22:50 AM

  • 0 puntos por ventas
  • *
  • Rank: Usuario activo
  • Posts: 60
  • Gracias recibida: 364
  • bg
Discord: Wikko0#8525

Solo usuarios registrados pueden comentar y agradecer, Logueate o Registrate


 

Related Topics

  Subject / Started by Replies Last post
2 Replies
1435 Views
Last post May 18, 2017, 10:10:41 PM
by Azzlaer
2 Replies
1346 Views
Last post July 21, 2017, 05:13:12 PM
by chikitoxd
1 Replies
1171 Views
Last post May 21, 2018, 08:15:02 AM
by tgservice147
10 Replies
7259 Views
Last post April 20, 2019, 06:05:37 PM
by jeane
6 Replies
1547 Views
Last post May 13, 2020, 08:44:39 AM
by louis