RE: OLEDB connection to mysql via ASP

You will need to install the ODBC driver for MySQL. A quick search this
morning at www.mysql.com did not reveal any OLEDB drivers; however, they do
have an ODBC driver here: http://www.mysql.com/products/connector/odbc/

"TB" wrote:

> Hello all:
>
> Although the following question is not related to a MS flavor database, it
> IS related to MS flavored technologies / platforms: ASP and Windows XP. So
> please bear with me.
>
> I have just installed MySQL via the new windows installer program on my
> Windows XP Pro machine, and everything works perfectly. Now I would like to
> make a connection from an ASP page to the database (locally on my computer)
>
> The connection string which I use on my mysql database on my web site
> (externally) is
>
> <%
> set Conn = server.CreateObject("ADODB.connection")
> Conn.open "Provider=MySQLProv;Location=mysql.myweb.com;Data Source=db;User
> Id=myname;Password=mypw;"
> %>
>
> and that works perfectly.
>
> Now I would like to use the same string for local connections on my PC.
>
> I have tried:
>
> <%
> set Conn = server.CreateObject("ADODB.connection")
> Conn.open "Provider=MySQLProv;Location=localhost;Data Source=localhost;User
> Id=root;Password=pw;"
> %>
>
> But I get the following error message:
>
> ADODB.Connection (0x800A0E7A)
> Provider cannot be found. It may not be properly installed.
>
> That leads to several questions:
>
> - Are the "Location" and "Data source" arguments correct? (I did not specify
> anything particular when installation windows package, the user "root" was
> automatically created.
>
> - Do I have to install something extra in order to make MySQLProv work
> locally on my computer? (Ssomehow the error message seems to indicate that )
>
> Are there any alternatives to MySQLProv (I prefer OLEDB, not OBDC) - already
> natively available on win XP Pro which would work?
>
> Thanks a lot!
>
> TB
>
>
>
>
.

Relevant Pages

  • Re: Connect to MySQL
    ... I can now study basics operations on MySQL database ... I have also installed ODBC driver, ... instructions which tell you to install ODBC, as I'm darned sure it's not ...
    (comp.lang.php)
  • DBI / DBD / MySQL installation problem
    ... I used to run Red Hat 9, and had a perfect relationship with Perl, DBI, ... able to connect to MySQL from Perl via DBI. ... Running install for module Mysql ...
    (perl.dbi.users)
  • Re: Web Server?
    ... Click the Add/Remove Windows Components button and then choose IIS. ... PHP and MySQL are not part of Windows and therefore require that you acquire ... the software yourself and then install per the manufacturer's instructions. ...
    (microsoft.public.windowsxp.setup_deployment)
  • Re: MySQL, Ruby, DBI connetc problem...help please
    ... Look for MySQL at the bottom.. ... > I currently have the MySQL binary for Windows installed. ... I can not get the DBI module for either ... > properly with the MySQL binary install and WinXP? ...
    (comp.lang.ruby)
  • Installing Puresecure on Solaris 8
    ... Getting puresecure installed on Solaris was very difficult. ... I had to manually install a number of things. ... CONFIGURING MYSQL: ... INSTALLING PERL MODULES ...
    (comp.security.misc)
Quantcast