locked
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified RRS feed

  • Question

  • User1869323457 posted

     Hi everyone,

    I stuck while accessing foxprox dbf file using following connection string.

    Driver={Microsoft Visual FoxPro Driver};SourceDB=~\App_Data\;Sequence=machine;SourceType=DBF;Exclusive=No;

    I develop a web api project using VS 2013 with dotnet framework 4.5. Fox pro xyz.dbf file is reside under App_Data folder.

    Whenever I run it from Microsoft Visual Studio 2013 develoupment server ( http://localhost:2759/ ) it's working fine - Everything works normally. But after I published my web api to IIS 7,  it’s showing me following error message:

    ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

    I've tried everything that I could, but nothing made it works. I also granted full permission to EveryOne user on the App_Data folder, it does not work either. My logged-in user is domain user.

    Is it my IIS(windows7) setting that wrong? or is it windows error ? or I'm using the wrong methods to accessing fox pro dbf file? or is there is any specific setting required in the fox pro(dbf) files? or my coding is wrong? or anybody have any suggestion? thanks.

    Any comments and suggestion is welcomed, and I really appriciate it. Thanks

    Wednesday, October 29, 2014 3:48 AM

Answers

  • User-821857111 posted

    Try enabling 32 bit applications in IIS for the site' application pool.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, October 29, 2014 4:02 AM

All replies

  • User-1716253493 posted

    Try change SourceDB like this SourceDB=d:\myapp\App_Data\xyz.dbf;

    Wednesday, October 29, 2014 4:00 AM
  • User-821857111 posted

    Try enabling 32 bit applications in IIS for the site' application pool.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, October 29, 2014 4:02 AM