Hello, hoping someone can help me with an apparent error I'm getting using MyLittleAdmin for SQL 2012. Problem: clicking the "open table" button in MyLittleAdmin does not return any information for some tables. Neither the column headers or the actual data disply. For example, "app.Facts" in the attached pic won't open. - the tables definitely have data in them, and can be accessed from VS2013 without problems - Some tables work without problems. In the attached pic, I can open "app.Sides" just fine, though that's the only table in the 'app' schema that works. - Clicking on the 'column' folder shows the column names and meta-data - All of the tables in the 'dbo' schema work normally. Only issue is 'app' schema. However, as mentioned, one table in the 'app' schema works ne. - problem repeats using both IE and Firefox, and also repeats from different locations/computers. - I was last able to access these tables via MLA a couple months ago. All of these tables existed then and work as normal in MLA. After time away I've just tried reaccessing them and have noticed this problem. Maybe something changed in the MLA settings in the past month? Appreciate any ideas, thanks! Regards, Jason
I believe it is a bug in MyLittleAdmin. I was able to reproduce the issue and noticed that only those tables have the problem which have user defined data type dependencies. In particular, your app.Fact table depends on hyerarchyid user-defined data type and the rows are not listed. The table app.sides does not have that dependency and its rows are listed normally. Hyerarchyid is a new user-defined data type introduced in SQL Server 2012 and I think MyLittleAdmin just does not recognize it.
Dmitri, Appreciate your help, believe you nailed it. I just tried a query on the tables that use HierarchyID, the query only fails when I include the HierarchyID column. However, if that is the cause it must have been broken by a recent update MLA pushed, previously those tables displayed with HierarchyID. A search of MLA's forum for "hiearchyID" comes up empty, and I can't register on the forum to post my own request for info. I guess you have to be customer to register. So I've sent my question to their support via email. Not certain if they'll reply since I'm not a direct client. Can anyone at DiscountASP.NET post on their forums, ask if they know of the error and have a planned fix? Thanks again! Regards, Jason
Have you ever used SQL Server Management Studio? Try it out and see how you like it. Most people use it to manage their MS SQL database in our hosting environment. Instructions on how to connect to your MS SQL database using SQL Server Management Studio can be found in our knowledge base article: http://support.discountasp.net/KB/a1021/how-to-connect-to-sql-server-2012-using-sql-server.aspx
I have, thank you. But I frequently need browser-based access via MLA, so I'm really hoping we can fix the bug. According to MLA their email support is part of their license, so I don't believe they'll answer my email. Their latest version is 3.8, the DASP version is 3.5. Is there any plan to upgrade to 3.8? It's 'only' $990.
Actually it wouldn't cost anything, just read their plans and 'minor' updates are free for life. I'm assuming 3.5-3.8 would be minor.
We will contact MyLittleTools and letting them know about this bug so they can investigate and fix the problem. We will also consider updating MyLittleAdmin. However, both of the mentioned solutions cannot be done fast. I suggest you to stick with MS Management Studio for a while.
