Starting with MS SQL Server 2000
--------------------------------
Here is my tutorial for the easiest way to start with MS SQL 2000
Firstly We are going to assume you have made your database already in Microsoft Access, as this is the easiest way.
ok firstly make sure your Access file is on the server.
Go to Start -> Program Files -> Microsoft SQL Server -> Import/Export Data
First it will give you an introduction, click Next
Click the first drop down box, and select Microsoft Access
Select the file and put in the username and password, click next
Keep everything as the same, and drop down the database menu, click New
It will then ask for a name, put in your database name and hit ok, click Next
Keep the next page as is, just confirming you want to copy everything, click Next
Press Select all to make sure all your tables go across, click next
Keep it select to run immediately, click next
This page is just an overview of all the options, if you are happy with it, click Finish
You should have transported all your data over without problems, click Done
goto Start -> Program Files -> Microsoft SQL Server -> Enterprise Manager
Click + Microsoft SQL Servers
+ SQL Server Group
+ ServerName (Windows NT)
You should now see a list that includes
+ Databases
+ Data Transformation Services
+ Management
+ Replication
+ Security
+ Logins
+ Support Services
+ Meta Data Services
Right Click Logins (Under Security) and click New User
Give a Username, then click SQL Authentication and put in your password
Drop down the database and click the Database you created and
Click Database Access and then Tick the database name
When you hit OK it will ask you to confirm the password, click OK
Now you've set up your database and your usernames, there are a couple of things you must do, as they dont properly transform across, they are Primary Keys and AutoNumbers
Click the Plus next to 'Databases' and then the plus next to your Database
Click Tables then in the left hand side, click one of your tables (its all listed in alphabetical order)
Right Click your table and goto Design Table
You will then be presented with a screen very much like the Access Design table
To Set AutoNumber, click Identity, and Select Yes (their can only be ONE Identity per table)
Right click your Column Name and then select Primary key to where you need it
If you have anything Unticked in Allow Nulls or do not wish that to be, remember to add a Default Value into the column
when you want to exit, it will prompt you to save, click ok
Once you have all your tables in order you can close Enterprise Manager (be aware that you aren't constrained like Access and can have more than 255 chars)
Close MTS and goto your Coldfusion Administrator
THE NEXT PART IS FOR COLDFUSION MX, PLEASE READ YOUR DOCUMENTATION IF YOU HAVE A PREVIOUS VERSION
Goto Data Sources, and at the top, type in your DSN name
Drop down the box and click MS SQL Server click Add
You will then have a form in front of you that will have
CF Data Source Name : (you already added this)
Database : put the Database name you created in MTS
Server : put your machine name or 127.0.0.1 or localhost, whichever :)
Username : The username that you created in Enterprise Manager
Password : Same as above
Description : Purely optional
You then should get a big OK!
This brings us to the end of our tutorial,
I really hope this helps,
there are ALOT of things you can do with MS SQL2000
but this is just to get your foot in the door,
Hope this helps you all!!!
All ColdFusion Tutorials By Author: Alex Allen-Turl
Creating Relationships with ColdFusion
This tutorial shows how you create Relationships between tables to speed up queries and decrease the overall size of the database Author:Alex Allen-Turl Views: 23,415 Posted Date: Friday, December 13, 2002
Creating Databases in MS SQL2000
How to get your Data into MS SQL2000 and interface with Coldfusion in 34 Easy Steps! Author:Alex Allen-Turl Views: 27,172 Posted Date: Sunday, December 15, 2002
Creating a Link Management System
This quick tutorial, shows you how to creat a Link system, that will count the amount of hits that your links create. Author:Alex Allen-Turl Views: 24,099 Posted Date: Tuesday, December 17, 2002
Creating a Voting System
This is a very quick tutorial on how to create a voting system for page relavances and other such things from a scale of 1 to 5! Author:Alex Allen-Turl Views: 26,188 Posted Date: Saturday, December 21, 2002
Creating Dynamic Image Galleries
A tutorial showing you how you can upload one Full sized picture, and have a thumbnail automatically created for you, along with descriptions of the image! Author:Alex Allen-Turl Views: 38,978 Posted Date: Tuesday, December 24, 2002
The Easiest Way to make a form!
This is by far the most easiest and simplest way to make a form and update it to the database, very low maintenance and very very quick!! Author:Alex Allen-Turl Views: 27,854 Posted Date: Tuesday, December 24, 2002
Extensionless Coldfusion
Ever wanted to be like google and run your scripts without an extension? This tutorial shows you how with Apache or IIS! Author:Alex Allen-Turl Views: 18,065 Posted Date: Thursday, October 27, 2005