473,687 Members | 3,706 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

confused about access / sql database / sql server / php !! .. help please

i am running a website on Windows 2000 server with ASP 3 webpages and
Access 2000 database. (with a hosting company)
traffic is slow at this time but expect to grow. lately i have been
reading about sql database and sql server, specially this article:
http://www.aspfaq.com/show.asp?id=2195

will someone help me understand:

1. with *SQL Server*, do i keep my current Access 2000 database and
ASP pages?
if not, then -
a. what sort of DB i will need? (we r a non profit, so need
inexpensive things)
b. will ASP pages need be redesigned? how big/difficult is that
transition?

2. if i start using *SQL database*, then which SQL database?

3. Where does *mySQL* fit in this scene?

4. What do i do with my current ASP webpages?

5. i guess, i will need an SQL server if i have to use SQL database?
any recommendations for a cheaper hosting company?
Jul 19 '05 #1
3 3346
On 5 Oct 2003 08:30:21 -0700, md**@hotmail.co m (cooldv) wrote:
i am running a website on Windows 2000 server with ASP 3 webpages and
Access 2000 database. (with a hosting company)
traffic is slow at this time but expect to grow. lately i have been
reading about sql database and sql server, specially this article:
http://www.aspfaq.com/show.asp?id=2195

will someone help me understand:

1. with *SQL Server*, do i keep my current Access 2000 database and
ASP pages?
Yes
if not, then -
a. what sort of DB i will need? (we r a non profit, so need
inexpensive things)
Depends on what your trafic will look like and how your skills are.
b. will ASP pages need be redesigned? how big/difficult is that
transition?
Not redesigned, but perhaps tweaked a bit. This mainly depends on
"how" you coded the ASP in the first place. See below

2. if i start using *SQL database*, then which SQL database?
This depends on what you know or are willing to learn. On Windows
based servers, Microsoft SQL Server is the most common choice. On
Linux based servers, mySQL is most common.

3. Where does *mySQL* fit in this scene?
mySQL is an open source implementation of SQL database.

4. What do i do with my current ASP webpages?
Modify them to work with the syntax of SQL used by the database of
your choice.

5. i guess, i will need an SQL server if i have to use SQL database?
any recommendations for a cheaper hosting company?


This is the big one. Not necessarily. If you are doing mainly lookups
from a database, this is not too big a deal and you should be able to
live with Access for quite some time. Actual hit rates and numbers
will help decide this for you.

From your comments, it does not appear that you understand that Access
uses SQL to do it's work in one way or another. SQL stands for
"Structured Query Language". It is generally a standardized language,
so for the most part, you can have one query and run it on any number
of database systems that support SQL. For example:

SELECT FName, LName FROM People

That is a SQL statement that will retrieve the First name and Last
Name from a table named People. It should work in Access, SQL Server,
mySQL, Oracle and probably most SQL based databases. You run into
problems when you get a little more tricky. Even seemingly simple
things like dates need a bit of tweaking to make work. For example

SELECT LName FROM People Where LogDate = #10/1/2003#

Will work fine in Access but it needs to be recoded as

SELECT LName FROM People WHERE LogDate = '10/1/2003'

(notice the change from # to single quotes) if you were to do the same
thing in SQL Server. Wildcard search characters are another bugaboo.
You use asterisk in Access, but % in SQL Server. For what it's worth,
SQL Server is the more standard way of doing it. Access is the
exception there.

Bottom line: You will need to do the following things to convert to
SQL Server:

1. Transfer the data from your Access database to SQL Server. At the
very least, you will need to recreate the schema (database structure)
in SQL Server. Note that there are more - and different data types in
SQL Server, so make sure you choose the correct ones.

2. Recode your connection string from Access to SQL Server. If you use
a DSN, this is quite simple. Otherwise, you will need to recode
wherever you make a connection.

3. Recode whatever SQL statements need syntax changes to support SQL
Server. There really are not tha many changes if you are not doing
complex queries.

If you have any SPECIFIC problems, dont hesitate to post the code and
the particulars. Im sure someone will be kind enough to help.
Jul 19 '05 #2
> 1. with *SQL Server*, do i keep my current Access 2000
database and
ASP pages?
sort of. you lose the Access DB, but import it into SQL Server
if not, then -
a. what sort of DB i will need? (we r a non profit, so need
inexpensive things)
b. will ASP pages need be redesigned? how big/difficult is that
transition?
it's not a massive transition if your current code is well designed. a
couple of SQL calls may need to be changed, your connection string will
change, but that's about it, really. If you want to take full advantage
of SQL's capabilities, I'd recommend a bit of an overhaul, though.
2. if i start using *SQL database*, then which SQL database?
up to you.
3. Where does *mySQL* fit in this scene?
it's a free/cheap SQL database server, not by any means as
fully-featured as MSSQL but still a step up from Access. It's less well
supported under ASP, community-wise, since most ASP developers use SQL
Server or Access
4. What do i do with my current ASP webpages?
keep 'em and change the calls as required
5. i guess, i will need an SQL server if i have to use SQL database?
any recommendations for a cheaper hosting company?


yup, you can't use a SQL Server database without the associated server.
try www.aspin.com for a start on web hosts. they're expensive! as a
non-profit you may have a good bargaining position, I work for a
non-profit here and we get a lot of concessions.
_______________ _______________ __________
Atrax. MVP, IIS
http://rtfm.atrax.co.uk/

newsflash : Atrax.Richedit 1.0 now released.
http://rtfm.atrax.co.uk/infinitemonk...trax.RichEdit/

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 19 '05 #3
Most of your questions have been answered by other posts (very well, might I
add...nice job, Dan), but I can answer the last, about webhosting.

My experience has been that just about anyone will host your site for
$9.99/month until you say, well, that's great, what about MSSQL? Then the
price jumps to $99.99+/month. I guess that's to pay for licensing fees etc
etc etc, but when you consider the volume these companies do it's pretty
outrageous (any thoughts on that, ladies and gentlemen?). There was one
company - who shall remain nameless (email me if you want to know the
story) - that did MSSQL hosting for $9.99, but their backup scheme was
disastrous and I've since moved on. Far on.

Check out www.hostmysite.com and www.finesthost.net. I've worked with both,
currently use the second, and had good luck with both. (check out
www.seamlyne.com for my current site)

One note though, about transitioning between databases. Hopefully you've
got all of your SQL functions in one ASP page which is called from any page
needing a connection. That way, you only have to change the connection
string ONCE, and all the other pages get it in one shot.

Regards, and good luck!

--
William Morris
Product Development, Seritas LLC

"cooldv" <md**@hotmail.c om> wrote in message
news:d3******** *************** ***@posting.goo gle.com...
i am running a website on Windows 2000 server with ASP 3 webpages and
Access 2000 database. (with a hosting company)
traffic is slow at this time but expect to grow. lately i have been
reading about sql database and sql server, specially this article:
http://www.aspfaq.com/show.asp?id=2195

will someone help me understand:

1. with *SQL Server*, do i keep my current Access 2000 database and
ASP pages?
if not, then -
a. what sort of DB i will need? (we r a non profit, so need
inexpensive things)
b. will ASP pages need be redesigned? how big/difficult is that
transition?

2. if i start using *SQL database*, then which SQL database?

3. Where does *mySQL* fit in this scene?

4. What do i do with my current ASP webpages?

5. i guess, i will need an SQL server if i have to use SQL database?
any recommendations for a cheaper hosting company?

Jul 19 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
3753
by: Wolfgang Kaml | last post by:
Hello All, I have been working on this for almost a week now and I haven't anything up my sleeves anymore that I could test in addition or change.... Since I am not sure, if this is a Windows 2003 Server or ADO or ODBC issue, I am posting this on all of the three newsgroups. That's the setup: Windows 2003 Server with IIS and ASP.NET actiavted Access 2002 mdb file (and yes, proper rights are set on TMP paths and path,
11
4950
by: Ohaya | last post by:
Hi, I'm trying to understand a situation where ASP seems to be "blocking" of "queuing" requests. This is on a Win2K Advanced Server, with IIS5. I've seen some posts (e.g., http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=Tidy7IDbDHA.2108%40cpmsftngxa06.phx.gbl) that indicate that ASP will queue up requests when they come in with the same "session".
51
3764
by: w_curtis | last post by:
I'm an Access user, and I'm trying to learn MySQL and then PHP so I can make some web databases. But it just isn't clicking. I've followed some tutorials, and picked up a book, but just getting to square one has been a pain. I can follow the tutorials and get to the point where I can make tables and stuff, but I don't know how I got there, or what to do if something changes that makes it different than the tutorial. MySQL doesn't seem...
15
4601
by: Cheryl Langdon | last post by:
Hello everyone, This is my first attempt at getting help in this manner. Please forgive me if this is an inappropriate request. I suddenly find myself in urgent need of instruction on how to communicate with a MySQL database table on a web server, from inside of my company's Access-VBA application. I know VBA pretty well but have never before needed to do this HTTP/XML/MySQL type functions.
22
6263
by: Jordan S. | last post by:
SQL Server will be used as the back-end database to a non trivial client application. In question is the choice of client application: I need to be able to speak intelligently about when one client (MS Access vs ..NET Windows Forms) would be preferred over the other. While I have some good arguments on both sides, I would appreciate your points of view on the topic.
9
3829
by: Wayne Smith | last post by:
I've come up against a major headache that I can't seem to find a solution for but I'm sure there must be a workaround and I would really be grateful of any help. I'm currently building a web site for a small club I belong to and one of the features I would like to include is the ability to allow users to upload image files. unfortunately the servers web root www folder only allows READ and EXECUTE permissions, which makes it...
5
1859
by: Kip | last post by:
I have an office with approx 8 people. I have used Access with a Form on my personal PC for client records. I was wondering if I could put the Access table on a server and put shortcuts on each work station to allow users to view, update records? Thanks in advance
21
4093
by: nihad.nasim | last post by:
Hi there, I have a database in Access that I need on the web. The web page should connect to the database and write records for certain tables and view records for others. I want to know a reliable way of connecting Access to a server. I am willing to switch to any version of Access which might solve the problem. Which server would you recommend and what are the advanatages and disadvantatges of the server you propose? Please also inlcude...
7
3021
by: Ronald S. Cook | last post by:
I've always been taught that stored procedures are better than writing SQL in client code for a number of reasons: - runs faster as is compiled and lives on the database server - is the more proper tier to put it since is a data function But then I've heard that writing SQL in my client .NET code might run just as fast? Dynamic SQL or something? And then there's LINQ on the horizon. Is it a successor to everything
0
8590
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9066
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
8779
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8783
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6450
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5806
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
2960
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2214
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
1947
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.