Urgent :why i cant see my asp file in localhost?

shinwai · #1 (**permalink**) 03-29-06, 19:58

Quote:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[TCX][MyODBC]Can't connect to MySQL server on '219.93.218.177' (10060)

why this happen and how to solve the problem?thanks ..i need it urgent.

oliflorence · #2 (**permalink**) 03-30-06, 06:33

This is a proiblem connecting to the database which could be coming from several things.
1. Check your user on MySQL, you should have a user created for the database you want to connect under the user administration.

2. Check your MyODBC connection, there is a test button on it, that should give you an idea of where the problem is.
3. Check your username and password on your connection settings on your ASP page.

The best is often to remove the user in the DB, remove the connection and start all over.

Hope this helps,
Oli

YeahWhat · #3 (**permalink**) 03-30-06, 06:57

Quote:

Originally Posted by shinwai

why this happen and how to solve the problem?thanks ..i need it urgent.

Most likely a problem with connection string. Try this:

Code:

Dim DSNName
DSNName = "PROVIDER=MSDASQL;driver={MySQL ODBC 3.51 Driver};server=localhost;option=" & 1 + 2 + 8 + 32 + 2048 + 16384  & ";uid=your_username;pwd=your_password;database=your_db_name;"

Dim Conn
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open DSNName

'some code

Conn.Close
Set Conn = nothing

Internet Services

Web Development

Digital Marketing

Consumer Tech