ASP and MySQL

[shadyness]

I have a work project where they want me to develop a web enabled data access system, which allows a client access to their data. They want me to use existing resources (which means IIS) and the client will be using IE 6.0 to access data. Without getting into the licensing issues that occurred with SQL Server 2000, let's just say it has to be in MySQL, which is now currently installed. There will be no data inserting via the web, just reports. I have been thinking that since the driver is loaded, the DSN should handle everything, but I am uncertain of future problems that may arise.

Does anyone know of any good online or book resource on using ASP with MySQL? I have not been able to find any good ones, since everything assumes you're using PHP.

Thanks---

 

[Tarwn]

Try snowboardr's site for some basics, he should also have links to more advanced topics )or perhaps he'll post some if we say his name enough )
He is a MySQL fanatic (in a good way) and has a good number of examples specifically on ASP and MySQL functionality.

http://www.vzio.com

-Tarwn --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- ---
For my next trick I will pull a hat out of a rabbit (if you think thats bad you should see how the pigeon feels...)

 

[snowboardr]

Oh if only there was more information on MySQL / ASP... thats why I went ahead and wrote a tutorial for it.

haha funny tarwn, I like mysql because I found mysql front, and I never get errors like I did back in the Access days.. I threw access out the window. I would like to get into oracle but thats a bit heavy duty wouldnt you say?


ps. the link to MySQL front is dead, because the MySQL front was discontinued... but with a quick google search you can find the download of it.

- snowboardr www.vzio.com
ASP WEB DEVELOPMENT

 

[shadyness]

Thanks a ton! The tutorial was very helpful, but I think I am looking for some more advanced information regarding plug-ins and add-ons (Db-Tools, etc.). I really need any information on a SQL Server Enterprise Manager for MySQL, for instance or pitfalls to avoid, or tactics to use (like the programming of Triggers in SQL Server). Essentially that 2 gigs of data I have for this project is coming from Access, so that is simple enough, and calling-up a record-set is the same really as any ASP application. So I guess, I need some sort of resource that documents or contains tips for administrating a database that fits into this scenario. Especially since SQL Server and ASP books are mass-produced, there has to be something on administrating a MySQL base in a MS environment.