I am installing MySQL on my new server with Windows 2003.
I have installed
* MySQL 5.0.16
* MyODBC 5.0.0
* MySQLAdministrator 1.1.5
* MySQL Query Browser 1.1.17
* MDAC 2.8
* IIS 6.0
I have the database on drive D: and win2003 on C:
Everything works perfectly from MySQLAdministrator, I can do everything in the database. I can also run asp without problem. But when I try to connect to the database from an asp-page I get Error '800a01fb' when I try to Execute an SQL-command.
-----------code-------------
<%
Set Conn = createobject("ADOBD.Connection")
Conn.Open="Driver={MySQL Connector/ODBC v5.0};Server=Localhost;Database=MyDb;User=root;Password=MyPassword;Option=35;"
MySQL="SELECT * FROM Table1"
set rs=Conn.Execute(MySQL)
rs.Close
set rs=nothing
Conn.Close
set Conn=Nothing
%>
-----------/code-----------
I have tried everything I can yhink of, reinstalling MySQL and ODBC for instance. I really hope you can help me!
Thanks
I have installed
* MySQL 5.0.16
* MyODBC 5.0.0
* MySQLAdministrator 1.1.5
* MySQL Query Browser 1.1.17
* MDAC 2.8
* IIS 6.0
I have the database on drive D: and win2003 on C:
Everything works perfectly from MySQLAdministrator, I can do everything in the database. I can also run asp without problem. But when I try to connect to the database from an asp-page I get Error '800a01fb' when I try to Execute an SQL-command.
-----------code-------------
<%
Set Conn = createobject("ADOBD.Connection")
Conn.Open="Driver={MySQL Connector/ODBC v5.0};Server=Localhost;Database=MyDb;User=root;Password=MyPassword;Option=35;"
MySQL="SELECT * FROM Table1"
set rs=Conn.Execute(MySQL)
rs.Close
set rs=nothing
Conn.Close
set Conn=Nothing
%>
-----------/code-----------
I have tried everything I can yhink of, reinstalling MySQL and ODBC for instance. I really hope you can help me!
Thanks