Connessione mysql

[Roby_72]

whtConn.Open = "DRIVER={MySQL ODBC 3.51 Driver};DATABASE=aaaaa;SERVER=bbbbbb;UID=cccc;PASSWORD=ddddd"

Roby

[vegra]

mmmm...nisba...mi da un errore
Active Server Pages error 'ASP 0126'

Include file not found

/articoli/default.asp, line 2

The include file '/common/dbconn1.asp' was not found.

[Santino83_02]

indovina un pò che errore è...avrai sbagliato il percorso dell'include

[vegra]

ho provato ad inserire la pagina cinnessione in default e mi da questo errore
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

ODBC driver does not support the requested properties.

/articoli/default.asp, line 64

[Santino83_02]

che c'è alla linea 64?

[vegra]

dataRS.Open dataSQL, whtConn, 1

[Roby_72]

Posta l'errore e la query.

Roby

[vegra]

Questo è l'errore
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

ODBC driver does not support the requested properties.

articoli/default.asp, line 6


questa è la index



<%
set dataRS = Server.CreateObject("ADODB.RecordSet")
dataSQL = "Select id FROM tblPages where homepage = 1;"
dataRS.Open dataSQL, whtConn, 1

if mysqlrecordcount <> 1 then
dataRS.Close
Set dataRS = Nothing
whtConn.Close
Set whtConn = Nothing
response.redirect("sethomepage.htm")
end if

id = dataRS("id")

'close connections,etc..
dataRS.Close
Set dataRS = Nothing
whtConn.Close
Set whtConn = Nothing

homepagepath = "page.asp?id=" & id

response.redirect(homepagepath)
%>

Questa e la pagina di connsessione


<%
'dim whtConn, dbpath
set whtConn = server.createobject("adodb.connection")
'********EDIT THE LINE BELOW TO MATCH THE DSN OF YOUR MYSQL DATABASE DSN CONNECTION NAME ********

whtConn.Open = "DRIVER={MySQL ODBC 3.51 Driver};DATABASE=Sql3111_4;SERVER=62.111.111.11;UI D=Sql31111;PASSWORD=HW8888"

'************************************************* *********************

'FUNCTIONS
FUNCTION PreSubmit(p_sTargetString)
PreSubmit = REPLACE(p_sTargetString,"textarea","")
PreSubmit = REPLACE(PreSubmit,"%","&#37;")
PreSubmit = REPLACE(PreSubmit,"'","&#39;")
'PreSubmit = REPLACE(PreSubmit,"""","&quot;")
PreSubmit = Trim(PreSubmit)
END FUNCTION

FUNCTION PreSubmit2(p_sTargetString)
PreSubmit2 = REPLACE(p_sTargetString,"textarea","")
PreSubmit2 = REPLACE(PreSubmit2,"%","&#37;")
PreSubmit2 = REPLACE(PreSubmit2,"'","&#39;")
PreSubmit2 = REPLACE(PreSubmit2,"""","&quot;")
PreSubmit2 = REPLACE(PreSubmit2,"<","&lt;")
PreSubmit2 = REPLACE(PreSubmit2,">","&gt;")
'PreSubmit2 = REPLACE(PreSubmit2,vbCrlf,"
")
PreSubmit2 = Trim(PreSubmit2)
END FUNCTION


Function MySQLRecordCount
recordcount = 0
while not dataRS.EOF
recordcount = recordcount + 1
dataRS.movenext
wend
if recordcount > 0 then
dataRS.movefirst
end if
mysqlrecordcount = recordcount
End Function

Function MySQLRecordCount2
recordcount = 0
while not updateRS.EOF
mysqlrecordcount = recordcount + 1
updateRS.movenext
wend
'updateRS.movefirst
'mysqlrecordcount = recordcount
End Function

%>

[Roby_72]

dataRS.Open dataSQL, whtConn

Roby

[vegra]

ora non mi connette perche nn trova questa tabella nelDB...ecco l'errore

Microsoft OLE DB Provider for ODBC Drivers error '80040e37'

[MySQL][ODBC 3.51 Driver][mysqld-4.0.27-standard-log]Table 'Sql11111_4.tblPages' doesn't exist

/articoli/default.asp, line 6


io ho controllato però esiste quella tabella...ho notato che la p è in minuscolo, invece di tblPages sul DB è tblpages