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
 Migration Nightmare
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

NetArchitect
Starting Member

USA
26 Posts

Posted - 05 April 2007 :  12:54:18  Show Profile  Visit NetArchitect's Homepage  Send NetArchitect an AOL message  Send NetArchitect an ICQ Message  Send NetArchitect a Yahoo! Message
Hello all...

Well I took the plunge at my employers request and migrated over:
from access to access on steriods ie. (sql7)

And having followed very carefully the migration instructions found here in the forums, I have encountered the following issue.

admin_config_features.asp
admin_config_members.asp
admin_config_datetime.asp
admin_config_email.asp
admin_config_colors.asp
admin_config_badwords.asp
admin_config_namefilter.asp
admin_config_groupcats.asp
admin_avatar_home.asp
admin_accounts_pending.asp
Have all (apparantly) disappeared.

Now I am very aware that there are bugs, and I can get through them all too well, but this is a new (to me) environment, which I might add is a reall step up for me...
but I digress...

Is this a sql issue? There is a common thread here:
They are a admin_config_something or other or
admin_insert file_name.asp

I would greatly appreciate any input here since for me there is no going back now, and truth be told, I really like this new format... if i can get it to work right.

Thanks all

Mykal

-We don't need Alien Races to come from other planets to Steal Our Children - We have CPS for that and they wouldn't take too kindly to some Outsider cutting in on their Action-

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 05 April 2007 :  12:58:52  Show Profile
Disappeared as in they're throwing 404s?


Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Go to Top of Page

pdrg
Support Moderator

United Kingdom
2897 Posts

Posted - 05 April 2007 :  13:01:17  Show Profile  Send pdrg a Yahoo! Message
.asp files are a webserver (IIS) question, not a SQL Server question.

P.S. SQL7 is out of mainstream and into extended support now http://support.microsoft.com/kb/912251 it's considered an old nearing obsolete product (even though it's still a great codebase). If you didn't get an extended support agreement for it about a year ago, it's basically unsupported now.

edit - typos, more info

Edited by - pdrg on 05 April 2007 13:04:24
Go to Top of Page

NetArchitect
Starting Member

USA
26 Posts

Posted - 05 April 2007 :  13:02:08  Show Profile  Visit NetArchitect's Homepage  Send NetArchitect an AOL message  Send NetArchitect an ICQ Message  Send NetArchitect a Yahoo! Message
Technical Information (for support personnel)

Go to Microsoft Product Support Services and perform a title search for the words HTTP and 404.
Open IIS Help, which is accessible in IIS Manager (inetmgr), and search for topics titled Web Site Setup, Common Administrative Tasks, and About Custom Error Messages

-We don't need Alien Races to come from other planets to Steal Our Children - We have CPS for that and they wouldn't take too kindly to some Outsider cutting in on their Action-
Go to Top of Page

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 05 April 2007 :  13:03:26  Show Profile
In that case, just upload those files again.


Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Go to Top of Page

NetArchitect
Starting Member

USA
26 Posts

Posted - 05 April 2007 :  13:04:47  Show Profile  Visit NetArchitect's Homepage  Send NetArchitect an AOL message  Send NetArchitect an ICQ Message  Send NetArchitect a Yahoo! Message
sorry... i meant 2007

-We don't need Alien Races to come from other planets to Steal Our Children - We have CPS for that and they wouldn't take too kindly to some Outsider cutting in on their Action-
Go to Top of Page

pdrg
Support Moderator

United Kingdom
2897 Posts

Posted - 05 April 2007 :  13:12:14  Show Profile  Send pdrg a Yahoo! Message
quote:
Originally posted by NetArchitect

sorry... i meant 2007




2005, maybe?
Go to Top of Page

NetArchitect
Starting Member

USA
26 Posts

Posted - 05 April 2007 :  13:18:06  Show Profile  Visit NetArchitect's Homepage  Send NetArchitect an AOL message  Send NetArchitect an ICQ Message  Send NetArchitect a Yahoo! Message
dangit... I mean its sqlserver 2000 and were migrating to 2005 in 2007
\

-We don't need Alien Races to come from other planets to Steal Our Children - We have CPS for that and they wouldn't take too kindly to some Outsider cutting in on their Action-

Edited by - NetArchitect on 05 April 2007 13:23:23
Go to Top of Page

NetArchitect
Starting Member

USA
26 Posts

Posted - 05 April 2007 :  13:21:06  Show Profile  Visit NetArchitect's Homepage  Send NetArchitect an AOL message  Send NetArchitect an ICQ Message  Send NetArchitect a Yahoo! Message
I guess what I am wondering is is there something in the change from access tables, to sql tables, that perhaps the double underscores in the same line caused them to not be seen anymore?
I am at a loss as to why they are no longer accesable from the admin options

-We don't need Alien Races to come from other planets to Steal Our Children - We have CPS for that and they wouldn't take too kindly to some Outsider cutting in on their Action-
Go to Top of Page

pdrg
Support Moderator

United Kingdom
2897 Posts

Posted - 05 April 2007 :  13:22:28  Show Profile  Send pdrg a Yahoo! Message
No, not the antiquated SQL Server 200? That's like 1800 years old! My guess is you're migating to Win 2K3 Server, possibly SQL Server 2000, possibly 2005. Both good, but 2005 will be supported for 5 years longer...
Go to Top of Page

pdrg
Support Moderator

United Kingdom
2897 Posts

Posted - 05 April 2007 :  13:24:29  Show Profile  Send pdrg a Yahoo! Message
quote:
Originally posted by NetArchitect

I guess what I am wondering is is there something in the change from access tables, to sql tables, that perhaps the double underscores in the same line caused them to not be seen anymore?
I am at a loss as to why they are no longer accesable from the admin options


Are the files visible on your webserver? ASP (.asp) files are entirely unrelated to the database, and only to the web server, so check the files are there first, then you may have some virtual paths problem, or something. The DB is innocent
Go to Top of Page

NetArchitect
Starting Member

USA
26 Posts

Posted - 05 April 2007 :  13:25:36  Show Profile  Visit NetArchitect's Homepage  Send NetArchitect an AOL message  Send NetArchitect an ICQ Message  Send NetArchitect a Yahoo! Message
OS Name Microsoft(R) Windows(R) Server 2003, Standard Edition
Version 5.2.3790 Service Pack 2 Build 3790
Other OS Description R2
OS Manufacturer Microsoft Corporation
System Name R-D8HT54XP2RJKQ
System Manufacturer Dell Computer Corporation
System Model PowerEdge 600SC
System Type X86-based PC
Processor x86 Family 15 Model 2 Stepping 7 GenuineIntel ~2399 Mhz
BIOS Version/Date Dell Computer Corporation A02, 9/4/2002
SMBIOS Version 2.3
Windows Directory C:\WINDOWS
System Directory C:\WINDOWS\system32
Boot Device \Device\HarddiskVolume2
Locale United States
Hardware Abstraction Layer Version = "5.2.3790.3959 (srv03_sp2_rtm.070216-1710)"
User Name R-D8HT54XP2RJKQ\Administrator
Time Zone Central Daylight Time
Total Physical Memory 511.46 MB
Available Physical Memory 158.45 MB
Total Virtual Memory 1.23 GB
Available Virtual Memory 605.54 MB
Page File Space 768.00 MB
Page File C:\pagefile.sys

-We don't need Alien Races to come from other planets to Steal Our Children - We have CPS for that and they wouldn't take too kindly to some Outsider cutting in on their Action-
Go to Top of Page

NetArchitect
Starting Member

USA
26 Posts

Posted - 05 April 2007 :  13:26:45  Show Profile  Visit NetArchitect's Homepage  Send NetArchitect an AOL message  Send NetArchitect an ICQ Message  Send NetArchitect a Yahoo! Message
Okay... ty very much ill get on that...
Very Much Appreciated
:)

-We don't need Alien Races to come from other planets to Steal Our Children - We have CPS for that and they wouldn't take too kindly to some Outsider cutting in on their Action-
Go to Top of Page

pdrg
Support Moderator

United Kingdom
2897 Posts

Posted - 05 April 2007 :  15:05:31  Show Profile  Send pdrg a Yahoo! Message
PS you may want to look at sticking some more RAM in that box, 512M for W2K3S, IIS and MSSQL Server really isn't enough - if you can afford 4Gigs RAM, put it in, otherwise at least 2Gigs
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.12 seconds. Powered By: Snitz Forums 2000 Version 3.4.07