1
votes

I am currently trying out cakePHP to be integrated with my MSSQL database. I have already set up my connection with MSSQL, and currently I am trying to test my connection by selecting all the contents of a certain table in MSSQL. However when I am trying to run my query, this error happens:

Table tbl_tag__vehicles for model Login was not found in datasource default.

I understand that it is saying that it cannot find the table "tbl_tag_vehicles" from the database, but what I placed in my code is this:

var $name = "TblTag_Vehicle";

I am wondering why it is happening, because the table name in the database is "TblTag_Vehicle", but cakePHP is doing something to the string and it converts it to a different name.Is it because of CakePHP's naming standards?And is it possible for me to turn off whatever it is that is converting the table name?

1

1 Answers

1
votes

// Dude you cant do anything like turn off name conventions , cakephp wont work in that case.

In model you should write

var $name = "TblTagVehicle";

AND Give same name to model file LIKE TblTagVehicle.php There should NEVER be underscore in name of model .