Tony M
|
| Posted: 12/31/2002, 12:42 AM |
|
I would be most grateful to hear from anyone...who has used...or is using
...ASP with MYSQL
Regards...and a Happy and Fruitful 2003...to you and yours.
Tony M
|
|
|
 |
Snake.PLiSKiN
|
| Posted: 12/31/2002, 3:14 AM |
|
I am using it with the web site application I'm developing. I played around with it at 1st with my website to make sure it works. Its the only database my webhosting offers. It can be tricky to figure out how to make a working connection to the db from a asp page. Here is how to make a DSN-less connection (Note: MyODBC 2.5x or higher must be installed on the webserver) use the following connenction string:
"driver={MySql}; database=dddd; server=dbserver.com; uid=uuuu; pwd=pppp;"
self explainitary, dddd=your database, replace dbserver.com with your mysql server. uuuu= your mysql username pppp = the password
I like MySQL, a nice basic database server without all the extra junk. Though getting mysql to work under ASP.NET is alot harder, (requires the .NET framework, MyODBC 3.5 + a DSN connection setup, Microsofts ODBC.NET to all be installed on the webserver)
If u have any questions lemme know
|
|
|
|
Tony M
|
| Posted: 12/31/2002, 8:41 AM |
|
Thanks for your reply Snake.PLiSKiN...I love your Alias...it has 'real character'
The reason I asked the question was that YES SOFTWARE updated the KnowledgeBase yesterday..TWICE...and their article...MySQL Database Connection @
http://support.codecharge.com/kb_article.asp?s_keyword=...=&article_id=50
Also said "..... In the rare event that the MySQL database is used with another language such as ASP, C#, VB.Net or Cold Fusion..."
It is a timely article because I want to move to a 'proper' database once STUDIO Beta TWO is released.
I'm obviously aware of MYSQL and it's power...I was most impressed with
February 25, 2002
Server Databases Clash
By Timothy Dyck
@ http://www.eweek.com/article2/0,3959,293,00.asp
...it also said..."...Overall, Oracle9i and MySQL had the best performance and scalability (see charts, images 1 and 2 in slideshow), with Oracle9i just very slightly ahead of MySQL for most of the run. ASE, DB2, Oracle9i and MySQL finished in a dead heat up to about 550 Web users..."
The PHP/MYSQL route is very popular BUT with 2003 becoming the year for .NET I thought I would get some advice from other ASP/MYSQL users.
Regards
Tony M
|
|
|
|
Snake.PLiSKiN
|
| Posted: 12/31/2002, 5:46 PM |
|
I dont think too many places would be using MySQL 4.x because of its beta er gamma status :)
Using MySQL with classic ASP is easy esp with DSN-less connections. I have been using it for a few months now, tho the only thing I dont like/ wish they would make a feature of, is like in MS SQL/MS Access the releationships feature. The mysql developers believe that should be done by the SQL commands not the server...
I have not yet been able to use MySQL with ASP.NET yet due to no available form of connection that has yet to be setup on the webserver. Seems that Microsoft is doing what it does best, making it hard for 3rd party databases to work with .NET except for its partners. LOL if only ODBC was Plug-n-play :) but take a look at the official MySQL guide to "Exploring MySQL in the Microsoft .NET Enviroment" <a href src="http://www.mysql.com/articles/dotnet/">http://www.mysql.com/articles/dotnet/</a> [not sure if html tags are allowed at time of writing this, so dont mind me if I test it :) ]
|
|
|
|
Tony M
|
| Posted: 12/31/2002, 9:54 PM |
|
Thank you again Snake.PLiSKiN
Your comments and future contributions to the evolving .Net/MYSQL combination will be most helpful to me and others who wish to go that route.
With STUDIO Beta 2 imminent...what a nice start for CodeChargers to 2003
Regards
Tony M
|
|
|
|
|
