Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Access database RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I have been trying but with no success to connect to an access database using ASP.  Basically I am trying to use WHS as my testing environment.  I used Whiist to set up my website and have the database in D:/database folder.  I setup a DSN in WHS which my copy of Dreamweaver finds without problem.  However when the website runs and tries to access the database I get the following error 

    Microsoft OLE DB Provider for ODBC Drivers error '80004005'

    [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

     

     

    Does anyone have an answer to this problem?

     

    Thanks for your help

    Wednesday, March 19, 2008 1:32 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

     

    OK I seem to have solved it, although I am now balder than before.

     

    Installed a seperate drive E:

    put my database in here ,gave access permissions

    deleted all dsn

    recreated dsn

    restarted iis

    Worked

    Thursday, March 20, 2008 12:31 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Is the database set to Read-only?

     

    Wednesday, March 19, 2008 7:18 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

     

    No the database is set to read and write all users,  the same database works on my hosted server using a DSN.

     

    Thx

    Wednesday, March 19, 2008 7:26 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    And the permissions on the file's properties are correct?

     

    Wednesday, March 19, 2008 7:34 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

     

    Yes as far as I am aware all permissions are granted.
    Wednesday, March 19, 2008 7:43 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

     

    OK I seem to have solved it, although I am now balder than before.

     

    Installed a seperate drive E:

    put my database in here ,gave access permissions

    deleted all dsn

    recreated dsn

    restarted iis

    Worked

    Thursday, March 20, 2008 12:31 AM