ASP with MS ACCESS

PHANI KISHOREKOTTAPALLI · July 10th, 2003, 10:16 PM

Hi,

I want to know how to give odbc or oledb connection from asp to MS

Access. Many one are saying asp not support ms asccess as it supports

to Oracle, is it correct?

Regards

kishore.k

pgtips · July 11th, 2003, 03:34 AM

ASP can certainly connect to Access, like this (just change the bit in red to substitute the path to your database)

Code:

 
    Set oConn = Server.CreateObject("ADODB.Connection")
    oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
              "Data Source=" & Server.MapPath("db\myDb.mdb") & ";" & _
              "User Id=admin;" & _
              "Password="

arp · July 26th, 2003, 12:54 AM

ASP definately supports MS Access since both are Microsoft products. Here is another way to connect MS Access database through ASP. Replace variable in RED with your values.

set con = Server.Createobject("ADODB.connection")
connStr= "DRIVER={Microsoft Access Driver (*.mdb)};"& _
"DBQ=" & server.mappath("myDB.mdb") & ";UID=userid;PWD=password"

con.Open connStr

:) ARP

pgtips · July 28th, 2003, 06:31 AM

Hi arp,

I think you should be aware that this is not a good connection string for Access from ASP. Your example uses the Access ODBC driver which is not recommended for ASP. You should always use the native Jet OLEDB provider from ASP.

See MSKB article 222135 for details.

regards
Phil

arp · July 28th, 2003, 07:07 AM

Hey Phil,

I am very thankful to you for this reply. I know JET OLEDB providers, But never able to figure out when to use ODBC or Jet OLEDB in ASP. You have provided information which I was looking for. It helped me a lot in my work.

Thank you

Regard,
arp :)

cbrknight1 · May 10th, 2005, 09:55 AM

Hi guys I creaded test.mdb MS ACCESS DATABASE . when I am trying to connect using
Dim dbconn, sql, dbcomm
        dbconn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; " & _
                                      "Data Source=" & Server.MapPath("test.mdb") & ";" & _
                                        "User Id=admin;" & _
                                        "Password=")
        dbconn.Open()

As you posted arlier I get error:
Unspecified error
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Unspecified error

PLEASE HELP . I HAVE TRIED EVERYTHING

--Alex Z.

mat41 · May 10th, 2005, 06:53 PM

I havnt used access for some time, this is a currently working connection string:

Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=C:\Inetpub\wwwroot\rootDir\DB\name.md b"

A good resource www.connectionstrings.com
BTW: Dont forget to give the IUSER the correct permissions to the dir where the .mdb file is

Wind is your friend
Matt