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 Rhinorhino 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
Joined
Dec 7, 2005
Messages
1
Location
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