Error 800401f9 when opening dsn

Results 1 to 3 of 3

Thread: Error 800401f9 when opening dsn

  1. #1
    David Mount Guest

    Default Error 800401f9 when opening dsn

    My company has installed Windows 2000 with IIS. I am trying to open a dsn that is defined using odbc on the server. for this code:<BR>&#060;% set oConn = server.CreateObject("ADODB.connection")<BR> oConn.Open "DSN=odbcacc;"<BR><BR>I get:<BR>error &#039 800401f9&#039<BR>error in the DLL<BR>progtest.asp, line 2<BR><BR>I created the odbc connection as a system dsn. It points to an Access 2000 database.<BR><BR>Any help please!!

  2. #2
    Join Date
    Dec 1969

    Default RE: Error 800401f9 when opening dsn

    Try entering admin for the username and an empty string for the password.

  3. #3
    Cal Guest

    Default RE: Error 800401f9 when opening dsn

    I had the same problem after installing ColdFusion Server<BR><BR>It turns out Darren wins the prize (he emailed me the seven steps to success):<BR><BR>1&#062; unregister msado15.dll<BR>2&#062; reboot the machine<BR>3&#062; re-register msado15.dll<BR>4&#062; unregister oledb32.dll<BR>5&#062; reboot the machine<BR>6&#062; re-register oledb32.dll<BR>7&#062; reboot the machine.<BR><BR>Fantastic! She works like a dream.<BR><BR>Cheers,<BR><BR>Cal<BR>

Posting Permissions

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