Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2007
    Posts
    2

    Question Unanswered: unable to connect MS SQL server thru vbscript in ASP

    Hi All

    I'm new to ASP coding and trying to connect to SQL server in ASP thru vbscript.
    It works fine in the local machine, but received the "[DBNETLIB][connectionopen[connect().]SQL server does not exist or access denied" in the client machine, can anybody help to sort this out?

    connection string

    conn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=clnt_user;Password=welcome;Initial Catalog=attendance;Data Source=(local)"

    Thanks,
    nags.

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Jul 2007
    Posts
    2
    Hi Satya,

    Thanks for that link, but it deals with ASP only. I'm trying to connect the sql server thru vbscript in an ASP page (the connection string i used is working perfectly with ASP).


    Regards,
    Nags

Posting Permissions

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