Radicore Forum: RADICORE Installation Issues

Home » RADICORE » RADICORE Installation Issues » SQLSRV Driver (How to setup config.inc for multi database option with one of them being 'sqlsrv' )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: SQLSRV Driver [message #4728 is a reply to message #4723]

Mon, 11 May 2015 08:12

rafs
Messages: 69
Registered: May 2015

Member

Same error as previously:
Fatal Error: [Microsoft][ODBC Driver 11 for SQL Server]Named Pipes Provider: Could not open a connection to SQL Server [53].
...

// this demonstrates the multi-server option (see FAQ92)
if (preg_match('/^(127.0.0.1|localhost|desktop|laptop)$/i', $_SERVER['SERVER_NAME'])) {
global $servers;
// server 0
$servers[0]['dbhost'] = 'localhost';
$servers[0]['dbengine'] = 'mysql';
$servers[0]['dbusername'] = 'root';
$servers[0]['dbuserpass'] = '';
$servers[0]['dbport'] = '';
$servers[0]['dbsocket'] = '';
$servers[0]['dbprefix'] = '';
$servers[0]['dbnames'] = 'audit,dict,menu,workflow';
$servers[0]['ssl_key'] = '';
$servers[0]['ssl_cert'] = '';
$servers[0]['ssl_ca'] = '';
$servers[0]['ssl_capath'] = '';
$servers[0]['ssl_cipher'] = '';
// server 1
$servers[1]['dbhost'] = '10.100.150.86';
$servers[1]['dbengine'] = 'sqlsrv';
$servers[1]['dbusername'] = 'mydbusername';
$servers[1]['dbuserpass'] = 'mydbpassword';
$servers[1]['dbport'] = '';
$servers[1]['dbsocket'] = '';
$servers[1]['dbprefix'] = '';
$servers[1]['dbnames'] = 'mydbname,*';
$servers[1]['serverName'] = '(local)';
$servers[1]['SQLSRV_schema'] = 'dbo';
$servers[1]['connectionInfo'] = array('CharacterSet' => 'UTF-8',
'ReturnDatesAsStrings' => true);
} // if

Report message to a moderator

[Message index]

		SQLSRV Driver By: rafs on Sat, 09 May 2015 11:44
		Re: SQLSRV Driver By: AJM on Sat, 09 May 2015 12:24
		Re: SQLSRV Driver By: rafs on Mon, 11 May 2015 02:53
		Re: SQLSRV Driver By: AJM on Mon, 11 May 2015 04:21
		Re: SQLSRV Driver By: rafs on Mon, 11 May 2015 09:35
		Re: SQLSRV Driver By: rafs on Wed, 03 June 2015 17:06
		Re: SQLSRV Driver By: rafs on Mon, 11 May 2015 08:12
		Re: SQLSRV Driver By: AJM on Mon, 11 May 2015 09:26
		Re: SQLSRV Driver By: rafs on Mon, 11 May 2015 09:39
		Re: SQLSRV Driver By: AJM on Mon, 11 May 2015 09:40
		Re: SQLSRV Driver By: rafs on Tue, 12 May 2015 04:31
		Re: SQLSRV Driver By: AJM on Tue, 12 May 2015 05:29
		Re: SQLSRV Driver By: rafs on Tue, 12 May 2015 05:34
		Re: SQLSRV Driver By: rafs on Tue, 12 May 2015 05:40
		Re: SQLSRV Driver By: AJM on Tue, 12 May 2015 06:01
		Re: SQLSRV Driver By: rafs on Tue, 12 May 2015 06:29
		Re: SQLSRV Driver By: AJM on Tue, 12 May 2015 06:43
		Re: SQLSRV Driver By: rafs on Tue, 12 May 2015 06:44
		Re: SQLSRV Driver By: rafs on Wed, 03 June 2015 17:21
		Re: SQLSRV Driver By: rafs on Mon, 11 May 2015 16:47

Previous Topic:	Failed opening required 'include.general.inc'
Next Topic:	Error: This application has encountered an unrecoverable error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Nov 28 09:37:44 EST 2024

Total time taken to generate the page: 0.01209 seconds