Web Wiz Support and Community Forums : Converting to MySQL: From Access or MSSQL https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Tue, 07 Apr 2026 00:45:47 +0000 Thu, 18 Dec 2003 13:14:10 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=7547 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Converting to MySQL: From Access or MSSQL : No it&#039;s just saying YEAH...]]> https://forums.webwiz.net/converting-to-mysql-from-access-or-mssql_topic7547_post42121.html#42121 Author: lodogg
Subject: 7547
Posted: 18 December 2003 at 1:14pm

No it's just saying YEAH there are table already here.  It's just letting you know.  But of course you already know this beacuse you imported them from access. 

The reason you have to run the sql setup is to setup the stored procedure in that database that you just imported.

It would be nice to have a script to create the stored procedures rather than doing this work around..

Be Cool

Lo

 

]]> Thu, 18 Dec 2003 13:14:10 +0000 https://forums.webwiz.net/converting-to-mysql-from-access-or-mssql_topic7547_post42121.html#42121 <![CDATA[Converting to MySQL: From Access or MSSQL : -boRg- wrote:No, you still...]]> https://forums.webwiz.net/converting-to-mysql-from-access-or-mssql_topic7547_post42117.html#42117 Author: Joey805
Subject: 7547
Posted: 18 December 2003 at 1:01pm

Originally posted by -boRg- -boRg- wrote:

No, you still need to create the stored procedures, so you need to pull the parts from the sql setup file that create the stored procedures only.

Borg, what happens if you run the entire sql setup script and get some errors about the tables already being created. Would there be anything wrong with doing this? It seems to create all the stored procedures. The forum seems to run fine after. Is there any way you could make a copy of that script that just adds the stored procedures so we dont get the errors?

]]> Thu, 18 Dec 2003 13:01:19 +0000 https://forums.webwiz.net/converting-to-mysql-from-access-or-mssql_topic7547_post42117.html#42117 <![CDATA[Converting to MySQL: From Access or MSSQL : In the next week as it is also...]]> https://forums.webwiz.net/converting-to-mysql-from-access-or-mssql_topic7547_post38314.html#38314 Author: WebWiz-Bruce
Subject: 7547
Posted: 27 November 2003 at 4:52am

In the next week as it is also a security update, if a security bug is found new versions are released faster.]]> Thu, 27 Nov 2003 04:52:17 +0000 https://forums.webwiz.net/converting-to-mysql-from-access-or-mssql_topic7547_post38314.html#38314 <![CDATA[Converting to MySQL: From Access or MSSQL : -boRg- wrote:7.7 has almost...]]> https://forums.webwiz.net/converting-to-mysql-from-access-or-mssql_topic7547_post38312.html#38312 Author: Paul Lush
Subject: 7547
Posted: 27 November 2003 at 4:21am

Originally posted by -boRg- -boRg- wrote:

7.7 has almost very file changed at the moment.

Stupid question but do you have any time scales for 7.7 and/or maybe something 7.x other than fixes to 7.7? With the recent flood of updates, Im putting off the Windows Integrated version

]]> Thu, 27 Nov 2003 04:21:28 +0000 https://forums.webwiz.net/converting-to-mysql-from-access-or-mssql_topic7547_post38312.html#38312 <![CDATA[Converting to MySQL: From Access or MSSQL : 7.7 has almost very file changed...]]> https://forums.webwiz.net/converting-to-mysql-from-access-or-mssql_topic7547_post38310.html#38310 Author: WebWiz-Bruce
Subject: 7547
Posted: 27 November 2003 at 4:17am

7.7 has almost very file changed at the moment.]]> Thu, 27 Nov 2003 04:17:54 +0000 https://forums.webwiz.net/converting-to-mysql-from-access-or-mssql_topic7547_post38310.html#38310 <![CDATA[Converting to MySQL: From Access or MSSQL : Im guessing that the huge difference...]]> https://forums.webwiz.net/converting-to-mysql-from-access-or-mssql_topic7547_post38115.html#38115 Author: Paul Lush
Subject: 7547
Posted: 26 November 2003 at 5:39am

Im guessing that the huge difference between ASP and ASP.NET is going to mean a long wait for it?  Are you intending on supporting the intregrated security model in it?

I'm going to start work on converting 7.60 to Windows intergrated this week so Im hoping 7.7 isnt going to a big upgrade

]]> Wed, 26 Nov 2003 05:39:58 +0000 https://forums.webwiz.net/converting-to-mysql-from-access-or-mssql_topic7547_post38115.html#38115 <![CDATA[Converting to MySQL: From Access or MSSQL : Sorry, to hear that but good to...]]> https://forums.webwiz.net/converting-to-mysql-from-access-or-mssql_topic7547_post38107.html#38107 Author: ljamal
Subject: 7547
Posted: 26 November 2003 at 3:51am

Sorry, to hear that but good to know, since I will be developing an optimized SQL version for my web sites and have been putting off doing so due to the rapid release of new versions. There are so few good classic ASP forums (free or paid) and WWF is one of the best.
Unforunately, Microsoft has almost cornered the .NET forum market, hopefully WWF.net will maintain the same quality as the ASP version.

GMT time will be a great addition. For a site that I'm currently working on, I have been making great use of the getUTCdate() function in SQL 2000 which returns GMT (UTC) time. Unfortunately, such a function does not exist in Access.]]> Wed, 26 Nov 2003 03:51:20 +0000 https://forums.webwiz.net/converting-to-mysql-from-access-or-mssql_topic7547_post38107.html#38107 <![CDATA[Converting to MySQL: From Access or MSSQL : A few things will still be added...]]> https://forums.webwiz.net/converting-to-mysql-from-access-or-mssql_topic7547_post38102.html#38102 Author: WebWiz-Bruce
Subject: 7547
Posted: 26 November 2003 at 3:37am

A few things will still be added to the ASP version but a version 8 probally won't happen.

Version 8 will more than likly be the ASP.NET version. As ASP.NET ismore powerful I'm hoping to add new features like not having to havecookies enabled, setting time off-set by GMT time, better security, etc.
]]> Wed, 26 Nov 2003 03:37:43 +0000 https://forums.webwiz.net/converting-to-mysql-from-access-or-mssql_topic7547_post38102.html#38102 <![CDATA[Converting to MySQL: From Access or MSSQL : Not to derail this thread anymore...]]> https://forums.webwiz.net/converting-to-mysql-from-access-or-mssql_topic7547_post38062.html#38062 Author: ljamal
Subject: 7547
Posted: 25 November 2003 at 5:10pm

Not to derail this thread anymore than it already has been but without taking advantage of the ability to return multiple recordsets, you really aren't fully taking advantage of SQL Server.

Does your move to ASP.NET mean that 7.7 will the last ASP version and what do you propose to do with ASP.NET that isn't available at asp.net?]]> Tue, 25 Nov 2003 17:10:00 +0000 https://forums.webwiz.net/converting-to-mysql-from-access-or-mssql_topic7547_post38062.html#38062 <![CDATA[Converting to MySQL: From Access or MSSQL : Sorry I ment ASP.NET version I&#039;m...]]> https://forums.webwiz.net/converting-to-mysql-from-access-or-mssql_topic7547_post38036.html#38036 Author: WebWiz-Bruce
Subject: 7547
Posted: 25 November 2003 at 4:22pm

Sorry I ment ASP.NET version

I'm won't be making any majour advancedments to the classic ASP version I will be moving onto ASP.NET

The code base for Access and SQL srever will remain the same to makesupport simpler and the forum is already more optimised for SQL serverby using different SQL queries and stored procedures.
]]> Tue, 25 Nov 2003 16:22:41 +0000 https://forums.webwiz.net/converting-to-mysql-from-access-or-mssql_topic7547_post38036.html#38036