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

Search the boards