Results 1 to 3 of 3

Thread: Asp+sql sercer

  1. #1
    Join Date
    Jan 2005
    Posts
    362

    Unanswered: Asp+sql sercer

    I have sql server express at my PC-windows xp professional, I try to connect to a table via asp (queryString :"Driver={SQL Server};" &"Server=localhost;" & _
    "Database=local;" & "Uid=dimis;" & "Pwd=network;" but there is an error
    Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    [Microsoft][ODBC SQL Server Driver][DBNETLIB]"The SQL server does not exist or there is no permission.
    I can login with EMS lite both with sql server Auth. and windows auth.
    What is fault?
    Dimis

  2. #2
    Join Date
    Jan 2005
    Posts
    362

    Solution/sql express

    I try this: Provider=SQLOLEDB;Persist Security Info=False;User ID=nikos;pwd=nikos;Initial Catalog=LOCAL;Data Source=localhost\SQLEXPRESS;Connect Timeout=120"

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Refer KBA http://support.microsoft.com/kb/328306/en-us to resolve the issue.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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