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

mafifi
Junior Member

USA
308 Posts
Posted - 03 July 2002 :  22:42:31  Show Profile
I am getting this error when I try to setup http://www.mydomain.com/forums/setup.asp
 
Active Server Pages error 'ASP 0240' 

Script Engine Exception 

/forums/setup.asp 

A ScriptEngine threw expection 'C0000005' in 'IActiveScriptParse::ParseScriptText()' from 'CActiveScriptEngine::AddScriptlet()'.


Here is my config.asp


strConnString = "Provider=SQLOLEDB;Data Source=my_server_name;Initial Catalog=Database_Name;User ID=xxxxxx;Password=xxxxxxxx"

I am the "dbo".

Thanks,

Mo

mafifi
Junior Member

USA
308 Posts
Posted - 03 July 2002 :  23:23:33  Show Profile
This error was caused by a crashed server. Now I have a different error message:
 Microsoft OLE DB Provider for SQL Server error '80040e37' 

Invalid object name 'FORUM_MEMBERS'. 

/forums/setup_login.asp, line 80


Here are lines 73-80
 '## Forum_SQL
	strSql = "SELECT COUNT(*) AS ApprovalCode "
	strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS "
	strSql = strSql & " WHERE M_NAME = '" & Name & "' AND "
	strSql = strSql & "       M_PASSWORD = '" & Password & "' AND "
	strSql = strSql & "       M_LEVEL = 3"
	
	Set dbRs = my_Conn.Execute(strSql)


Thanks,

Mo

Edited by - mafifi on 03 July 2002 23:26:30

Edited by - mafifi on 03 July 2002 23:30:27
Go to Top of Page

mike hiddleston
Starting Member

United Kingdom
2 Posts
Posted - 04 July 2002 :  06:44:24  Show Profile
Hey, I've just upgraded my database from Access 97 to SQL Server 6. I must admit i'm a bit of a novice when it comes to MS SQL Server, but I'm also getting this error. Any help out there??
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 04 July 2002 :  07:17:42  Show Profile
quote:

This error was caused by a crashed server. Now I have a different error message:
[code] Microsoft OLE DB Provider for SQL Server error '80040e37'

Invalid object name 'FORUM_MEMBERS'.

Run setup.asp like this: setup.asp?RC=5

-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 04 July 2002 :  07:25:25  Show Profile
quote:

Hey, I've just upgraded my database from Access 97 to SQL Server 6. I must admit i'm a bit of a novice when it comes to MS SQL Server, but I'm also getting this error. Any help out there??

How did you upgrade? Did you use the Access Upsizing Wizard?

If you did use the upsizing wizard, then you'll need to delete your forum tables and use the process recommended for upgrading the forum:

Have a blank database at your server (or a database without tables for the forum). Run setup.asp?RC=5, after you configure config.asp to point to your SQL Server database, so that you create the SQL Server tables properly (something the Access upsizing wizard won't do). Then use DTS to import the data from Access.

I never used SQL 6 and it's possible there is no DTS to import data. I don't know. It also seems to me a bit weird that you decided to use such and old database server for this...

Anyway, the upgrade process you used does not work. If you don't have DTS in SQL 6, maybe there is something similar. Try to find that. Maybe someone else here can help with that also (Doug G)...

-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Go to Top of Page

mike hiddleston
Starting Member

United Kingdom
2 Posts
Posted - 04 July 2002 :  08:53:59  Show Profile
All sorted, my problem was actually caused by the connection string. I was simply using 'dsn=hwnet;' insteadt of 'dsn=hwnet;uid=xxxx;pwd=xxxx;

Many thanks everybody. I knew the answer would be in here somewhere.

Mike
Go to Top of Page

mafifi
Junior Member

USA
308 Posts
Posted - 04 July 2002 :  12:13:47  Show Profile
quote:
Run setup.asp?RC=5


That did it. It's worknig fine now (SQL 2000)

Thanks,

Mo
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 04 July 2002 :  12:21:45  Show Profile
You're welcome .

-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
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.24 seconds. Powered By: Snitz Forums 2000 Version 3.4.07