ASP > mysql, Oracle

[Portroe]

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

 

[Jeff Cochran]

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

 

[Portroe]

would it make sense to choose MSSQL, if that were a choice?

thanks

 

[Ray at]

YES. This is an expensive choice, though,

Ray at work

 

[Guest]

yea, but what is the problem with mySQL, huh?

 

[Chris Hohmann]

yea, but what is the problem with mySQL, huh?

No stored procedures yet...

 

[Ryan N.]

Look into PostgreSQL at http://www.postresql.org

 

[Guest]

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...

: : > yea, but what is the problem with mySQL, huh?
:
: No stored procedures yet...
:
:

 

[Chris Hohmann]

: : > 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

 

[Jeff Cochran]

would it make sense to choose MSSQL, if that were a choice?
Sure.

Jeff

 

[Jeff Cochran]

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