ASP and MYSQL how to site? !!!!!!

[webandwe]

Hi,

I'm trying to figure out how to insert, delete and update Mysql with ASP.

But can't find one website.

Does anyone know of a website I can check it out or get examples?

Thanks

[JamieHowarth0]

Hi there,

Before using MySQL with ASP, you need to install the MySQL ODBC driver on the machine that the ASP application is running, and ensure that port 3306 is open on the machine running MySQL.
The ODBC driver for MySQL can be found here (both x86 and x64 versions).

Then, read the documentation and there are examples of how to create a DSN, or DSN-less, connection string using the MySQL ODBC connector. Simply use this code in your ASP app and that's it!

Hope this helps.

Best regards,

medicineworker

[jhardman]

Ditto to what medicineworker said. Let me add that the best solution in my opinion, if you are trying to follow existing instructions, is set up a DSN. Once that is in place you can connect to it following any DSN connection instruction you can find.

Jared

[JamieHowarth0]

I personally suggest against using DSN's as per this article for performance and management benefits, especially in a shared hosting environment.

Best regards,

med

[jhardman]

I personally suggest against using DSN's as per this article for performance and management benefits, especially in a shared hosting environment.

Best regards,

med

Bahhh !