Access ODBC and DSN

Discussion in 'Databases' started by ajd, Jul 18, 2007.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. ajd

    ajd

    I have an Access db in _database directory and get the error msg.


    "[Microsoft] [ODBC] Data source name not found and no default driver


    specified."


    In my Data Source Administrator the DSN is "mm020304".


    In Front Page the DSN is "mm020304".


    In the Discountasp Database Management Access ODBC Tool the DSN is "myusername_mm020304".


    Front Page 2000 will not allow any "_" in the name. How do I get the DSN the same in all three


    places and is this what is causing the problem?


    Thanks for any help.


    ajd
     
    ajd, Jul 18, 2007
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    Try use OleDB connection. OleDB is much more efficient and stable than ODBC.


    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Jul 18, 2007
    #2
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page