Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Converting to MySQL: From Access or MSSQL
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Converting to MySQL: From Access or MSSQL

 Post Reply Post Reply Page  <123
Author
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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 is more powerful I'm hoping to add new features like not having to have cookies enabled, setting time off-set by GMT time, better security, etc.
Back to Top
ljamal View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 16 April 2003
Status: Offline
Points: 888
Post Options Post Options   Thanks (0) Thanks(0)   Quote ljamal Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
Paul Lush View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 24 September 2003
Status: Offline
Points: 59
Post Options Post Options   Thanks (0) Thanks(0)   Quote Paul Lush Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 27 November 2003 at 4:17am
7.7 has almost very file changed at the moment.
Back to Top
Paul Lush View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 24 September 2003
Status: Offline
Points: 59
Post Options Post Options   Thanks (0) Thanks(0)   Quote Paul Lush Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
Joey805 View Drop Down
Groupie
Groupie


Joined: 24 November 2003
Location: United States
Status: Offline
Points: 92
Post Options Post Options   Thanks (0) Thanks(0)   Quote Joey805 Quote  Post ReplyReply Direct Link To This Post 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?

Back to Top
lodogg View Drop Down
Groupie
Groupie


Joined: 22 August 2003
Location: United States
Status: Offline
Points: 161
Post Options Post Options   Thanks (0) Thanks(0)   Quote lodogg Quote  Post ReplyReply Direct Link To This Post 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

 

Just trying to have some fun and learn in the process.
Come have Some Fun
Back to Top
 Post Reply Post Reply Page  <123

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.