#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Posts
    109
    Rep Power
    13

    Problem connecting classic asp to SQLserver 2008 express via IIS7 on win7 64bit


    Problem connecting a classic asp project to SQLserver 2008 express with this query strings:

    conn = "Driver={SQL Server Native Client 10.0}; Server=.\SQLEXPRESS; Database= database; Trusted_Connection=yes"
    conn = "Provider=SQLOLEDB;Data Source=.\SQLEXPRESS;Initial Catalog=database;UserID=sa;Password=123"
    conn = "Driver={SQL Server}; Server=.\SQLEXPRESS; Initial Catalog= database;Integrated Security=True;Network Library =dbmssocn"
    conn = "Provider=SQLNCLI10.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=database;Data Source=(local);"
    _______________________
    RETURNED ERROR:
    Classic ASP return this error: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
    _______________________
    SQL Server: Authentication: SQL Server and windows authentication mode
    Iím using IIS7 in a win 64bit
    Do I need a DB user and password in sql DB and querystring? is the iis7? win7 64bit?
    ______________________
    Note: VB.NET can access with this conn String: "Data Source=.\SQLEXPRESS;Initial Catalog=nData;Integrated Security=True"

    Thanks
    atferraz
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2010
    Posts
    15
    Rep Power
    0
    why do you have 4 different connection strings ?

    only the last one is going to be applied.

    for assistance on how to write a connection string look here:
    http://connectionstrings.com/
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2005
    Location
    Dundee, Scotland
    Posts
    5
    Rep Power
    0
    Have you enabled remote connection for Express?

    had an article for troubleshooting sql express errors but cant post the url, sorry.


    Hope that helps

    regards

    Ribs

IMN logo majestic logo threadwatch logo seochat tools logo