can't connect to SQL Server

Results 1 to 2 of 2

Thread: can't connect to SQL Server

  1. #1
    Join Date
    Dec 1969

    Default can't connect to SQL Server

    Hi, I&#039;m having trouble connecting to SQL Server 2000. Using the following code<BR>&#060;%set MyConn = Server.CreateObject("ADODB.Connection") <BR> "DSN=GTDB;UID=sa;Password=;" <BR>I get a login failed error.<BR>Same code works ok with access. <BR>Do I have SQL Server set up wrong?<BR>Thanks for any help. Been at this a while and cant figure it out<BR>Greg

  2. #2
    J. Paul Schmidt Guest

    Default Connections Resource

    Here is a good connections resource:<BR><BR>Connections<BR><BR>"This page contains sample ADO connection strings for ODBC DSN, ODBC DSN-Less, OLE DB Provider, and MS Remote. These sample connection strings are from the Microsoft ADO Newsgroups and are compiled by Carl Prothman, a Microsoft Visual Basic MVP."<BR><BR>Best regards,<BR>-Paul<BR><BR>J. Paul Schmidt, MBA<BR>Databases on the Web<BR><BR><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