
September 11th, 2005, 03:50 AM
|
|
Registered User
|
|
Join Date: Sep 2005
Posts: 1
Time spent in forums: 31 m 38 sec
Reputation Power: 0
|
|
Guys Help me mysql server connection
I have used this connection string for asp to mysql server
<%
myConn = "DRIVER={MySQL ODBC 3.51 Driver}; server= Localhost;Port=3306;DATABASE=mydatas;OPTION=3;"
Set sConn = server.CreateObject("ADODB.Connection")
sConn.open(myConn)
%>
but error still occurs to my connection. it sez here:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/systemmis/con_proc.asp, line 6
i can't figure it out it try many kinds of connection string but still it has the same errors, I'm using a Windows XP professional Service pack 2 and i have a IIS. mysql sever administrator are all ready installed but still this error occurs on my connection? why I can't connect to my database can you help me figure it out?? pls!!! i'll be waiting for your reply! its really badly needed because its for our thesis! thanx guys!
hope you help me! thanx!
|