sql server

Results 1 to 2 of 2

Thread: sql server

  1. #1
    Frank W. Guest

    Default sql server

    This is how I connect to an Access DB:<BR>===<BR>set rs = Server.CreateObject("adodb.Recordset")<BR>set conn = Server.CreateObject("ADODB.Connection")<BR>connect me = "DSN=bubba"<BR><BR>SQLSTMT = "SELECT * FROM login WHERE login_id= " & id<BR>rs.open sqlstmt, connectme<BR>===<BR><BR>How would it differ if I were to connect to SQL Server 7.0? I&#039m new to sql server.

  2. #2
    Jairo Guest

    Default RE: sql server

    Frank,<BR>There&#039s no difference, except you&#039ll probably have to supply a userid and password in your DSN.<BR>HTH,<BR>Jairo<BR>http://www.citywebarchitects.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •