Web Hosting Forum | Lunarpages


*
Welcome, Guest. Please login or register.
Did you miss your activation email?



Login with username, password and session length
May 16, 2012, 05:20:06 PM

Pages: [1]   Go Down
  Print  
Author Topic: ASP+MySQL connection issue  (Read 1006 times)
henryli2009
Newbie
*
Offline Offline

Posts: 1


« on: January 30, 2009, 01:10:47 PM »

Can anyone help on this issue?

When I tried to connect to MySQL database, I got the error message:

Error Type:
ADODB.Connection.1 (0x80004005)
SQLState: S Native Error Code: 2002 [TCX][MyODBC]Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)


Below is my connecting string, is there anything wrong?

dim conn,conn_string
set conn = server.createobject("ADODB.Connection")
conn_string="Driver={MySQL ODBC 3.51 Driver}; Server=localhost; Port=3306; Option=3; Database=****; Uid=****; Password=****; "
conn.open(conn_string)


Thanks in advance.
Logged
Pages: [1]   Go Up
  Print  
 
Jump to: