473,406 Members | 2,847 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

ASP > mysql, Oracle

I am currently drawing up a sample server architecture for a windows
environment,

from ASP is there any limitation on which Database one can work with, ie
are MYSQL and Oracle supported,

thanks

Portroe

Jul 19 '05 #1
10 1266
On Thu, 05 Feb 2004 20:47:35 +0100, Portroe <fb@oooi.com> wrote:
I am currently drawing up a sample server architecture for a windows
environment,

from ASP is there any limitation on which Database one can work with, ie
are MYSQL and Oracle supported,


No limits. As long as you can connect to the database, either ADO or
ODBC, it will work.

Jeff
Jul 19 '05 #2
would it make sense to choose MSSQL, if that were a choice?

thanks

Jeff Cochran wrote:
On Thu, 05 Feb 2004 20:47:35 +0100, Portroe <fb@oooi.com> wrote:

I am currently drawing up a sample server architecture for a windows
environment,

from ASP is there any limitation on which Database one can work with, ie

are MYSQL and Oracle supported,

No limits. As long as you can connect to the database, either ADO or
ODBC, it will work.

Jeff


Jul 19 '05 #3
YES. This is an expensive choice, though,

Ray at work

"Portroe" <fb@oooi.com> wrote in message
news:bv*************@news.t-online.com...
would it make sense to choose MSSQL, if that were a choice?

thanks

Jeff Cochran wrote:
On Thu, 05 Feb 2004 20:47:35 +0100, Portroe <fb@oooi.com> wrote:

I am currently drawing up a sample server architecture for a windows
environment,

from ASP is there any limitation on which Database one can work with, ie

are MYSQL and Oracle supported,

No limits. As long as you can connect to the database, either ADO or
ODBC, it will work.

Jeff

Jul 19 '05 #4
yea, but what is the problem with mySQL, huh?
Jul 19 '05 #5
"<spider/>" <bo********@yahoo.com> wrote in message
news:bv*************@ID-155519.news.uni-berlin.de...
yea, but what is the problem with mySQL, huh?


No stored procedures yet...
Jul 19 '05 #6
Look into PostgreSQL at http://www.postresql.org

--
Cheers!

Ryan N.
---------------------------------
Funny...this worked yesterday....
"Portroe" <fb@oooi.com> wrote in message
news:bv*************@news.t-online.com...
would it make sense to choose MSSQL, if that were a choice?

thanks

Jeff Cochran wrote:
On Thu, 05 Feb 2004 20:47:35 +0100, Portroe <fb@oooi.com> wrote:

I am currently drawing up a sample server architecture for a windows
environment,

from ASP is there any limitation on which Database one can work with, ie

are MYSQL and Oracle supported,

No limits. As long as you can connect to the database, either ADO or
ODBC, it will work.

Jeff

Jul 19 '05 #7
hm, i heard that its already supports it.
heh, looks like im lucky enough that i moved into xmldb instead wasteing
time on sql-like stuff...

"Chris Hohmann" <no****@thankyou.com> wrote in message
news:%2******************@TK2MSFTNGP11.phx.gbl...
: "<spider/>" <bo********@yahoo.com> wrote in message
: news:bv*************@ID-155519.news.uni-berlin.de...
: > yea, but what is the problem with mySQL, huh?
:
: No stored procedures yet...
:
:
Jul 19 '05 #8
"<spider/>" <bo********@yahoo.com> wrote in message
news:c0*************@ID-155519.news.uni-berlin.de...
"Chris Hohmann" <no****@thankyou.com> wrote in message
news:%2******************@TK2MSFTNGP11.phx.gbl...
: "<spider/>" <bo********@yahoo.com> wrote in message
: news:bv*************@ID-155519.news.uni-berlin.de...
: > yea, but what is the problem with mySQL, huh?
:
: No stored procedures yet...
:
:

hm, i heard that its already supports it.
heh, looks like im lucky enough that i moved into xmldb instead wasteing time on sql-like stuff...


Stored procedures are implemented in version 5.0. However, MySQL 5.0 is
still in development. and not recommended for production environments.
MySQL 4.0 is the production release.
Here's a list of some of the other features slated for version 5.0:

http://www.mysql.com/doc/en/TODO_MySQL_5.0.html

HTH
-Chris Hohmann
Jul 19 '05 #9
On Thu, 05 Feb 2004 22:02:32 +0100, Portroe <fb@oooi.com> wrote:
would it make sense to choose MSSQL, if that were a choice?
Sure.

Jeff
Jeff Cochran wrote:
On Thu, 05 Feb 2004 20:47:35 +0100, Portroe <fb@oooi.com> wrote:

I am currently drawing up a sample server architecture for a windows
environment,

from ASP is there any limitation on which Database one can work with, ie

are MYSQL and Oracle supported,

No limits. As long as you can connect to the database, either ADO or
ODBC, it will work.

Jeff


Jul 19 '05 #10
On Thu, 5 Feb 2004 16:23:53 -0800, "Chris Hohmann"
<no****@thankyou.com> wrote:
"<spider/>" <bo********@yahoo.com> wrote in message
news:bv*************@ID-155519.news.uni-berlin.de...
yea, but what is the problem with mySQL, huh?


No stored procedures yet...


Version 5 has stored procedures, just no triggers. Which kind of
makes some stored procedures useless, but it's better than nothing.

Jeff
Jul 19 '05 #11

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

Similar topics

133
by: jonathan | last post by:
hey all, I realize that this question might pop up from time to time, but I haven't seen it a while and things might of changed, so - Right now (July 2004) how does mysql stand up in...
1
by: Cern | last post by:
Is it somebody out there who has made a migration from an Oracle server to an MySQL server?? The scenario is as simply: I've got a Oracle 8 server with a database with content that I want to...
4
by: Jan Olsen | last post by:
We're planning an SQL-based solution, possibly mySQL for Windows or Linux. But some in the organization might favor Oracle. Are there any particular pitfalls of using mySQL instead of Oracle? ...
28
by: prunoki | last post by:
Hello, I am an SQL server newbie. Our company has a massive application written in PL/SQL. I need to port parts of it to SQL Server. - Which SQL server version should I choose, to have a...
175
by: Sai Hertz And Control Systems | last post by:
Dear all, Their was a huge rore about MySQL recently for something in java functions now theirs one more http://www.mysql.com/doc/en/News-5.0.x.html Does this concern anyone. What I...
39
by: Mairhtin O'Feannag | last post by:
Hello, I have a client (customer) who asked the question : "Why would I buy and use UDB, when MySql is free?" I had to say I was stunned. I have no experience with MySql, so I was left sort...
1
by: Rosny | last post by:
From the article http://software.newsforge.com/software/05/01/27/170244.shtml?tid=132&tid=75&tid=131&tid=13 "Flickr runs on MySQL, the most popular open source database, and it has from the...
12
by: timothy.williams | last post by:
Hi. I have a Python program that parses a file and inserts records into a database with MySQLdb. I recently upgraded to MySQL 5.0.8, and now my parser runs *really* slow. Writing out to CSV...
3
by: Simone | last post by:
Hi, I have to convert an MySQL database into a ms-sqlserver database. Anyone know a software (is is possible freeware or not so expensive) to translate database? I have only to translate tables,...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
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,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
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,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
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...
0
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...

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.