Big database problem (.ldb servertimeout)

Post Reply

Page <123 >

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
dpyers Members Profile Find Members Posts Senior Member Joined: 12 May 2003 Status: Offline Points: 3937	Post Options Post Reply Quote dpyers Report Post Thanks(0) Quote Reply Posted: 18 February 2005 at 9:52am
	You might also want to try doing a compact and repair against the access db. Then shut the forum down and delete any left over .ldb files before restarting it. Your ultimate solution though is MS SQL.
	Lead me not into temptation... I know the short cut, follow me.

NeutralizeR Members Profile Find Members Posts Newbie Joined: 14 December 2004 Location: Turkey Status: Offline Points: 35	Post Options Post Reply Quote NeutralizeR Report Post Thanks(0) Quote Reply Posted: 18 February 2005 at 10:02am
	I've succesfully converted my Access database to SQL Server. I've made the required changes such as 'Database Type 'strDatabaseType = "Access" strDatabaseType = "SQLServer" in both common.asp files... Then i edited the sections below: 'Enter the details of your SQL server below strSQLServerName = "WEBSRVR" 'Holds the name of the SQL Server strSQLDBUserName = "my name" 'Holds the user name (for SQL Server Authentication) strSQLDBPassword = "my pass" 'Holds the password (for SQL Server Authentication) strSQLDBName = "my database" 'Holds name of a database on the server i go to http://www.msxlabs.com/forum it says the forum is closed... it's ok... then i go to http://www.msxlabs.com/forum/admin trying to login with my id but it says HTTP 500 error.. is it a database connection problem ??? what should i do... i've tried several alternative server names... localhost, WEBSRVR, direkt ip.... :( what's wrong ?

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 18 February 2005 at 10:06am
	I get the same error at both pages:- Microsoft OLE DB Provider for SQL Server error '80040e4d' Login failed for user 'NeutralizeR'. Looks like a login problem at the sql server. You may need to turn off friendly HTTP error messages if you use IE
	Web Wiz Forums Hosting ASP.NET Web Hosting

NeutralizeR Members Profile Find Members Posts Newbie Joined: 14 December 2004 Location: Turkey Status: Offline Points: 35	Post Options Post Reply Quote NeutralizeR Report Post Thanks(0) Quote Reply Posted: 18 February 2005 at 11:47am
	Ok... My new SQL Database is working now. I can login as admin and see the statistics vs... But i can't make any changes... I'd locked my forum when it was Access... New SQL Server is locked, too... how can i unlock it again ? it doesn't let me to do this... Everytime i try to change something http 500 error occurs...

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 18 February 2005 at 12:02pm
	You need to turn off friendly HTTP errors in IE, then the error message will help find what the problem is.
	Web Wiz Forums Hosting ASP.NET Web Hosting

NeutralizeR Members Profile Find Members Posts Newbie Joined: 14 December 2004 Location: Turkey Status: Offline Points: 35	Post Options Post Reply Quote NeutralizeR Report Post Thanks(0) Quote Reply Posted: 18 February 2005 at 12:07pm
	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. /forum/admin/close_forums.asp, line 89

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 18 February 2005 at 12:20pm
	This means that the method you used to upsize your database from Access to SQL Server has not worked.
	Web Wiz Forums Hosting ASP.NET Web Hosting

NeutralizeR Members Profile Find Members Posts Newbie Joined: 14 December 2004 Location: Turkey Status: Offline Points: 35	Post Options Post Reply Quote NeutralizeR Report Post Thanks(0) Quote Reply Posted: 19 February 2005 at 8:36am
	Create the database a blank SQL Server database at your web host Run the 'msSQL_server_setup.asp' file to create the database tables, Stored Procedure's etc. on your SQL Server database at your web host Use Enterprise Manager to delete ALL the newly created tables on the SQL Server database created at your web host, just leaving the Stored Procedures. .......... Stored Procedures ? What's it ?

Post Reply	Page <123 >

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum