StrataFrame Forum » StrataFrame Application Framework - V1 » Issues » Errors in the Sample Console (1.6)

Errors in the Sample Console (1.6)

James Moore — Mon, 26 Feb 2007 13:16:25 GMT

Hi all,

I've been working with Trent on this but could not come up with a resolution before he had to jet out on a family emergency. I know this isn't a priority, but I was showing a programming friend of mine the Sample Console after upgrading to 1.6 and errors occur on almost all of the links in the StrataFrame UI Controls (There is a lot more to the message, but basically it is a SQLException: Invalid object name 'customers'). When I click on the Advanced ListView Population under Grids and Lists, the customers load (parent records), but when I click on a customer that has child records, WHAMO! This time I get SQLException: Invalid object name 'products'. Here are the things Trent and I have gone through thus far:

1. Deleted the appkeys.dat and connections.dat under C:\Documents and Settings\All Users\Application Data\MicroFour\ConnectionData. Reconnected under VS and when running the Samples and problem still exists.

2. Removed StrataFrame and StrataFrameSample databases from SQL Server 2005 Express SP2 and downloaded the latest StrataFrame installation then ran the installation. Both databases were created successfully, still the same problem.

3. Completely uninstalled StrataFrame, removed all left over folders in Common Files, Program Files, Profile folders, etc. Removed both databases from my SQL Server. Searched for StrataFrame and MicroFour in the registry and removed all entries. Ran a registry cleaner to clean up anything I may have missed. Restarted my computer and checked for a new StrataFrame installation (which there was), downloaded and installed StrataFrame. Ran the Samples and still have the problem.

That is pretty much where we left it. Trent thought it may be some type of connection with the database issue (like connecting to an older version or something), but I only have one instance of SQL Server and the setup recreates the databases each time without any issues. Plus, I can connect to both to them (StrataFrame database in VS2005 and StrataFrameSample when I try to run the first Sample after installation).

Anybody have any ideas? I was a little embarrassed trying to show off the Samples. However, I was able to run the CRM Sample application without any problems at all and that really impressed him. I told him it was a brand new version and the other Samples were probably something to do with my setup. :)

TIA,

James Moore

RE: Errors in the Sample Console (1.6)

Greg McGuffey — Mon, 26 Feb 2007 13:16:25 GMT

[quote]Yeah, and I bet Greg thinks he is funny too... you're talking about him, right?[/quote]

Who me? I was just making an oberservation ;) , which accoring to Ricardo was a bit too general :pinch:

RE: Errors in the Sample Console (1.6)

Ricardo Quartier — Fri, 23 Feb 2007 22:18:31 GMT

We crazy? :w00t:

Just Ivan is crazy !!

haha

RE: Errors in the Sample Console (1.6)

Ivan George Borges — Fri, 23 Feb 2007 15:48:33 GMT

[quote][b]James Moore (02/23/2007)[/b][hr]Hey, I see we have a comedian on this forum. Right, Ivan? hehe [/quote]

Yeah, and I bet Greg thinks he is funny too... you're talking about him, right? :smooooth:

RE: Errors in the Sample Console (1.6)

James Moore — Fri, 23 Feb 2007 14:15:42 GMT

Hey, I see we have a comedian on this forum. Right, Ivan? hehe

[quote]I see you haven't formated your hard drive yet... just kidding.[/quote]

Maybe that will be my next step if Ben's suggestion doesn't show anything. :)

I appreciate your response. Ben, I'll give that a try and see what I find out. Something is whacked out somewhere on my system if nobody else is seeing these same problems. Still makes me wonder why the Sample CRM application works perfectly but not the individual control samples. :unsure:

I'll let you know what I find out.

Have a great weekend everyone!

James

RE: Errors in the Sample Console (1.6)

StrataFrame Team — Fri, 23 Feb 2007 11:40:27 GMT

Hehe, but a format fixes anything :)

James, all of the samples should have the source code include... can you build one of the offending samples in debug and put a break point where the exception is being thrown? Then, while it's at the breakpoint, in the Watch window, check the value of the MicroFour.StrataFrame.Data.DataBasics.DataSources("").ConnectionString.

If you post the connection string out here, don't forget to remove any passwords if necessary (to protect the innocent).

RE: Errors in the Sample Console (1.6)

Greg McGuffey — Fri, 23 Feb 2007 10:49:51 GMT

[quote]I see you haven't formated your hard drive yet... :hehe: ... just kidding.[/quote]

Ah...those crazy brazilians! :P

RE: Errors in the Sample Console (1.6)

Ivan George Borges — Fri, 23 Feb 2007 10:36:24 GMT

[quote][b]James Moore (02/23/2007)[/b][hr]3. Completely uninstalled StrataFrame, removed all left over folders in Common Files, Program Files, Profile folders, etc. Removed both databases from my SQL Server. Searched for StrataFrame and MicroFour in the registry and removed all entries. Ran a registry cleaner to clean up anything I may have missed. Restarted my computer and checked for a new StrataFrame installation (which there was), downloaded and installed StrataFrame. Ran the Samples and still have the problem. [/quote]

Hi James.

I see you haven't formated your hard drive yet... :hehe: ... just kidding.

It won't be of much help, but all samples run fine over here. As you've been through this with Trent, I guess nothing much has been left to say. You wouldn't have 2 instances of SQL Express installed in your machine, would you? Nor this would be a security issue, do you think? Would you consider uninstalling SQL Express and installing it again?

Cheers.