Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error 800a01fb

Status
Not open for further replies.

Surre

Programmer
Dec 7, 2005
1
SE
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top