|
|
Rank: Member
Groups: Member
Joined: 4/8/2008
Posts: 8
Points: 0
|
Same topic as the previous user posted, but I don't think he needs to see such an old thread update. Here is my problem: I'm login in OK, and just like the other thread issue: I can connect, but can't expand the Treeview to browse content. I checked the demo site, and there I have no problem viewing the tables and all the site's info. Also, I checked with Firefox 2 and IE7. I get the same behaviour. My server is 2003 Standard with SQL Server 2005 Express. My control panel is HC7 build 15 (fresh install). I did not modify anything, it is installed and enabled by HostingController automatically. Quote:Offending URL: http://server.info/MSSQLAdmin/obj/objlist.aspx?t=udSource: .Net SqlClient Data Provider Message: Invalid object name 'sys.databases'. Stack trace: at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillSchemaFromCommand(Object data, SchemaType schemaType, IDbCommand command, String srcTable, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillSchema(DataSet dataSet, SchemaType schemaType, IDbCommand command, String srcTable, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillSchema(DataSet dataSet, SchemaType schemaType) at MyLittleAdmin.Connection.FillDataSet(String pSqlQuery, Int32 p1stRow, Int32 pRowCount, String pDataSetName, String pTableName) at MyLittleAdmin.MlaServer.GetUserDbList() at mla_gui.ObjList.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain() Target site: System.Data.SqlClient.SqlDataReader ExecuteReader(System.Data.CommandBehavior, System.Data.SqlClient.RunBehavior, Boolean) Looking for some pointers to fix this. -Sup.
|
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
You try to use myLittleAdmin for SQL 2005 with a SQL 2000 server, which is not supported. If you need to manage a SQL 2000 server, then use myLittleAdmin for SQL 2000. More info on myLittleAdmin for SQL 2000 can be found at http://www.mylittletools.net/en/mylittleadmin_sql_server_2000/
|
|
Rank: Member
Groups: Member
Joined: 4/8/2008
Posts: 8
Points: 0
|
I'm sorry, but where did you see SQL 2000? I explicity said windows 2003 with SQL Server 2005 Express. Did I miss something? -Sup.
|
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
Run the following query on your sql server and tell us the result: Code:EXEC xp_msver @optname='ProductVersion' A classic explanation is that you both have SQL 2000 and SQL 2005 on your machine and you did not correctly define your SQL 2005 Server in the config.xml file
|
|
Rank: Member
Groups: Member
Joined: 4/8/2008
Posts: 8
Points: 0
|
Index Name Internal_Value Character_Value
2 ProductVersion 524288 8.00.2039
|
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
It means that you try to manage a SQL 2000 instance. SQL 2005 is 9.00.xxxx Edit your config.xml file and check your SQL Server instance name. I'm pretty sure you (or HC7 default install) defined your SQL 2000 instance instead of your SQL 2005 instance.
|
|
Rank: Member
Groups: Member
Joined: 4/8/2008
Posts: 8
Points: 0
|
elian wrote:It means that you try to manage a SQL 2000 instance. SQL 2005 is 9.00.xxxx Edit your config.xml file and check your SQL Server instance name. I'm pretty sure you (or HC7 default install) defined your SQL 2000 instance instead of your SQL 2005 instance. You might want to indicate to users who use HC to understand that HC installs either a version with NO database (where you need to install a db on your own and then you are certain to get the 2005, OR,. use the HC version of DB which as it turn out to be: MSDE version which as it appears,. is NOT a 2005 version). I'm going to install 2005 now and re-install HC onto it.. then I'll try again. Thanks for helping me identify the problem. -Sup.
|
|
|
Guest |