I should know this

Results 1 to 2 of 2

Thread: I should know this

  1. #1
    Join Date
    Dec 1969

    Default I should know this

    Does anyone see why this connection string won&#039;t work. I am trying to connect to the sql server. <BR><BR>objConn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=corrandprev;Data Source=NPWEB01"<BR> <BR><BR>it is telling me that <BR><BR>Microsoft OLE DB Provider for SQL Server error &#039;80004005&#039; <BR><BR>Cannot open database requested in login &#039;corrandprev&#039;. Login fails. <BR><BR>/correctivepreventive/pickcc.asp, line 50 <BR><BR><BR>I have done this dozens of times I don&#039;t know why this one won&#039;t work.

  2. #2
    Join Date
    Dec 1969

    Default RE: I should know this

    Since you are using a DSN less connection you got to supply the login id and password.

Posting Permissions

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