Hi Eugenio
With some help from the people at the wampserver forum I was able to install the MS sqlserver drivers.
I am still getting errors for a missing "Ioncube" and also on the database connection parameters when I run:
[pre]
http://localhost/magnal/install.php
[/pre]
Here's the error output:
[pre]
Requirements check
Current PHP version: 7.3.12 OK
mbsgtring extension: Installed
ioncube extension: NOT Installed You can download it from here ioncube.com/loaders.php
Check DB connection: [06] Error: during database connection. Please check $host, $user, $pass and $db_name in your config.php
The DBMS server said: SQLSTATE[08001]: [Microsoft][ODBC Driver 13 for SQL Server]Named Pipes Provider: Could not open a connection to SQL Server [5].
( ! ) Notice: Undefined variable: conn in C:\wamp\www\magnal\include\db_functions_pdo.php on line 98
[/pre]
I'm surprised by the IONCUBE error since I copied the IONCUBE folder from their installation zip file just underneath the wamp www folder as shown
[pre]
C:\WAMP\WWW\IONCUBE
[/pre]
I also tried it under my application folder as shown here:
C:\WAMP\WWW\MAGNAL\IONCUBE
I don't understood the connection error since I can connect by running a small index.php file with the following connection string (password stared out).
[pre]
$serverName = "LAPTOP-KIQ9ICBL";
$connectionInfo = array( "Database" => "MF01_TSTDTA", "UID" => "sa", "PWD"=>"****");
[/pre]
Here are the corresponding entries from config.php
// dbms type ('mysql' or 'postgres' or 'sqlite' or 'sqlserver'); sqlserver is for Microsoft SQL Server, if you are using SQL Server on Azure please also check the parameter $tables_to_exclude
$dbms_type = 'sqlserver';
// DBMS server host
$host = '127.0.0.1'; // the name or the IP of the host (computer) where the DBMS is running (e.g. '127.0.0.1' if the DBMS is running locally); please try 'localhost' instead of '127.0.0.1' if '127.0.0.1' is not working; some Web Hosting providers can require a full name e.g. mysql.yourdomain.com; for SQLite this parameter is not needed. For mysql and postgres you can also specify the port (if it's not the default one) separated from the host by a ":", e.g. "127.0.0.1:5431" to use the port 5431
// database name
$db_name = 'MF01_TSTDTA'; // for SQLite not only the name but 1) the full path is also needed (e.g. '/my_databases/music_databases/songs.db') and 2) you need to grant to the Web server write permissions on the database file
// database user
$user = 'sa'; // this user must have select, insert, update, delete permissions, create and drop permissions are also needed for installation, upgrade and administration area e.g. 'root'; for SQLite this parameter is not needed
// for better security, you should choose a user who has privileges ONLY on the database used by this application ($db_name parameter)
// database password
$pass = '****'; // for sqlite this parameter is not needed
// database schema (only needed for postgres, not needed for mysql and sqlite, if you don't know the schema, leave "public")
$db_schema = 'public';
The only difference I can see in the Dadabik config.php file is that there is no serverName variable. The other entries are the same as in index.php.
Also I don't any connection errors in the MS SQL server error log; my index.php script does cause errors when the password for instance is incorrect.
Thanks
Elliot
