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

    Join Date
    Jan 2003
    Posts
    23
    Rep Power
    0

    Accessing SQL Server


    I'm trying to connect to a sql server, but am getting the following error...


    Microsoft OLE DB Provider for ODBC Drivers error '80004005'

    [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

    /login_submit.asp, line 23


    this is login_submit.asp line 23
    oConn.Open Application("WR_ConnectionString")

    which uses the connection string from the global.asa
    Application("WR_ConnectionString") = "Provider=SQLOLEDB.1;Password=password;Persist Security Info=True;User ID=user;Initial Catalog=[catalog];Data Source=[DS];"


    Any help would be appreciated, thanks.
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2003
    Posts
    23
    Rep Power
    0
    Okay, thanks, I'll give that a try.

IMN logo majestic logo threadwatch logo seochat tools logo