Bağlantı Hatassı Yardım bu konularda oldukça yeniyim ve meraklıyım. Bu şekilde bir hata alıyorum nasıl çözülür yardım edebilirseniz sevinirim. Microsoft OLE DB Provider for ODBC Drivers error '80040e10' [Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect /KoseYazilari.asp, line 270 KoseYazilari.asp dosyası aşağıdaki gibi....... <!-- #include file="Ayarlar.asp" --> <!-- #include file="Baglanti.asp" --> <!-- #include file="Inc/Inc.asp" --> <!-- #include file="Inc/FCKEditor/FCKEditor.asp" --> <% function TestCaptcha(byval valSession, byval valCaptcha) dim tmpSession valSession = Trim(valSession) valCaptcha = Trim(valCaptcha) if (valSession = vbNullString) or (valCaptcha = vbNullString) then TestCaptcha = false else tmpSession = valSession valSession = Trim(Session(valSession)) Session(tmpSession) = vbNullString if valSession = vbNullString then TestCaptcha = false else valCaptcha = Replace(valCaptcha,"i","I") if StrComp(valSession,valCaptcha,1) = 0 then TestCaptcha = true else TestCaptcha = false end if end if end if end function %> <html> <head> <meta http-equiv="content-language" content="TR"> <meta http-equiv="Content-Type" content="text/html; CHARSET=windows-1254"> <meta http-equiv="Content-Type" content="text/html; CHARSET=iso-8859-9"> <meta name="description" content="<%=siteadi%> Köşe Yazıları" /> <meta name="keywords" content="<%=siteadi%> köşe yazi, yazar ol, yazi yaz, köşe yazarı" /> <link rel="stylesheet" type="text/css" href="Temalar/<%=tema%>/Style.css"> <script language="javascript"> function RefreshImage(valImageId) { var objImage = document.images[valImageId]; if (objImage == undefined) { return; } var now = new Date(); objImage.src = objImage.src.split('?')[0] + '?x=' + now.toUTCString(); } </script> </head> <body background="Temalar/<%=tema%>/site_arka.gif"> <table border="0" width="90%" align="center" class="kare"> <tr> <td bgcolor="#FFFFFF" align="center" background="Temalar/<%=tema%>/blok_bg.gif" valign="top"> <!-- #include file="Tablolar/Logo.asp" --> <!-- #include file="Tablolar/Menu.asp" --> <table border="0" width="99%" cellspacing="0" cellpadding="0"> <tr> <td width="20%" valign="top" background="Temalar/<%=tema%>/blok_bg.gif"><br><% call solbloklar%></td> <td background="Temalar/<%=tema%>/blok_bg.gif" valign="top" align="center"><br> <%if request.querystring("Yazi")="" then%> <title>Köşe Yazıları - <%=siteadi%></title> <table border="0" width="98%" cellspacing="0" cellpadding="0" class="ucizgi"> <tr> <td height="19" background="Temalar/<%=tema%>/blok_arka.gif" width="5%" align="center"> <img border="0" src="Temalar/<%=tema%>/blok_bas.png" width="16" height="16"></td> <td height="19" background="Temalar/<%=tema%>/blok_arka.gif" align="center" width="95%"> <p align="left"><b>Köşe Yazıları</b></td> </tr> <tr> <td colspan="2" background="Temalar/<%=tema%>/arkaplan.gif" align="left"> <p align="center"> <img border="0" src="Resimler/Sayfalar/KoseYazi.gif" width="250" height="50"></p> <p align="center"> <%if session("uyegirdi")="evet" then%> <% Set uye = Baglanti.Execute("select * from Uyeler where kadi='"&session("kadi")&"'") yetki=uye("yetki")%> <%if yetki="5" or yetki="4" or yetki="11" then%><b><a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=53271629&url=KoseYazilari.asp?Yazi=Yaz" data-href="KoseYazilari.asp?Yazi=Yaz">Yazı Yaz</a><br><%end if%> <%end if%>Yazarlar</b></p> <table border="0" width="100%" cellspacing="0" cellpadding="0" height="28"> <tr> <% Set hrec = Baglanti.Execute("select * from KoseYazi where onay=1") if hrec.eof then Response.Redirect "KoseYazilari.asp?Yazi=Yok" end if hyazar=hrec("yazar") Set rec = Baglanti.Execute("select * from Uyeler where kadi='"&hyazar&"'") reckadi=rec("kadi") Set trec = Baglanti.Execute("select * from KoseYazi where yazar='"&reckadi&"' and onay=1") ya=1 al=1 do while not trec.eof Set topne = Baglanti.Execute("select Count(id) As habertop from KoseYazi where yazar='"&reckadi&"' and onay=1") toplamyazi=topne("habertop") %> <td height="28" align="center"> <table border="0" width="100%" height="43"> <tr> <td height="30" valign="top"> <img border="0" src="Resimler/Menu/Kategori.png" width="16" height="16"> <b><a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=53271629&url=<%if seoo="1" then%>Yazar/<%=reckadi%>-Yazilari.<%=seouzanti%><%else%>Yazar.asp?Yazar=<%=reckadi%><%end if%>" data-href="<%if seoo="1" then%>Yazar/<%=reckadi%>-Yazilari.<%=seouzanti%><%else%>Yazar.asp?Yazar=<%=reckadi%><%end if%>"><%=reckadi%></a> (<%=toplamyazi%>)</b><br> <br><br></td> </tr> </table> </td> <% trec.movenext ya=ya+1 if ya=4 then ya=1 %> </tr> <% end if loop rec.close %> </table> </td> </tr> </table> <%end if%> <%if request.querystring("Yazi")="Yok" then%> <title>Yazılar - <%=siteadi%></title> <table border="0" width="98%" cellspacing="0" cellpadding="0" class="ucizgi"> <tr> <td height="19" background="Temalar/<%=tema%>/blok_arka.gif" width="5%" align="center"> <img border="0" src="Temalar/<%=tema%>/blok_bas.png" width="16" height="16"></td> <td height="19" background="Temalar/<%=tema%>/blok_arka.gif" align="center" width="95%"> <p align="left"><b>Yazılar</b></td> </tr> <tr> <td colspan="2" background="Temalar/<%=tema%>/arkaplan.gif" align="left"> <p align="center"> <img border="0" src="Resimler/Sayfalar/KoseYazi.gif" width="250" height="50"></p> <p align="center"><b> Hiç Kimse Köşe Yazısı Yazmamış</b><br><b><a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=53271629&url=KoseYazilari.asp?Yazi=Yaz" data-href="KoseYazilari.asp?Yazi=Yaz">Yazmak İçin Tıklayınız</a></p> <table border="0" width="100%" cellspacing="0" cellpadding="0" height="28"> <tr> </table> </td> </tr> </table> <%end if%> <% if request.querystring("Yazi")="Yaz" then if misafiryazig="0" then call koruma end if%> <title>Yazı Yaz - <%=siteadi%></title> <table border="0" width="98%" cellspacing="0" cellpadding="0" class="ucizgi"> <tr> <td height="19" background="Temalar/<%=tema%>/blok_arka.gif" width="5%" align="center"> <img border="0" src="Temalar/<%=tema%>/blok_bas.png" width="16" height="16"></td> <td height="19" background="Temalar/<%=tema%>/blok_arka.gif" align="center" width="95%"> <p align="left"><b>Yazı Yaz</b></td> </tr> <tr> <td colspan="2" background="Temalar/<%=tema%>/arkaplan.gif" align="left"> <table border="0" width="98%" cellspacing="0" cellpadding="0"> <tr> <td width="83"> </td> <td> </td> </tr> <tr><form method="post" action="KoseYazilari.asp?Yazi=Gonder"> <td width="83" align="right">Başlık : </td> <td> <input type="text" name="baslik" size="52"></td> </tr> <tr> <td width="83" align="right">Yazı : </td> <td> <% Dim toFCKeditor Set toFCKeditor = New FCKeditor toFCKeditor.BasePath = "Inc/FCKeditor/" toFCKeditor.Height = "250" toFCKeditor.width = "335" toFCKeditor.ToolbarSet = "Basic" toFCKeditor.Create "yazi" %></td> </tr> <tr> <td width="83" align="right">Güvenlik : </td> <td> <img id="Guvenlik" name="Guvenlik" border="0" src="Inc/Guvenlik.asp"> <b> <a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=53271629&url=javascript:void(kod_yenile)" onclick="RefreshImage('Guvenlik')" data-href="javascript:void(kod_yenile)" onclick="RefreshImage('Guvenlik')">Kodu Yenile</a></b><br> <input type="text" name="guvenlik" size="20"></td> </tr> <tr> <td width="83" align="right"> </td> <td><input type="submit" value="Gönder" name="tolga"></td> </tr> <tr> <td width="83" align="right"> </td> <td> </td> </tr> <tr> <td width="83" align="right"> </td> <td> </td> </tr> <tr> <td width="83"> </td> <td> </td> </tr> </table> </td></form> </tr> </table><br> <%end if%> <% if request.querystring("Yazi")="Gonder" then if misafiryazig="0" then call koruma end if baslik=ork(request.form("baslik")) yazi=request.form("yazi") yazan=Session("kadi") if baslik="" or yazi="" then%> <title>Hata - <%=siteadi%></title> <table border="0" width="98%" cellspacing="0" cellpadding="0" class="ucizgi"> <tr> <td height="19" background="Temalar/<%=tema%>/blok_arka.gif" width="5%" align="center"> <img border="0" src="Temalar/<%=tema%>/blok_bas.png" width="16" height="16"></td> <td height="19" background="Temalar/<%=tema%>/blok_arka.gif" align="center" width="95%"> <p align="left"><b>Hata</b></p> </td> </tr> <tr> <td colspan="2" background="Temalar/<%=tema%>/arkaplan.gif" align="center"> <br> Hata!<br>Lütfen Boş Alan Bırakmayınız.<br>Lütfen <a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=53271629&url=javascript:history.back(1)" data-href="javascript:history.back(1)">Geri</a> Gidip Düzeltiniz...<br> <br> <br> </td> </tr> </table> <%else%> <% if not IsEmpty(Request.Form("tolga")) then if TestCaptcha("ASPCAPTCHA", Request.Form("guvenlik")) then if session("uyegirdi")="evet" then kekleyen=session("kadi") else kekleyen="Ziyaretçi" end if Baglanti.Execute ("INSERT INTO KoseYazi (baslik,yazi,yazar,onay,hit,tarih)"&_ "VALUES ('"&baslik&"','"&yazi&"','"&kekleyen&"','0','0','"&btarih&"')") %> <title>Yazı Gönderildi - <%=siteadi%></title> <table border="0" width="98%" cellspacing="0" cellpadding="0" class="ucizgi"> <tr> <td height="19" background="Temalar/<%=tema%>/blok_arka.gif" width="5%" align="center"> <img border="0" src="Temalar/<%=tema%>/blok_bas.png" width="16" height="16"></td> <td height="19" background="Temalar/<%=tema%>/blok_arka.gif" align="center" width="95%"> <p align="left"><b>Köşe Yazınız Gönderildi</b></p> </td> </tr> <tr> <td colspan="2" background="Temalar/<%=tema%>/arkaplan.gif" align="center"> <br> Köşe Yazınız Gönderildi! Onaylandıktan Sonra Sitedeki Yerini Alacaktır.<br>Siteye Katkıda Bulunduğunuz İçin Teşekkür Ederiz.<br> <br> <br> </td> </tr> </table> <%else%> <title>Hata - <%=siteadi%></title> <table border="0" width="98%" cellspacing="0" cellpadding="0" class="ucizgi"> <tr> <td height="19" background="Temalar/<%=tema%>/blok_arka.gif" width="5%" align="center"> <img border="0" src="Temalar/<%=tema%>/blok_bas.png" width="16" height="16"></td> <td height="19" background="Temalar/<%=tema%>/blok_arka.gif" align="center" width="95%"> <p align="left"><b>Hata</b></p> </td> </tr> <tr> <td colspan="2" background="Temalar/<%=tema%>/arkaplan.gif" align="center"> <br> Hata!<br>Güvenlik Kodunu Yanlış Girdiniz.<br>Lütfen <a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=53271629&url=javascript:history.back(1)" data-href="javascript:history.back(1)">Geri</a> Gidip Düzeltiniz...<br> <br> <br> </td> </tr> </table> <%end if%> <%end if%> <%end if%> <%end if%> </td> <td width="20%" background="Temalar/<%=tema%>/blok_bg.gif" valign="top"><br><% call sagbloklar%></td> </tr> </table> <!-- #include file="Tablolar/Alt.asp" --> </tr> </table> </p> </body> </html>