Welcome Guest, Not a member yet? Register   Sign In
unable to select the specified database in mssql
#1

[eluser]Unknown[/eluser]
Hello people, I don't know speak so much english, but I will try explain myself... I have a little aplication in CI, I'm using SQL Server 2008 with wamp 1.7 and php 5.2.5. I create my BD and tables and one view(with the controller and the model) for show this table's contents. It's working ok, no problems, but when I create other view for other table give me this error : "unable to select the specified database : "MyDB" Line Number 140". My database's config is ok, becouse it show me the first view, but when I try to see the second the first one give me the same error. Please, i need help...
#2

[eluser]Unknown[/eluser]
People, I fix the problem, I just change the configuration of my database.php :
Code:
$db['default']['pconnect'] = FALSE;
and i'ts work...Now the problem is other...this
Code:
"SELECT * FROM "TABLE" ;"
don't works, only works if use other statements, like WHERE, or others.....what do you think?
#3

[eluser]jairoh_[/eluser]
syntax is wrong sir.
Code:
"SELECT * FROM "TABLE" ;"

should be like this:
Code:
"select * from table_name"




Theme © iAndrew 2016 - Forum software by © MyBB