sql connection problem

Results 1 to 5 of 5

Thread: sql connection problem

  1. #1
    Jason Guest

    Default sql connection problem

    Cant connect to sql server. It is running. There are three error messages i get depending on which string i use in attempting to connect. Either, Login failed for user &#039;C247272-AIUSR_C247272-A&#039;, Cant find sql server, or login not accepted. The first error message, Login failed for user &#039;C247272-AIUSR_C247272-A&#039;, i dont understand. I get that when attempting a DSN connection. I am specifying myself, the current user logged in, and not this account. In fact, I even deleted this account and it still says it. Any help please.<BR><BR>

  2. #2
    SuperDave Guest

    Default RE: sql connection problem

    strCnn = "driver={SQL Server};server=YourServer;uid=YOUR ID;pwd=YOUR PASS;database=YOUR DATABASE NAME" <BR>Set cnn = Server.CreateObject("ADODB.Connection")<BR><BR>sql _1 = "YOUR SQL" <BR>cnn.Open strcnn<BR> <BR>Set RS = Server.CreateObject("ADODB.Recordset")<BR><BR>RS.O pen sql_1, cnn, 3, 3<BR><BR><BR>Try this...

  3. #3
    Jason Guest

    Default different error this time

    Error Type:<BR>Microsoft OLE DB Provider for ODBC Drivers (0x80004005)<BR>[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified<BR><BR>hmm, what does this mean

  4. #4
    SuperDave Guest

    Default RE: different error this time

    Do you have SQL Server Driver install???

  5. #5
    Jason Guest

    Default Driver

    Shouldnt it have installed when SQL server was installed? Im running Windows 2000 pro, and under the Data Sources (ODBC), on the Drivers tab, I have this sql server driver:<BR>version 2000.80.194.00 <BR>File: SQLSRV32.DLL<BR><BR>Isnt that correct?

Posting Permissions

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