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

Hi Jerry,

Nice to see you around here.

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

1. Open the MS SQL Server Management Studio.
2. In the Databases node, right click and select "Attach..." from the shortcut menu
3. 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.

Edhy Rijo

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.

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.

Hi Jerry,

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

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

Edhy Rijo

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.

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.

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.

Yup, Ivan's response was right on the money