Web Wiz Support and Community Forums : Converting to MS SQL problem https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 19:29:55 +0000 Fri, 10 Dec 2004 03:54:16 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=12894 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Converting to MS SQL problem : The database is on a remote server....]]> https://forums.webwiz.net/converting-to-ms-sql-problem_topic12894_post71499.html#71499 Author: ukakht
Subject: 12894
Posted: 10 December 2004 at 3:54am

The database is on a remote server.  It's owned by both the remote user and dbo
]]> Fri, 10 Dec 2004 03:54:16 +0000 https://forums.webwiz.net/converting-to-ms-sql-problem_topic12894_post71499.html#71499 <![CDATA[Converting to MS SQL problem : How can I set those permissions...]]> https://forums.webwiz.net/converting-to-ms-sql-problem_topic12894_post71497.html#71497 Author: ukakht
Subject: 12894
Posted: 10 December 2004 at 3:01am

How can I set those permissions ?
]]> Fri, 10 Dec 2004 03:01:04 +0000 https://forums.webwiz.net/converting-to-ms-sql-problem_topic12894_post71497.html#71497 <![CDATA[Converting to MS SQL problem : Are you sure your server is configured...]]> https://forums.webwiz.net/converting-to-ms-sql-problem_topic12894_post71470.html#71470 Author: michael
Subject: 12894
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?
]]> Thu, 09 Dec 2004 16:39:48 +0000 https://forums.webwiz.net/converting-to-ms-sql-problem_topic12894_post71470.html#71470 <![CDATA[Converting to MS SQL problem : I&#039;v moved all the data via...]]> https://forums.webwiz.net/converting-to-ms-sql-problem_topic12894_post71464.html#71464 Author: ukakht
Subject: 12894
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  Cry
 
But it says There are no Forums to display Cry,

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 Cry some one help me,

BTW: My forum is having 25,000 rows
 
Please !
 
]]> Thu, 09 Dec 2004 15:27:50 +0000 https://forums.webwiz.net/converting-to-ms-sql-problem_topic12894_post71464.html#71464 <![CDATA[Converting to MS SQL problem : Evryone seems to do it in different...]]> https://forums.webwiz.net/converting-to-ms-sql-problem_topic12894_post71422.html#71422 Author: WebWiz-Bruce
Subject: 12894
Posted: 09 December 2004 at 7:56am

Evryone seems to do it in different ways, so just do a search aboutthis and read through some of the returned posts about how others ahvedone this.]]> Thu, 09 Dec 2004 07:56:57 +0000 https://forums.webwiz.net/converting-to-ms-sql-problem_topic12894_post71422.html#71422 <![CDATA[Converting to MS SQL problem : borg, I will really appreciate...]]> https://forums.webwiz.net/converting-to-ms-sql-problem_topic12894_post71419.html#71419 Author: ukakht
Subject: 12894
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
]]> Thu, 09 Dec 2004 06:49:35 +0000 https://forums.webwiz.net/converting-to-ms-sql-problem_topic12894_post71419.html#71419 <![CDATA[Converting to MS SQL problem : The MS SQL server version uses...]]> https://forums.webwiz.net/converting-to-ms-sql-problem_topic12894_post71415.html#71415 Author: WebWiz-Bruce
Subject: 12894
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 serupfile to create the database and stored procedures, then importing thedata 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.
]]> Thu, 09 Dec 2004 05:00:30 +0000 https://forums.webwiz.net/converting-to-ms-sql-problem_topic12894_post71415.html#71415 <![CDATA[Converting to MS SQL problem : Hello , I&#039;ve just imported...]]> https://forums.webwiz.net/converting-to-ms-sql-problem_topic12894_post71409.html#71409 Author: ukakht
Subject: 12894
Posted: 09 December 2004 at 3:21am

CryHello ,

I've just imported all the data of the wwForum.mdb file via the SQL Enterprise manager  and its imported successfully to the MS SQL database,

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"
 
But when I access the forum it giving error of:
Could_not_find_stored_procedure_
 
Please Please help me in this, and give me tips on what to do CryCryCry I want to move my forum to MSSQL as soon as, Confused Because my forum became popular and server crashed 4 times, and server admin is saying that move to MS SQL

HELP!!!!!!!!
 
 
]]> Thu, 09 Dec 2004 03:21:55 +0000 https://forums.webwiz.net/converting-to-ms-sql-problem_topic12894_post71409.html#71409