OLEDB connection to mysql via ASP
- From: "TB" <tbpostbox-googlegroups@xxxxxxxxx>
- Date: Wed, 20 Apr 2005 12:25:26 +0200
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
.
- Follow-Ups:
- RE: OLEDB connection to mysql via ASP
- From: John Beschler
- RE: OLEDB connection to mysql via ASP
- Prev by Date: dsnless connection in oracle9i
- Next by Date: RE: OLEDB connection to mysql via ASP
- Previous by thread: dsnless connection in oracle9i
- Next by thread: RE: OLEDB connection to mysql via ASP
- Index(es):
Relevant Pages
|
