Hallo, 

Ich habe so ein typisches Montag-Morgen Problem... Ich schaffe es einfach nicht ein 
Recordset zu �ffnen...

Die Verbindung wird aufgebaut, jedenfals zeigt es keine Fehlermeldung wenn ich den 
RecordSet Bereich zu Kommentar mache... Wo liegt der Fehler? Es kommt die Meldung, 
dass die Seite nicht angezeigt werden kann...
 
        'Verbindungsdetails
        username = "user"               
        password = "pwd"
        sqlserver = "SERVER\ETA_DEV"   
        database = "IPETA"                 
        driver = "{SQL Server}"            

        'Verbindung herstellen
        Set db = Server.CreateObject("ADODB.Connection")
        db.Open "Driver=" & driver & _ 
                ";Server=" & sqlserver & _
                ";Database=" & database & _
                ";Uid=" & username & _
                ";Pwd=" & password

        'Recordset �ffnen
        tbl = "tbl_land" 
        sql = "SELECT * FROM " & tbl
      set rs = db.Execute(sql)
************************************************************************************
This e-mail message is intended only for the addressee(s) and contains
information which may be confidential. If you are not the intended
recipient please do not read, save, forward, disclose or copy the contents
of this e-mail. If this e-mail has been sent to you in error, please delete this 
e-mail and any copies or links to this e-mail completely and immediately
from your system. We also like to inform you that communication via e-mail
over the Internet is insecure because third parties may have the possibility
to access and manipulate e-mails.

Any views expressed in this message are those of the individual sender,
except where the sender specifically states them to be the views of
The Swatch Group Ltd.
************************************************************************************

| Oft Gefragtes: http://www.aspgerman.com/aspgerman/faq/
| [aspdebeginners] als [email protected] subscribed
| http://www.aspgerman.com/archiv/aspdebeginners/ = Listenarchiv
| Sie knnen sich unter folgender URL an- und abmelden:
| http://www.aspgerman.com/aspgerman/listen/anmelden/aspdebeginners.asp

Antwort per Email an