Re: Attachment #1

I'm going to try SF again - so I ran the installer for the latest version 2/15/07.

Got the attached error.

What does it mean?

What do I do next?

Re: Attachment #2

I clicked on Business Binding Source and got the attached error?

???

I removed and retried the install today.



The good new is Yes, there is a log file.

The bad new is that its length is 0 bytes.



same story from yesterday.

More than likely you have installed StrataFrame to this SQL Server before, but dismounted the StrataFrame database rather than delete the SF database.  When this happens, the SQL MDF file is left on disk so when the database is attempted to be created, it fails because it cannot create the file group.

The error in the sample is because you have not properly installed the databases.  If the database is not there....then you will get an error.

The issue is on the side of SQL Server.  Either the MDF, permissions, etc.  But all in all the database cannot be created due to an issue on the side of SQL Server.

After talking to you it was a simple matter to resolve the problem. The old data files were:

1 - not reattached when I upgraded to SQL 2005

2 - After reattaching them, the install still failed suggesting that the old format (or something) is not compatible with your latest release.



After delete the old file, the install finished normally.



It would be nice if the installer did some tests and/or provided the option to kill the old databases and make a new set. I wasted several hours screwing around with this because of the lack of a useful error message or a more fault tolerant app.



Thank you for your help.

Since doing the install I get the following error:



Error HRESULT E_FAIL has been returned from a call to a COM component



any time I try to paste dataGridView controls onto a form or try to drag a data source onto a form or try to rename a bindingSource.



Any idea what got corrupted?



Thanks

See Attached.



Uninstalling SF apparently does an incomplete job of cleaning VS2005.

This is not a safe thing to do outside of the local machine or programatically.  This is a message that comes back from SQL Server when trying to mount a database or create a file group using SMO. 

This file is removed with the installation...you do not have a clean installation.

Well, first of all, if the installation had produced as fully functional VS2005, I wouldn't have needed to uninstall it again.



Secondly, the uninstall left all of the ToolBox items as well as the addin.



Thirdly, as far as not being able to tell if the the databases exist and are mounted, The following code, as you know, will tell you if the database is mounted or not (by throwing an exceptions). If it is mounted you can get the file paths. I it's not mounted, you can do a file exists on the path that you intend to copy the file to and -

a) decide whether to skip the copy or

b) ask the use if they would like to delete the old files (which by this time you know are not mounted.



Now I don't know what capabilities you installer builder offers but I know I could do something like the code below with InstallShield. It's not fancy but you can get the idea. Obviously this is sort of pseudo code and there's no point in working it out so that it's clean and tight but it demonstrates that it is possible to anticipate the common scenarios that might prevent a successful installation and deal with them.



I'm sure that you know all of this and what I've included here probably seems kind of amateurish to you but I have made numerous good-faith efforts to install and use StrataFrame and, so far, i have never gotten more that a week into an attempt before I have been stopped in my tracks by some kind of bug or quirk or my inability to read your mind. Each time this has happened I have been forced to use other techniques because I couldn't wait long enough for support and/or a patch.



I think you guys have a good concept and most people must be using it without these kinds of troubles. I would like to be one of them.



All I can in my defense is that if got 40 years experience programming and I've got commercial software deployed to thousands of users. From time to time I have run up against a situation where my stuff would not behave as expected on someone's machine. In each instance, I have tackled the problem and worked it through to the point where the issue was identified and fixed. It's never easy and not always quick.



Anyway I'll be back working with CSLA while I await your reply.

Thanks,

Dan

--------------------------------------------------------

cm.CommandText = "use StrataFrameSample";

cm.CommandType = CommandType.Text;

try

{

   int i = cm.ExecuteNonQuery();

   cm.CommandText = "use StrataFrameSample; select * from sys.database_files;";

   SqlDataReader reader = cm.ExecuteReader();

   while (reader.Read())

   {

      string filename = reader.GetString(6);

      Console.WriteLine(filename + " exists " + File.Exists(filename).ToString());

   }

return;

}

catch (Exception ex)

{

   Console.WriteLine(ex.Message);

if (AttachDbAtDefaultLocation())

{

// files are where you expect them and are mounted

}

else

{

// They're not where you expect them

//so there is no problem putting another set in the default location

CopyNewFilesIfNeeded();

// now do the attach

//etc...

}

}

//etc....



bool AttachDbAtDefaultLocation()

{

   using (SqlCommand cm = cn.CreateCommand())

   {

      try

      {

         cm.CommandText = "EXEC sp_attach_db @dbname = N'StrataFrame', " +

         "@filename1 = N'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\StrataFrame.mdf', " +

         "@filename2 = N'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\StrataFrame.ldf' ;";

         cm.CommandType = CommandType.StoredProcedure;

         cm.ExecuteNonQuery(();

         return true;

      }

      catch (Exception ex)

      {

         return false;

      }

   }

}



void CopyNewFilesIfNeeded(bool DoDelete)

{

   string[] filesToCopy = new string[]{"c:\path\a.mdf", "c:\path\a.ldf"};

   foreach (string file in filesToCopy)

   {

       if (File.Exists(file) && DoCelete)

       {

            File.Detete(file);

       }

       else

       {

            DoCopy();

       }

   }

}

Daniel,

It is not my desire to sit here and spar with you and I appreciate your attempt to try to come up with some code, but there are some inherent issues with your code that will not work in a commercial environment.

When creating commercial developer tools, which I am sure that you can respect and understand, you have to take more into account than the local computer or simply copying a file. Your code makes some assumptions in regards to the machine permissions such as full administrative rights.  Additionally, the file group name may be using the $DbName$ tag which then creates a moving target and even further complicates the situation.  Many times developers are installing to remote SQL Server environments with very limited credentials.  This means that these developers may not have any Windows security rights whatsoever.  This is why the installation environment MUST remain and respect the SMO and permissions granted. 

 

And we have also made many attempts, including numerous screen sharing sessions to get you going just to learn in most cases that it was simply configuration and installation issues outside of the scope of StrataFrame.  But we too, in good-faith, are interested in taking care of our customers and helped you even though in these circumstances the issues were not related to StrataFrame.

If there is ever a bug that prevents any of our users from moving forward or if there is not a work around, we do our very best to stop and take care of our customers immediately.  We also are not clairvoyant and if we are not aware of a problem we cannot address it.

As always we are dedicated to providing excellent support and taking care of our customers.  I am not sure why you have always seemed to struggle while others do not but this is a moot point as we are dedicated to helping our customers regardless of their circumstances.  The issue that you have mentioned here is again, not related to StrataFrame but rather an issue with you dismounting the StrataFrame database, upgrading from SQL Server 2000 to 2005 and then coming back to later install StrataFrame with other residue left on your machine which caused the problem. 

I appreciate your experience and we always welcome input from all of our developers regardless of their experience.  But in this case I do not think that your experience is the issue but rather a misunderstanding of how SQL Server and SMO work.  Again, we have told you how to work around the issue that you encountered.

I respect your decision and wish you the best of luck.

Daniel,

It is not my desire to pile-on but your continued threats are becoming tiresome.  If you want to use CSLA then go with our blessings.  I might note that I frequent Rocky's forum and it seems you pose similar complaints to him.

Daniel, although not as experienced as you, I have been in the business for 33 years and also have thousands of customers.  The new .NET experience has taught me one huge lesson: knowledge is not a function of time but of learning.  My past experiences helped but ultimately they did not carry the day.

The SF team has been extremely accommodating to your cause, I know for a fact on multiple occasions a team member was walking out the door for the evening and you would call, and they would stay behind for an hour or more to help, at no cost to you.

Nevertheless, it is our continued desire to make you happy but you must take a different approach.  It is our belief that SF is the best the market has to offer and with the advent of our new Enterprise Server we have distanced SF from the competitors.

Very, very true Steve. Well said! Good examples are Trent and Ben (Chase, not me )

..ßen

Hey Daneil;



I think Larry did a good job of pointing out why SF is such a great product. I'm with you, I graduated in 1981 and have gone through many products since then. When I started .Net I had come from Borland's Delphi (which has a great IDE), and I missed many things that should have been in VS. So, over one year I researched many (and I mean many hours), looking at many products and there were several points I looked for:

Architecture

Support

Cost

3-tier support



And guess what, this is where I landed. I'm responding to you, because I feel someone with your level of experience deserves some feedbacks from people like me who have been around.



I spend over a month asking questions (before I had spend a penny), and SF team answered my questions with full interest. The support is the BEST and I even signed up for the next month training to learn more.



Take care!


..ßen

Thanks for the reply. It sounds like I did pretty much the same research that you did and I came to the same conclusion. On paper StrataFrame is near perfect. I've run into some problems (obviously unusual) in getting up and running, but the concept is so great that I'm not prepared to give up. I will keep trying until I get the problems resolved.



Again,thanks for the encouragement,

Dan

Hi Daniel.

Well, I wish I could tell you that I was only 22 years old and that I had never seen a punch card and FORTRAN in my life, but unfortunately it's not the case.

Not trying to be obvious, but if you are formating your HD (something I thought of telling you before, but didn't dare), I guess you could first try a basic installation with the requirements for the framework and see it running. Then you can go creating Restore Points in windows and build on the top of it.

Are you coming to the class on May? It looks like it is going to be very productive and fun!

Cheers.

I have mixed feeling (obviously) about reformatting. It takes so long to install (or remove) the various VS components and VS itself that it probably won't take any longer to start from scratch than to experiment around with trying various incremental removals and reinstalls.

I will consider your suggestion carefully before I do anything drastic.

Thanks,

Dan

I apologize for launching into a tirade. It's the result of the conflict between my interest in using the product and my inability to get it up and running. In the future I will try to confine my questions to specific technical issues. It's not really my intention to be an irritant. I would appreciate a gentle nudge if I stray off this path.



I guess that before I ask you to do anything more than you have already done, I will have to reformat the hard drive and reinstall everything from scratch.



Before I do that it would help me to know if the the following things that I have installed are known to create an incompatibility with StrataFrame:

Oracle add-in for VS2005

DB2 add-in for VS2005

DevExpress suite

Xceed suite

ComponentOne suite

CodeRush

Refactor Pro

CodeSmith

ReSharper

SQL Server Integration Services

Visual Studio Tools for Office



Thank you for your professional assistance,

Dan