https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 15:02:26 +0000 Sun, 04 Jun 2006 12:37:54 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=20166 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/sqlserver-problems_topic20166_post108392.html#108392 Author: Flyman30
Subject: 20166
Posted: 04 June 2006 at 12:37pm

-boRg- wrote: The simplest way I have found, but requires MS SQL Server and Access installed on your local machine and a second SQL Server at your web host, is:-    1. Create the database a blank SQL Server database at your web host    2. 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    3. 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.    4. Now on your local machine open your original Access database in Access          1. From the Tools menu in Access, select the 'Upsize Wizard'          2. Choose the Upsize option to 'Create a new database'          3. Choose 'local as your SQL Server and 'Use Trusted Connection'          4. Next select ALL the tables to upsize          5. Leave all other options as default    5. Once your database tables have been upsized using this method, use the 'Export Tool' in Enterprise Manager to upload the tables to the SQL Server database at your web host which you created the Stored Procedures in earlier    6. That should be it

It's works perfectly on my local server, the forum run as well, so i use the 'Export Tool' in Enterprise Manager to upload the tables to the SQL Server database at my web host but if i want do something i get this error message:

Server Error in Forum Application An error has occured while writing to the database. Please contact the forum administrator. Support Error Code:- err_SQLServer_save_new_post_data File Name:- new_post.asp Error details:- ADODB.Recordset The set of recordings according to does not take charges the update of it. It is perhaps about a limitation of the supplier or type of selected bolt.

what does it occur ? 

Edited by Flyman30 - 04 June 2006 at 12:43pm]]> Sun, 04 Jun 2006 12:37:54 +0000 https://forums.webwiz.net/sqlserver-problems_topic20166_post108392.html#108392