Cant connect to sql server 2000. Help

Results 1 to 2 of 2

Thread: Cant connect to sql server 2000. Help

  1. #1
    Jason Guest

    Default Cant connect to sql server 2000. Help

    I just installed sql 2000 and i cant get a connection string that works. It either says login failed or cannot find server. Ive tried DSN, dsn-less. Cant get anything to work. <BR><BR>set oConn = server.CreateObject("ADODB.Connection")<BR>oConn.O pen "Driver={SQL Server};Server=local;Database=Hotel;UID=sa"<BR><BR >Any help?

  2. #2
    Join Date
    Dec 1969

    Default Is the service running?

    Can you open up the Enterprise Manager and view your database and tables? I don&#039;t see a password designator here? Even if it&#039;s blank, I believe you have to specific it. Also, in the example I gave you, local is surrounded by ()<BR><BR>

Posting Permissions

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