Creating database on the fly

Results 1 to 2 of 2

Thread: Creating database on the fly

  1. #1
    Join Date
    Dec 1969

    Default Creating database on the fly

    I&#039;m developing an ASP component that creates an Access database on-the-fly. Although it works on any machine running Windows 2000, it seems to crash on Windows NT. Every time the component tries to create a database on NT, I get the following error:<BR><BR>Automation error Library not registered.<BR><BR>Does anyone have any idea what this could be? I&#039;m using the following code when creating the database:<BR><BR>Set myCatalog = New ADOX.Catalog<BR>myCatalog.Create "Provider=Microsoft.Jet.OLEDB.4.0;" & _<BR> "Jet OLEDB:Engine Type=5;" & _<BR> "Data Source=" & Server.MapPath("test.mdb")<BR><BR>I&#039;ve tried changing the Jet OLEDB:Engine Type from 5 to 4. Didn&#039;t work. I tried removing Jet OLEDB:Engine Type altogether. Worked fine on 2000, but still got the same "Automation error" message. Does anyone have any ideas?<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default Most likely....

    The NT box has a pre-ADOX MDAC on it. Try updating to 2.5, or 2.7 and Jet4sp3

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts