« Previous Next »

Thread: Problem to connect DB Access with IIS7

Last post 01-17-2009 1:26 PM by Rai Rabelo. 2 replies.

Average Rating Rate It (5)

RSS

Page 1 of 1 (3 items)

Sort Posts:

  • 01-15-2009, 12:00 PM

    Problem to connect DB Access with IIS7

    Good evening,

    I'm brazilian, sorry me for english language...

     The much has come looking for, how connect DataFile Access using IIS7, i am using two methods, but both returns diferents error:

    For line:
    DB.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBPath2 & ";"

    Return:
    Microsoft OLE DB Provider for ODBC Drivers erro '80004005'

    [Microsoft][Driver ODBC para Microsoft Access] O mecanismo de banco de dados Microsoft Jet não pode abrir o arquivo '(desconhecido)'. Ele já foi aberto em modo exclusivo por outro usuário ou você precisa de permissão para exibir seus dados.

    or The mechanism of database Microsoft Jet can not open the file '(unknown)'. He has already been opened in exclusive mode by another user or you need permission to view its data.


    For line:
    DB.Open "Driver={Microsoft Access Driver (*.mdb)};Dbq=\\path\\banco.mdb;"

    Return:

    Microsoft JET Database Engine erro '80004005'

    Erro não especificado

    or Unknown Error


     

    Someone has had this problem and managed to resolve?

    thanks

  • 01-17-2009, 4:55 AM In reply to

    Re: Problem to connect DB Access with IIS7

    I would verify the drivers are on the server for what version of Access you are using.

    http://weblogs.asp.net/steveschofield/archive/2008/05/03/iis-7-0-access-2007-and-asp-net-2-0.aspx

    Here is an example of Access 2007

    Steve Schofield
    Windows Server MVP - IIS
    http://weblogs.asp.net/steveschofield


    http://www.IISLogs.com
    Log archival solution
    Install, Configure, Forget
  • 01-17-2009, 1:26 PM In reply to

    Re: Problem to connect DB Access with IIS7

    I'm using ASP, not asp.net, i'm downloading Access Database Engine to see if it's solution.

     but my case is ASP, what you say me ?

Page 1 of 1 (3 items)
Microsoft Communities