Converting to MS SQL problem
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=12894
Printed Date: 11 April 2026 at 9:04pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Converting to MS SQL problem
Posted By: ukakht
Subject: Converting to MS SQL problem
Date Posted: 09 December 2004 at 3:21am
|
I am using a shared database from another SQL server, I've entered the database details in this form:
strSQLServerName = "64.64.65.69.69" strSQLDBUserName = "blahblahusername"
strSQLDBPassword = "blahpassword"
strSQLDBName = "blahdatabase"
Could_not_find_stored_procedure_ Please Please help me in this, and give me tips on what to do
 I want to move my forum to MSSQL as soon as,  Because my forum became popular and server crashed 4 times, and server admin is saying that move to MS SQL HELP!!!!!!!! |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 09 December 2004 at 5:00am
|
The MS SQL server version uses stotred procedures that need to be created on the MS SQL Server. You maybe better downloading the MS SQL Server version, using the serup file to create the database and stored procedures, then importing the data into the database. Do a search of the forum as quite a number of people have posted on how they moved across to MS SQL Server. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: ukakht
Date Posted: 09 December 2004 at 6:49am
|
borg, I will really appreciate if you point me to the topic where there is the exact solution and a working solution,
Waiting
|
Posted By: WebWiz-Bruce
Date Posted: 09 December 2004 at 7:56am
|
Evryone seems to do it in different ways, so just do a search about
this and read through some of the returned posts about how others ahve
done this.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: ukakht
Date Posted: 09 December 2004 at 3:27pm
|
I'v moved all the data via enterprise, ! things working fine, Look at: http://www.dargai.com/forum2 - http://www.dargai.com/forum2
 But it says There are no Forums to display
, It's not showing all the data in the forum , but in the database all the data is there! it just doesn't display all the data, PLEASE Please Please Please Please,.....................
I need help... where are the guys who have converted their forum successfully some one help me, BTW: My forum is having 25,000 rows Please !
|
Posted By: michael
Date Posted: 09 December 2004 at 4:39pm
|
Are you sure your server is configured right? Meaning a username that has permissions etc? When I try to register on your forum I get Microsoft OLE DB Provider for SQL Server error '80004005' The cursor does not include the table being modified or the table is not updatable through the cursor. /forum2/register.asp, line 969 Is your SQL Server a linked server and ist the db possibly owned by a remote user and not dbo?------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: ukakht
Date Posted: 10 December 2004 at 3:01am
| How can I set those permissions ? |
Posted By: ukakht
Date Posted: 10 December 2004 at 3:54am
| The database is on a remote server. It's owned by both the remote user and dbo |