| 
  • If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • You already know Dokkio is an AI-powered assistant to organize & manage your digital files & messages. Very soon, Dokkio will support Outlook as well as One Drive. Check it out today!

View
 

FAQ-for-CET-4429

Page history last edited by Dr. Ron Eaglin 15 years, 2 months ago

 

 CET 4429 Frequently Asked Questions

 

Do I have to use SQL Server?

 

You do not have to use SQL server, however for the assignments you will need a software that you can do screen captures ofthe interface and that supports stored procedures. Later versions of MySQL will work well. You can also use Oracle, but that is a fairly extensive installation if you choose to use it.

 

How do I get MSDNAA Access?

 

You will need to send an email to Larry Bales (lbales@mail.ucf.edu) with the subject Request MSDNAA Access. You should include this course (CET 4429) and your NID. He will mail you back when the access is created. From there you will be able to download all the software needed for the course. Once you have an account you will login at http://msdn02.e-academy.com/elms/Storefront/Home.aspx?campus=ucf_engtech

 

Do I need the  text?

 

This is a course that you can survive without the textbook. Because it is the same text that is used in CET 4427 (where you do need the text) I recommend that you keep it until finishing this semester. There are items that reference from the text.

 

Are there lecture slides available?

 

For the lecture where I can find the slides, I am putting them up on the wiki site with the lecture links. It may take a while for some of them to get up there.

 

How do I start this class?

 

This class is all about what you can do, so you start with the assignments. You will have an assignment every week, some are lengthy, others are easy. I try to put the longest time assignments early in the semester and ramp down as the term continues. I also try to get the assignments up early enough that you can get ahead early.

 

How do I export a database into Visio?

 

Actually - you start with Visio and create a new (blank) VIsio diagram as a realational database diagram. When you do this - you will start with a blank screen - but you will also see a Database menu in Visio. From this menu you can select to "Reverse Engineer" the database. You may have to play around with the connection string parameters - but you will be able to establish a connection to the database if you are using the same machine you use to connect with SQL Server Management Studio. I typically use the OleDB driver for SQL Server.  From here I recommend playing around with the import (you are really importing into Visio at this point) setting. Once you start it running you will be amazed at the how it works.

 

How Do I Get the Connection String from GoDaddy

 

On GoDaddy - after you set up the Database, you will see a drop down menu that allows you to see the ConnectionString.

Read the GoDaddy Article at http://help.godaddy.com/article/689

To find the ConnectionString is pretty easy. After you set up the database go to the Database Icon in Hosting Manager and select the little pencil icon For View/Edit. Click the Configuration Icon and you will see the Connection Strings.

 

How does the Import in Visual Studio Work?

 

I was working along with the video about creating a login form and ran into a coding problem with the DataSet. I got errors using DataSet, and Visual Studio suggested inserting the following code:

Imports System.Data

This seemed to fix the problem but I'm just wondering if this was something I missed to do or something we need to do while making the project.

 

Answer:

 

All of the objects you use (such as Datasets) all exist within packages. By default I have some packages that load automatically in every page (this is somewhere in VS options). If you do not load the package that contains those objects by default you need to explicitly import them.

 

I also recommend taking a look at the objects and packages available to you.  You can do this in Visual Studio by bringing up the Object Browser. In the browser you will see packages designated with a { }. If you click on the + before { } System.Data you will see the objects you can use after importing (or using in C#) that package. If you ever see an object I use in code and you cannot get it to work, open the Object Browser, search for the object, and then make sure you import that package.

 

 

 

 

Home PageAssignment Assistance

Comments (0)

You don't have permission to comment on this page.