Posted By: Schotek (Bc. Schotek) on 'CZscripts' Title: Re: ASP problem Date: Fri Oct 8 10:03:38 1999 Take jsem mel problemy s pripojenim na SQL server, ale uz mi to chodi - prikladam vypis, jak to mam udelane: Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open "SERVER=technik;DRIVER=SQL Server;DSN=LocalServer;UID=sa;PWD=;DATABASE=Pokusna;" set rstMain = CreateObject("ADODB.Recordset") rstMain.Open "SELECT * FROM Lidi WHERE (Lidi.Prijmeni Not Like '%ova%') ORDER BY Lidi.Prijmeni", Conn, adOpenKeyset,adLockReadOnly radky conn.open a rstMain.Open jsou dlouhe a BBSka je roztrhala na dve radky - jinak je to okay... D.J. Schotek (software i hardware tvorici...) http://www.bpo.cz/~schotek