By Ivan George Borges - 8/21/2006
Hi everybody.I've spent the weekend building a new notebook. We are trying to work with SQL 2005 Express. For some reason, the server won't be found in the StrataFrame installation process. I found a thread where Ben sugests to insert the server name manually. I did that, but no luck. Honestly, I don't think it's a Straframe problem, as I then went into the Visual Studio's Server Explorer and tried to add a Database Conection, and it wasn't found there either. Any clues that could help ? Thanks.
|
By StrataFrame Team - 8/21/2006
When you tried to add the name manually, did you try this: "localhost\sqlexpress"?By default, TCP/IP communication is turned off on SQL Server Express, so you have to enable it if the database is on a remote machine. But, if the database is on the local machine, you have to use the full name (so you can use named pipes) or you have to turn on TCP/IP for the browser to find it. Here's a link to a topic that lists the instructions to enable TCP/IP on the server: http://forum.strataframe.net/FindPost35.aspx
|
By Trent L. Taylor - 8/21/2006
When you install SQL Server Express, it installs with an instance name by default:localhost\SQLEXPRESS Try the installation again and when prompted add the SQLEXPRESS to the end of the server name and see if it can be seen. This is the most common issue when using SQL Server Express.
|
By Ivan George Borges - 8/21/2006
Did the whole thing, still didn't work.It stops when Deploying StrataFrame Data. It builds both StrataFrame and Sample Databases, but it won't deploy the data. This machine came with Windows Media Center, which is based on Windows XP Pro. Just in case you might know of any issues.
|
By Trent L. Taylor - 8/21/2006
If you open the server using the SQL Server Management Studio, do the StrataFrame and StrataFrameInternal databases exists? If so, delete them and start the install from scratch. Also, you can send the log file which will include any errors. The log file should be located at the following location:C:\Program Files\Common Files\MicroFour\StrataFrame
or
C:\Program Files\MicroFour\StrataFrame
The name of the file will be StrataFrame_resultsX.log. This might help determine what is going on.
|
By Ivan George Borges - 8/21/2006
In a previous try, I checked in the Management Studio and they were there, empty. Ricardo is my witness, I swear !!!But now, after some 10 install and uninstalls, I tried it again and it hasn't even created the database. I've sent you the log files. If you find out something stupid, don't worry, I can take it.
|
By Trent L. Taylor - 8/21/2006
I believe you  The problem is that the MDF (SQL Server files) files exist but are not mounted to the server. So when the install tries to create these files, it gives an error. You can either manually mount these file or delete them and let the install recreate the files. If this is a fresh install, then I recommended just deleting them and letting the StrataFrame install recreate them; These are the files you will either need to mount or delete: 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\StrataFrame.mdf' 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\StrataFrame.ldf' (if it exists)
'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\StrataFrameInternal.mdf' 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\StrataFrameInternal.ldf' (if it exists)
'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\StrataFrameSample.mdf' 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\StrataFrameSample.ldf' (if it exists) If you want to mount them, open the SQL Server Management Studio and open your server. Right click on the server and go to tasks and then “Attach” or “Mount.” You will select the MDF files above. This will then add them to the SQL Server which can then be updated via the DDT.
|
By Ivan George Borges - 8/21/2006
SUCCESSSSSSSSSSThanks. Feeling home again. Now, one small thing when I created SF Toolbox : ReflectionTypeLoadException Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information. Source : mscorlib Stack Trace: at System.Reflection.Module.GetTypesInternal(StackCrawlMark& stackMark) at System.Reflection.Assembly.GetTypes() at MicroFour.StrataFrame.AddIns.MenuBasics.GetToolboxItemsForAssembly(Assembly ContainingAssembly) at MicroFour.StrataFrame.AddIns.MenuBasics.CreateToolBoxInheritedItemList()
|
By Trent L. Taylor - 8/21/2006
Already been resolved. This is because you do not have DevExpress loaded on your computer. Just ignore the error and move on and you will be just fine. This will be resolved in future updates.
|
By Ivan George Borges - 8/21/2006
Did this. It worked fine.I'm now going to install DevExpress Trial. I should then reinstall SF, right ?
|
By Trent L. Taylor - 8/21/2006
Just install the DevExpress trial. Then download the 6.1.5 version of the wrapper from the StrataFrame website and install it. Once you have done this, re-create the toolbox (where you got the error before) and it will create the StrataFrame DevEx controls.
|
By Ivan George Borges - 8/21/2006
Will do it.I can use the version I got in the SF training too, can't I ? Isn't that with the wrapper ?
|
By Trent L. Taylor - 8/21/2006
Yes, you are right. That will work also
|
By Ivan George Borges - 8/21/2006
Thanks.
|
By Trent L. Taylor - 8/21/2006
Sure
|
By Ricardo Quartier - 8/21/2006
SF - Cannot install - Ivan's KarmaYo Trent, it's me Ricardo, Ivan's friend, how are u?, I hope everything is fine...
Lets get to the show...
I bought the old notebook from Ivan, then formated, then I tried to install the SF again, I get the same problems as Ivan with the SQL Express, but i belive mine is more dificult, since after deleting the 3 sf databases, i cannot recreate then.. Im inserting the logs, to maybe help .. In the first intall.. the database was created, but the data cannot be deployed, the I read the post on the forum and I deleted the databases, but now, i can't even recreate.
Please, Please, Please, Please, Please, Please, help 
|
By Trent L. Taylor - 8/22/2006
I think you are having the reverse problem that Ivan was. It seems that your SQL Server thinks that a StrataFrame database exists when it may not. Open up the SQL Server Management Studio or Enterprise Manager and see if the StrataFrame, StrataFrameInternal, or StrataFrameSample databases exist. If so, go ahead and delete them and let the install recreate the structures.
|
By Ricardo Quartier - 8/22/2006
OK, thanks I will, the instalation is in another comp, not with me now, but i will check it out tonight...
|
By Trent L. Taylor - 8/22/2006
Sounds good.
|
By Ricardo Quartier - 8/22/2006
Trent, I guess this time I really broke it... sorry........ any idea? I sent a pic to help
|
By Ricardo Quartier - 8/22/2006
I forgot to say, the 3 databases, doesn't exist anymore...
|
By Trent L. Taylor - 8/22/2006
OK...let's start from the beginning and get you going  - Open up SQL Server Management Studio or Enterprise Manager
- If StrataFrame, StrataFrameInternal, or StrataFrameSample exists within your server, delete them
- Make sure the MDF files do not exist. To do this, navigate to the "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data" folder and remove any file that begins with "StrataFrame"
- At this point there should be no StrataFrame database or reference to a database
- Close all Visual Studio instances
- Install StrataFrame and let it re-create your data structures
This should get you going. Let me know if you run into anything I did not think of 
|
By Ricardo Quartier - 8/23/2006
Hum.. still no lucky, i sent a pic and log files.. be patience, please
|
By Ricardo Quartier - 8/28/2006
Dear friends, please do not forget me........
|
By Trent L. Taylor - 8/28/2006
Ricardo,Sorry....I in no way meant to keep you waiting. To short circuit any errors you are getting, I have posted the MDF files (the actual files that SQL Server creates) on the web for you to download. See the link below. You can just delete your existing StrataFrame and StrataFrameSample databases through SQL Server Management Studio and attach these. This side-steps the install and should get you going. Let me know if you have any questions. http://www.strataframe.net/downloads/strataframe_databases.zip
|
By Ricardo Quartier - 8/29/2006
 No sir......... I done the things u said.. I deleted the 3 databases, but still no way... I hope that file help in something.. thanks.......
|
By Ricardo Quartier - 8/30/2006
Anyway, the translation exe worked... really cool... I have to send the dlls to the gac like ivan.. but it's really cool, and we already send it back to you.. well done Trent, congratulations.
|
By StrataFrame Team - 8/30/2006
When you deleted the databases, Ricardo, did you also delete the .mdf files? looks like they're located in the c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ directory... looks like the StrataFrameInternal.mdf and possibly the StrataFrameInternal.ldf files might be causing problem...When you delete the database through the SQL Server management studio, check that folder to make sure the files are gone, and then you can retry the install.
|
By StrataFrame Team - 8/30/2006
Oh, and that path is local to the server, not local to your machine (unless the SQL Server you're trying to deploy to is your local machine )
|
By Ricardo Quartier - 9/2/2006
Yo, Ben yes it's the local machine, anyway the files that trent sent me, help me, the install cannot deploy, but he give me the databases already done... Not sure what can happen in the next version, when i need to install or reinstall, but for now.. works fine.. thanks for the help.
|