asp og MySql
Jeg få denne fejlError Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/test2.asp, line 18
med denne code
<%
SQLserveradr="sql01.dk"
SQLdatabase="ecompdk"
SQLlogin="ecompdk"
SQLpassword="xxxx"
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "driver={MySql};server="& SQLserveradr &";database="& SQLdatabase &";uid="& SQLlogin &";pwd="& SQLpassword
mySQL = "SELECT * From CATEGORY "
Set rs = Conn.Execute(mySQL)
set rs = nothing
Conn.close
set conn = nothing
%>
Er der nogen der kan hjælpe
