Showing posts with label beginner. Show all posts
Showing posts with label beginner. Show all posts

Thursday, March 29, 2012

Database Connection

Hello,

I'm beginner in Ms SQL Server 2005, i dont know how to do a conection to my database.
Using Ms Access, the connection was successful, but using Ms SQL Server 2005 there is a problem.
for information, i try to connect the database using wizard option in ms Frontpage, the problem is, frontpage can only read sys.view file, dbo.view file cannot be able to view.

What is the main procedure or first procedure to create and connect database Ms SQL Server 2005?
I already read a book and internet, but i cant find the solution.

TqHi,

Try to re-install and connect to MS Sql Server 2005 using Windows Authetication. When u install SQL Server it give you some options like using windows Authentication or SQL Server Authentication. So during installation u should select Windows Authentication check box, If u r a single user installing on ur personal computer and practicing. Otherwise u have to set up SQL Server manually and I have no Idea about that.

I hope that helps u

Cheers,

Koonda

Tuesday, March 27, 2012

database beginner question

I've searched and could not find what I was looking for.
I have NO database experience but need to learn quick

I have an html page with an iFrame (flash menu on left - iFrame on right)
When I click a product image on the left this is what I need to happen.
- Flash send a variable
- The iFrame to load an HTML page that will populate with an image, 2 text fields, and 3 hyperlinks dependant on what product is clicked in the flash.

I am using access since it is what i have at work, and i can just add all the products in a table pretty quickly and easitly. I set up a table in access with the image, hyperlinks, and text that needs to populate in the html page. The HTML page is set up in tables if that makes a difference...

I just don't know where to go from here to make my connections and how to set it up.

Any help would be appreciated.

Thanks in advance.I would go to the Access forum