Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS SQL Server
 Moving to SQL 2000		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

hzaidi
Starting Member

USA
45 Posts
Posted - 12 October 2007 :  13:01:45  Show Profile
I have SQL 2000 Server. I would like to setup the application by using that instead. I see the blank Access database (before setup). It looks almost like I just need to create tables within a database and create tables exactly like in the access file with same columns and datatypes.

Any eaiser suggestions.

AnonJr
Moderator

United States
5768 Posts
Posted - 12 October 2007 :  13:04:34  Show Profile  Visit AnonJr's Homepage
Just change the connection string in config.asp and run setup.asp - it will create the tables for you. If you have to move any data there's a good tutorial floating around here somewhere.
Go to Top of Page

hzaidi
Starting Member

USA
45 Posts
Posted - 12 October 2007 :  13:05:19  Show Profile
So what your saying is create a blank database within SQL named like snitz and point the config.asp to that.

It will start populating tables in that database.
Edited by - hzaidi on 12 October 2007 13:07:03
Go to Top of Page

AnonJr
Moderator

United States
5768 Posts
Posted - 12 October 2007 :  13:26:58  Show Profile  Visit AnonJr's Homepage
Yes. Create an empty database and set config.asp to use it. Then, go to setup.asp and it will create the tables for you.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.16 seconds. Powered By: Snitz Forums 2000 Version 3.4.07