Hello,

I ran into the following error message while setting up the database connection in the BW 1.31 install wizard. I verified the database settings in the kernel\config_inc.php.

Database connection could not be established.

The returned error message is:
Incorrect syntax near 'tiki_preferences'.

Win2k3
IIS
SQL 2005
PHP 5.26

is this a new site, or updating an old or migrating from tikiwiki site?

Ned, can you post the exact SQL line that failed? It should have been dumped in the fatal error. Actually, if you could post the entire stack and SQL errors (everything on screen when it puked , we call that a "Fatal" ) that would be great.

New Site... not migrating from TikiWiki... thx

Hi Spiderr,

hope this is what you are looking for... thx

Warning: mssql_connect() function.mssql-connect: Unable to connect to server: localhost in K:\Bitweaver131\util\adodb\drivers\adodb-mssql.inc.php on line 508

Click here to log a bug, if this appears to be an error with the application.

Go here to begin the installation process, if you haven't done so already.

- 1.3.1 - Tue Jul 01 10:54:23 2008

---

1. USER AGENT: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; InfoPath.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)
2. ACCT: User unknown
3. URL: http://servername/index.php
4. HOST: servername
5. IP: x.x.x.x
6. SQL: localhost
7. ADODB: Message: Connection error to server 'localhost' with user 'bitweaver'

}}}}}} -> bit_error_string(Array7)
}}}}}} LINE: 40, K:\Bitweaver131\kernel\bit_error_inc.php
}}}}} -> bit_error_handler(mssql, CONNECT, false, Connection error to server 'localhost' with user 'bitweaver', localhost, bitweaver, Object:ADODB_mssql)
}}}}} LINE: 425, K:\Bitweaver131\util\adodb\adodb.inc.php
}}}} -> ADOConnection::Connect(localhost, bitweaver, password, bitweaver)
}}}} LINE: 111, K:\Bitweaver131\kernel\BitDb.php
}}} -> ADOConnectionBitDb()
}}} LINE: 67, K:\Bitweaver131\kernel\setup_inc.php
}} -> ADOConnectionrequire_once(K:\Bitweaver131\kernel\setup_inc.php)
}} LINE: 9, K:\Bitweaver131\bit_setup_inc.php
} -> ADOConnectionrequire_once(K:\Bitweaver131\bit_setup_inc.php)
} LINE: 23, K:\Bitweaver131\index.php


Fatal error: Call to a member function isFatalActive() on a non-object in K:\Bitweaver131\kernel\bit_error_inc.php on line 59

Ned,

This is a problem with your local MSSQL configuration. Whatever database settings you are using in kernel/config_inc.php does not work with your MSSQL setup. Try to make a connection using the identical settings on the same host using another tool. Could be permissions, could be it is not accepting connections on the local interface. Could be Windows love. Dunno. I know nothing about windows except I should personally avoid it.

SetupMSSQL

This is about 3 years old, but some of it may still be relevant.