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
 No tables created
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Jesper Kinnås
Starting Member

2 Posts

Posted - 25 July 2002 :  04:16:11  Show Profile
Hi!

I am trying to upgrade from Access to SQL server 2000. This is what I have done:

* Created an empty db
* Created a login, and gave it db_owner rights on the new database
* run setup.asp?RC=5
* I got a screen "Installation of forum-tables in the database"
* I entered the new user and pwd
* I pressed Continue
* I got "Please wait until..."
* "The installation has been completed"

So far so good.

But when I check the database in the Enterprise Manager, no tables has been created! When trying to login I get the following:

Microsoft OLE DB Provider for ODBC Drivers fel '80040e37'

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'FORUM_MEMBERS'.

/konf/setup_login.asp, rad 80

Strange?

Please, help me!

/Jesper


Jesper Kinnås
Starting Member

2 Posts

Posted - 25 July 2002 :  05:53:47  Show Profile
I solved it!

I forgot to uncomment strDBType = "sqlserver"

Have a nice day!

/J

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.19 seconds. Powered By: Snitz Forums 2000 Version 3.4.07