How to connect to .mdb file on Server using DreamweaverMx2004

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jimbreau
    New Member
    • May 2007
    • 2

    How to connect to .mdb file on Server using DreamweaverMx2004

    Re: Dreamweaver Mx 2004 ASP VBscript:

    1. The following is my connection script at "conn.asp"


    Dim MM_connDWDynami cServer_STRING
    MM_connDWDynami cServer_STRING = "Driver={Micros oft Access Driver (*.mdb)}; DBQ=E:\kunden\h omepages\28\d15 3929211\db\nati onaEx .mdb;"
    Set Conn = Server.CreateOb ject("ADODB.Con nection")
    Conn.connection string = MM_connDWDynami cServer_STRING
    Conn.Open %>

    The path actually is supplied by the host, but its not working. Is there any error on the script?


    2. If I would like to define the connection by going thru ( insert > application objects > recorset > define .....what should I type in at connection string text box to generate the code / script shown above (#`1) in the "connection.asp " page ?
Working...