BASE cannot logon to SQL. The environment is a brand new installation of BASE and Snort, Windows and SQL. The username and password does work over ODBC and SQL Server Management Studio. The create_base_tbls_mssql.sql script has been executed against Snort.
Any ideas on how to troubleshoot this?
J Wolfgang Goerlich
Database connection failed!
Please try again!
From the main page after manually creating base_conf.php:
Error (p)connecting to DB : Snort@Db20.yourdomain.com
Check the DB connection variables in base_conf.php _
Adodb 5.10 (for PHP5)
PHP 5.2 (5.2.13)
SQL Server 2008 (64-bit)
Windows Server 2008 R2 (64-bit)
Resolved. AdoDb was not working properly. The mssql_* functions (php_mssql.dll) in 5.1.6 have been replaced with sqlsrv_* functions (php_sqlsrv_53_ts_vc9.dll) in PHP 5.3.13 and 5.3.2. I downgraded to PHP 5.1.6 and added php_mssql.dll to the php.ini as an extension. The AdoDb and BASE connectivity now work properly.
Log in to post a comment.
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.