Login

03-02-2009, 03:26 PM

[eluser]Las3r[/eluser]
YEa i know.

MSSQL does not require any ''quotes'' around the collumnnames, i got case-sensitive = off, and im using the following configs:

Code:
$active_group = "accounts";

$active_record = TRUE;

$db['accounts']['hostname'] = "xxx";

$db['accounts']['username'] = "sa";

$db['accounts']['password'] = "xxx";

$db['accounts']['database'] = "ci_me_mu";

$db['accounts']['dbdriver'] = "mssql";

$db['accounts']['dbprefix'] = "";

$db['accounts']['pconnect'] = FALSE;

$db['accounts']['db_debug'] = TRUE;

$db['accounts']['cache_on'] = FALSE;

$db['accounts']['cachedir'] = "";

$db['accounts']['char_set'] = "utf8";

$db['accounts']['dbcollat'] = "utf8_general_ci";

$db['characters']['hostname'] = "yyyy";

$db['characters']['username'] = "sa";

$db['characters']['password'] = "yyyyy";

$db['characters']['database'] = "ci_mu";

$db['characters']['dbdriver'] = "mssql";

$db['characters']['dbprefix'] = "";

$db['characters']['pconnect'] = FALSE;

$db['characters']['db_debug'] = TRUE;

$db['characters']['cache_on'] = FALSE;

$db['characters']['cachedir'] = "";

$db['characters']['char_set'] = "utf8";

$db['characters']['dbcollat'] = "utf8_general_ci";

$db['web']['hostname'] = "zzzz";

$db['web']['username'] = "sa";

$db['web']['password'] = "zzzz";

$db['web']['database'] = "ci_iat_web";

$db['web']['dbdriver'] = "mssql";

$db['web']['dbprefix'] = "";

$db['web']['pconnect'] = FALSE;

$db['web']['db_debug'] = TRUE;

$db['web']['cache_on'] = FALSE;

$db['web']['cachedir'] = "";

$db['web']['char_set'] = "utf8";

$db['web']['dbcollat'] = "utf8_general_ci";

THe thing though, is that the inserting works, im using sa (superadmin) user that has all access to everything imaginable, and no limitations whatsoever. All 3 DBs are on the same physical server, accessed with the same user/pass and SQL Profiler in MSSQL shows all queries on all databases executed as "correct".

The odd part is that im using select * from statements on other databases, and it works completely.

I'll go and try this config on my linux box (running on dev-box @ windows now) to see if that changes anything, but i don't think so.

EDIT: I checked on linux, but indeed it won't work as well - same problem!

Erik