StrataFrame Forum » Enterprise Server - V1 » How do I? » how to run the sample

how to run the sample

Jerry Yang — Thu, 16 Oct 2008 09:32:02 GMT

I'm a VFP programmer for decades, no experience with SQLServer, I want to switch to VB.NET.

I have installed Visual Studio 2008, SQLServer 2008, Strataframe and StrataFlix sample.

I tried to run the StrataFlix sample, but I have no idea how to:

* Included in the extracted archive are two SQL Server files, StrataFlix.mdf and StrataFlix_Log.ldf. Use SQL Server Management Studio to attach the StrataFlix.mdf file to the SQL Server of your choice.
* Open the desired language source in Visual Studio.

can someone give me a simple guidance...

thanks in advanced.

regards,

Jerry

RE: how to run the sample

Trent L. Taylor — Thu, 16 Oct 2008 09:32:02 GMT

Yup, Ivan's response was right on the money :)

RE: how to run the sample

Ivan George Borges — Wed, 15 Oct 2008 21:15:48 GMT

Hi Jerry.

This post ( http://forum.strataframe.net/FindPost3868.aspx ) will help you to get the connection wizard back when you run StrataFlix. Try and follow Trent's instructions and see if you can connect to your database.

Hope it helps. ;)

RE: how to run the sample

Jerry Yang — Wed, 15 Oct 2008 19:55:59 GMT

Attached are the screen images.

I think I have done something bad, the system doesn't ask for authentication instead showing the error screen right away.

I have tried by detached the database, deleted and reinstalled StrataFlix but nothing changed.

Thanks for the help.

RE: how to run the sample

Trent L. Taylor — Tue, 14 Oct 2008 23:35:55 GMT

It was hard to tell exactly since the images were sized (just FYI, you can attach them as an attachment versus inserting them and they will not be resized). But is looks to be an SQL Server authentication issue. In short, the proper SQL Server credentials were not supplied.

RE: how to run the sample

Edhy Rijo — Tue, 14 Oct 2008 22:25:49 GMT

Hi Jerry,

Take a look at this thread it may help you run the StrataFlix sample:

http://forum.strataframe.net/FindPost20086.aspx

RE: how to run the sample

Jerry Yang — Tue, 14 Oct 2008 20:40:21 GMT

I was unable to find SQLServer2005, so I tried it with SQLServer2008.

I can attach the database

but when I run it, I get an error:

Please advise

Thanks.

RE: how to run the sample

Trent L. Taylor — Wed, 08 Oct 2008 09:24:39 GMT

Just FYI, I would also recommend loading SQL Server 2005 since this database was created on and for that version. It should technically work on 2008, but it has not been tested in that environment as of yet.

RE: how to run the sample

Edhy Rijo — Tue, 07 Oct 2008 21:35:03 GMT

Hi Jerry,

Nice to see you around here.

To attach a database to your SQL instance do the following:

Open the MS SQL Server Management Studio.
In the Databases node, right click and select "Attach..." from the shortcut menu
In the next screen, click the "Add" button and select the StrataFlix.mdf file, then click "OK"

That should attach the database to be manage by your SQL server. Follow the instruction in the help to compile the sample and run it, pay attention to the Login form which has the User Name and Password there for you to test it.