Web Wiz 8x -- Access to MS SQL success
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=22087
Printed Date: 28 March 2026 at 6:03am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Web Wiz 8x -- Access to MS SQL success
Posted By: kkimber
Subject: Web Wiz 8x -- Access to MS SQL success
Date Posted: 01 December 2006 at 12:05pm
|
We use the 8.04 access database edition and trying to convert mssql database. That operation total 3 days cuz "support forum", "support pages", "support email" and google cant be explain convert document or wrong documents/technics. 3 days trying and we successfuly convert the db's. Correct technic explanation step by step guide; Recommended softwares, office 2003 pro, sql 2000/2005 01-) Stop the webwiz forum "web site" and stop the your site "application pool" on iis. (Recommended, cuz if you copy the database file and site is open database possible corroupted) 01a-) Install office 2003 pro 01b-) Intall sql 2000/2005 server, !WARNING! if your forum language different of english; install screen select the "custom" installion method and select correct language configs. 01b Custom - example-) collation designator: Turkish - sort order: checked, accent sensitive. 02-) "Must" backup or different location to copy access db. 03-) Open office professional 2003 access. 04-) File - open - select the yours database file and click ok. 05-) If popup appears the security warning click open and see the title "xxxxxxxx: datasabe (Access 2000 file format)". 06-) Tools - database utilities - upsizing wizard - create new database - next. 07-) Select the sql server machine name or ip address (local, xxx, n.n.n.n) - checked, use trusted connection or u/p - name of the new database or same name old database - next. 08-) Available tables, click ">>" - next. 09-) Don't change anything (checkout timestamp field is "no, never") - next. 10-) Don't change anything - next. 11-) Don't change anything - finish. 12-) Security warning screen appears 2-3 times click open - waiting the sending data screen/s... (1-30 mins.) 13-) Check/see/find the errors in the upsizing report screen 30 pages. 14-) Close the access. 15-) Open enterprise manager under the sql server program groups. 16-) Expand the tree and select the database name (item 07). 17-) !WARNING! Different language users (forum, username is "not only" english character set) right click - properties checkout the "collation name: xxxx". 17a-) If collation name is "Latin", members different chacarter set usernames cannot login the forum! and/or administrator cannot login the "admin section" and/or members section only search english character set members. 17b-) Solve the problem is; close the properties screen - select the database name (item 07) - tools - sql query analyzer - now you can see the button bar your database name or select the database name. 17c-) Close the "sql server manager", not "sql query analyzer" window. 17d-) Write the following commands; USE tempdb GO ALTER DATABASE your-database-name COLLATE your-language_CI_AS GO 17e-) Do not change the "tempdb" and "_CI_AS". 17f-) Click the execute icon on button bar ">" (color is green) and waiting 0-5 mins. 17g-) Checkout the bottom window "the command(s) completed successfully." message. 17h-) Open the "sql server manager" go to (item 15). 18-) Now your new database is ready. 19-) Download the "web wiz forum sql server version" and follow the install/upgrade instructions. REMEMBER, Do not overwrite the "forum_images, language_files, uploads, css_styles" directorys. :-) 20-) If forum members can't be login and/or admin section can't be login; "functions/functions_session_data.asp" edit the file "Const blnDatabaseHeldSessions = False" and change the True. 21-) If forum session timeout problems appears and/or search section sometimes "permission error" messages appears, change the common.asp "Session.Timeout = 20" to 60. 22-) Done. Thank's the TurkClubber web/forum hosting provider AGG. |
Replies:
Posted By: ozankantar
Date Posted: 03 December 2006 at 2:21am
| thanx kkimber, perfect. |
Posted By: bims
Date Posted: 30 January 2007 at 3:31pm
| This works for v8.05? |
Posted By: kkimber
Date Posted: 03 February 2007 at 7:28am
| yes i tested. its work. |
Posted By: shamel
Date Posted: 15 March 2007 at 8:18pm
|
thank you very much
i've done every thing you said
the problem is , after step 15 how will the converted database be transfered to my site?
thank you all again.
|
Posted By: dglasgo1
Date Posted: 09 April 2007 at 1:07pm
|
I've started from a 7.9 version (MS ACCESS). Successfully upgraded to 8.05a (MS ACCESS). Installed SQL Express - and Upsized the DB following all the steps. Now I'm stuck, after downloading the SQL version of Web Wiz, I replaced all the ASP files in the forum folders - and edited the database_connection.asp page to include my SQL server details.. but I keep getting the error: Server Error in Forum Application An error has occured while connecting to the database. Please contact the forum administrator. Support Error Code:- err_SQLServer_db_connection File Name:- common.asp Error details:- Microsoft OLE DB Provider for SQL Server Invalid connection string attribute Any ideas what this usually would come from? I've tried adjusting the account and servername, but i keep getting the same error. Similar problem when running the msSQL_server_setup.asp file - that one returns: Check the following is set up and correct:- SQL Server User Name SQL Server Password Name of the SQL Server Database name set up by you on the server Empty Database set up by you on the SQL Server If anyone else has run across this, it's be a huge help :) Clearly it's something in my SQL setup, and I must be doing something dumb. I feel like I've tried everything. I created a blank database (although I'd like to use the one I've upsized) - and created a new user in SQL. For Sever Name - I've tried using 'local' - and referring to it as MSSQLSERVER, SQLEXPRESS, and the servername itself. Anything else I can try? Would it say could not find server if this was wrong? Thanks for any help you can provide!! -Don |
Posted By: WebWiz-Bruce
Date Posted: 09 April 2007 at 1:27pm
|
With SQL Express make sure you install it in mixed mode with TCP/IP connections enabled. Then to connect to it using the default instance from localhost use:- localhost\SQLEXPRESS ------------- 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: onurkaya
Date Posted: 16 April 2007 at 12:37pm
| hi, i tried but I got cbool errors. please help. |
Posted By: kratochvil
Date Posted: 20 May 2007 at 9:18am
|
install new forum version 8.05a and this error
Support Error Code:- err_SQLServer_db_connection
File Name:- common.asp Error details:- Microsoft OLE DB Provider for SQL Server Invalid connection string attribute what this error help me please
forum closed don't opened, this error
excusme no english
 |
Posted By: Craig
Date Posted: 04 June 2007 at 7:41am
|
I have been running the access version without any problems but only because I haven't been able to get the SQL version connected to create the tables. Here what I've done so far per your previous post:
--------------------------------------------------------------------------------------------
Here's what my database_connection.asp file looks like:
strSQLServerName = "localhost\SQLEXPRESS" 'Holds the name of the SQL Server (This is the name/location or IP address of the SQL Server)
strSQLDBUserName = "sa" 'Holds the user name (for SQL Server Authentication) strSQLDBPassword = "*******" 'Holds the password (for SQL Server Authentication) strSQLDBName = "test_db" 'Holds the name of the database Note: The "sa" account has db creator roles assigned. I have also created another account and assigned it with these permissions, made the changes to the database_connection .asp file to reflect these changes and then tried logging in again with the new account from the "msSQL_server_setup.asp" page but still to no avail. I feel as though I've tried every combination of logging in. Obviously there's something I'm doing wrong so if anyone can identify that from what I've just explained then I woudl greatly appreciate it.
-------------------------------------------------------------------
Here's what I get when I try and connect:
Error Connecting to database on SQL Server
Check the following is set up and correct:- SQL Server User Name SQL Server Password Name of the SQL Server Database name set up by you on the server Empty Database set up by you on the SQL Server Check also that you have entered the correct details in the file 'database_connection.asp' found in the 'database' directory.
Thanks for any help folks, Craig
|
Posted By: Craig
Date Posted: 11 June 2007 at 5:19am
Final got my mssql db installed and connected. After trying for 2 weeks, I couldn't say what I did different as I feel as though I did all I could, but hey its working so thanks to all the posts here. Without them I think I would have a few more weeks in figuring this one out.
Thanks a million.
|
Posted By: Craig
Date Posted: 15 June 2007 at 5:42am
|
The following steps is by far the easiest way to migrate from an access db to ms sql. I found this from a newsgroup and the instructions are right on the money. I was migrated within 4 minutes. Prerequisites
Download Links .Net Framework Version 2.0 o http://msdn.microsoft.com/netframework/downloads/updates/#.NET%20Framework%202.0%20Beta%20SDK%20and%20Redistributable - http://msdn.microsoft.com/netframework/downloads/updates/#.NET%20Framework%202.0%20Beta%20SDK%20and%20Redistributable SQL Server 2005 o http://www.microsoft.com/sql/downloads/default.mspx - http://www.microsoft.com/sql/downloads/default.mspx MS Visual J# Version 2.0 o http://www.microsoft.com/downloads/details.aspx?familyid=F72C74B3-ED0E-4AF8-AE63-2F0E42501BE1&displaylang=en - http://www.microsoft.com/downloads/details.aspx?familyid=F72C74B3-ED0E-4AF8-AE63-2F0E42501BE1&displaylang=en SSMA for Access
|
Posted By: manos2000
Date Posted: 18 July 2007 at 1:09am
|
everything gone fine, database in sql20005 created but after running the forum can not see any post even if number of topics and posts is correct.
Any idea?
thanks
|
Posted By: iamzaga
Date Posted: 17 November 2007 at 4:18pm
|
really great, thanks my friend
------------- Maybe want to visit http://www.acotm.com - free directory or http://www.malatya.us - Malatya |
Posted By: romadhon
Date Posted: 09 January 2008 at 3:27pm
|
i can not connect to sql server because that sql have an user account i have to klik trusted connect. |
Posted By: romadhon
Date Posted: 10 January 2008 at 5:10am
|
where i can create user n password to fill in connectiop.asp? and what servername i can fill that? |
Posted By: romadhon
Date Posted: 10 January 2008 at 11:49am
|
thanks god i can convert ms access to mssql but.. i can't connect it from dataconnection because i can't connect the mssql where i'am use my user but i have to use trusted user so, what i fill in dataconnection.asp? can you tell me what a password of user "sa" ? Thanks so much |
Posted By: WebWiz-Bruce
Date Posted: 10 January 2008 at 12:01pm
|
You can not use a trusted connection when connecting from ASP as you are using a TCP/IP connection. SQL Server needs to be installed in mixed mode with TCP/IP connections enabled. You then need to either login using the built in sa account or create a user is 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: romadhon
Date Posted: 10 January 2008 at 11:48pm
|
i'am use sqlexpress. what can i do for it? i tried create user in SQL. but it can't connect too. so? |
Posted By: WebWiz-Bruce
Date Posted: 11 January 2008 at 9:47am
|
You need to install SQL Express in mixed mode. By default SQl Express installs with the instance name SQLEXPESS so you would use the following to connect on a localhost machine:- localhost/SQLEXPRESS ------------- 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: manos2000
Date Posted: 18 February 2008 at 9:17pm
|
When migrating the database from access to MSSQL is the any need to change any file except connections.asp?
I changed only this (left acces version files) and works ok with MSSQL db.
regards
manos
|
Posted By: lordtec
Date Posted: 05 September 2009 at 4:36pm
|
This conversion is for MySQL 5.1 or SQL Server 2005?
Is there a difference? |
Posted By: WebWiz-Bruce
Date Posted: 07 September 2009 at 1:53pm
|
This is for Microsoft SQL Server 2005 or 2008 which is a translational database system produced by Microsoft. mySQL 5.1 is a free database system now owned by Sun Microsystems. it is not a relational database systems and has different data types, so databases written for mySQL often need a very different schema to that of Access and 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 |