HELP: db-connection settings for ODBC to MSSQL

[eluser]MikeeJay[/eluser]
[quote author="falloutphil" date="1202708359"]Hi,

This now works:
$this->db->query("SELECT * FROM Cycle");

But this doesn't:
$this->db->get('Cycle');

An Error Was Encountered

Error Number: 42000

[DataDirect][ODBC Sybase Wire Protocol driver][SQL Server]Incorrect syntax near '`'.

SELECT COUNT(*) AS `numrows` FROM `Cycle`


Hope this helps,

Phil.[/quote]

$this->db->get(’Cycle’); works with mysql with $active_record = TRUE in database config
At least with MYSQL ODBC. But not with MSSQL ODBC =(