Re: MySQL and ASP

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Jeff Cochran (jeff.nospam_at_zina.com)
Date: 03/10/05 

Date: Thu, 10 Mar 2005 18:47:38 GMT

On Thu, 10 Mar 2005 17:56:18 GMT, Jerry
<jabeach@DONT_SPAM_ME_citlink.net> wrote:

>Could someone advise me of a website that has decent instructions on how
>to establish a DSN-less connection to a MySQL database using ASP? I've
>seen some connection string examples but I'm confused about the drivers
>and how to set them up.

Googling "asp mysql tutorial" got this as the fourth link:

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=7739&lngWId=4

The ADO connection is here:

http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForMySQL

As for the driver setup, you'll want to check the MySQL docs:

http://dev.mysql.com/doc/mysql/en/index.html

Jeff

Relevant Pages

  • Re: asp + mysql and simultaneous requests result in IIS 500 error
    ... > ASP pages send out simultaneous requests to another ASP page which in ... > ASP pages that put out requests to ASP pages which in turn try to ... > retrieve data from the MySQL database, I get a 500 error code. ... > caused by the DSNless connection? ...
    (microsoft.public.inetserver.asp.general)
  • Re: VFP8 & MySQL
    ... > VFP functions like NVL to a MySQL one, definitely it made the switch very ... > About your connection problem, I have mine setup as default for 100 ... As for the server, we left it ... The server crashed and corrupted the database. ...
    (microsoft.public.fox.programmer.exchange)
  • RE: passwords in asp pages
    ... about the specifics of the connection other than the type (ie. by type I ... about your asp, ... passwords for credentials to an sql database on another machine. ... to facilitate one-on-one interaction with one of our expert instructors. ...
    (Security-Basics)
  • Re: Does apache stop a script mid execution ?
    ... If the user calls a time consuming script and then stops or refreshes ... How does it relate to e.g. a script performing a large mysql query? ... 2.b) how the connection is set up. ... the server stops the script execution. ...
    (comp.lang.php)
  • MySQL on Win 98
    ... I'm just getting into MySQL and I'm trying to learn about it at home. ... and created a DSN connection for it. ... User: root ... ODBC Data Source Administrator and get a "success" result. ...
    (microsoft.public.fox.programmer.exchange)