Estou com um problema nesse código:
<!-- #INCLUDE FILE="inc.asp" --> <!-- #INCLUDE FILE="AdminINC.asp" --> <head> <title></title> </head> <body topmargin="0" leftmargin="0" bgcolor="#FFFFFF" text="#211852" link="#211852" vlink="#211852" alink="#211852"> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td width="25%" bgcolor="#9CCEFF" align="center"> <% Set Conn = Server.CreateObject("ADODB.Connection") Set Rs = Server.CreateObject("ADODB.Recordset") Conn.Open dsn mySQL = "SELECT * from Festa where FestaID = '" & request.querystring("FestaID") & "'" rs.open sql,conn %><b><%= rs("Festa") %></b><br><%= ors("Data") %> </td> </tr> </table> <% FestaID = request.querystring("FestaID") Set Myconn = Server.CreateObject("ADODB.Connection") Myconn.Open DB_CONNECTIONSTRING SET MYTABLE= SERVER.CREATEOBJECT("ADODB.RECORDSET") mySQL = "select * from Fotos WHERE FestaID = '" & request.querystring("FestaID") & "'" iPageSize = AdminRS.fields("NoResults") If Request.QueryString("pagina") = "" Then iPageCurrent = 1 Else iPageCurrent = CInt(Request.QueryString("pagina")) End If mytable.PageSize = iPageSize mytable.CacheSize = iPageSize mytable.open mysql,myconn,3 iPageCount = mytable.PageCount If iPageCurrent > iPageCount Then iPageCurrent = iPageCount If iPageCurrent < 1 Then iPageCurrent = 1 mytable.AbsolutePage = iPageCurrent For I = 0 To mytable.Fields.Count - 1 Next iRecordsShown = 0 Do While iRecordsShown < iPageSize And Not mytable.EOF %> <div align="center"> <center> <table border="0" cellspacing="0" cellpadding="0"> <tr> <td bgcolor="#DEE7F7"><a href="bigpicture.asp?id=<%= mytable.fields("id").value %>"><img src="Fotos/<%= mytable.fields("Foto") %>.jpg" width="120" height="90" border="0"></a></td> </tr> <tr> <td height=10 align="center">----------------</td> </tr> </table> </center> </div> <% iRecordsShown = iRecordsShown + 1 mytable.MoveNext Loop %> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td width="33%" bgcolor="#9CCEFF"> <p align="center"><font color="#211852" face="Arial"><%If iPageCurrent > 1 Then %> <a href="ShowCat.asp?FestaID=<%= FestaID %>&pagina=<%= iPageCurrent - 1 %>"><< Previous</a><% End If %></font></p> </td> <td width="33%" bgcolor="#9CCEFF"> <p align="center"><font color="#211852" face="Arial"><% ' You can also show page numbers: For I = 1 To iPageCount If I = iPageCurrent Then %> <%= I %> <% Else %> <a href="ShowCat.asp?FestaID=<%= FestaID %>&pagina=<%= I %>"><%= I %></a> <% End If Next 'I %> </font> </td> <td width="34%" bgcolor="#9CCEFF"> <p align="center"><font color="#211852" face="Arial"><% 'next button If iPageCurrent < iPageCount Then %> <a href="ShowCat.asp?FestaID=<%= FestaID %>&pagina=<%= iPageCurrent + 1 %>">Next >></a> <% End If %></font></p> </td> </tr> </table> <% AdminRS.close %>Está aparecendo o seguinte erro:
Onde a linha 13 é:Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Nome da fonte de dados não encontrado e nenhum driver padrão especificado
/Testes/Minha galeria/ShowCat.asp, line 13
Acho que não estou conseguindo puxar dados de tabelas diferentes, num mesmo banco de dados... Espero que consigam me ajudar...Set Rs = Server.CreateObject("ADODB.Recordset")
Abraços a todos!