[eluser]Unknown[/eluser]
Hello all!,
I am new with CI, and I'm writing my first program.
I'm try connect to sql server 2008, and I'm connecting via odbc and
I have in my database.php following:
$db['default']['hostname'] = 'DRIVER={SQL Server};SERVER=192.168.0.207;DATABASE=CP';
$db['default']['username'] = 'Operador';
$db['default']['password'] = 'pe7878';
$db['default']['database'] = 'CP';
$db['default']['dbdriver'] = 'odbc';
but i'm getting the following error:
"A Database Error Occurred
Error Number: 37000
[Microsoft][ODBC SQL Server Driver][SQL Server]Sintaxis incorrecta cerca de ')'.
SELECT * FROM (cerepuertos)
Filename: T:\xampp\htdocs\AcopioCI\system\database\DB_driver.php
Line Number: 330"
which may be the cause?
I appreciate any suggestion,
best regards,
Fernando