SQL Server does not exist or access denied


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: SQL Server does not exist or access denied

  1. #1
    Aruna Guest

    SQL Server does not exist or access denied


    objConn.Open("Provider=SQLOLEDB;Data Source=ITSSQLDSN;User Id=joynerlm;Password=general")

    I installed SQL Server on my system. Database is ITSSQL and DSN is ITSSQLDSN.
    When I run my ASP code it is giving "SQL Server does not exist or access
    denied". Why?




  2. #2
    Harish Kumar Guest

    Re: SQL Server does not exist or access denied


    Since you're saying the particular database is there, the error could be probably
    in the string that you're trying to open with. Why don't you create a UDL
    file and then copy the connection string from there? You can create UDL file
    in the following way -

    1. go to desktop
    2. right click and select text document
    3. save the text document as UDL file - for example "harish.udl"
    4. go to provider tab and select the driver
    5. go to connection tab and select yr server & database
    6. test connection and when it says ok come out
    7. now right click on the icon and open the UDL file with notepad
    8. copy the string and get started.

    HTH,
    Harish


    "Aruna" <arunavennapusala@hotmail.com> wrote:
    >
    >objConn.Open("Provider=SQLOLEDB;Data Source=ITSSQLDSN;User Id=joynerlm;Password=general")
    >
    >I installed SQL Server on my system. Database is ITSSQL and DSN is ITSSQLDSN.
    >When I run my ASP code it is giving "SQL Server does not exist or access
    >denied". Why?
    >
    >
    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center