CFF KB - Carrz-Fox-Fire Promotions Knowledge Base

 CFF KB is all about 1 thing: The Sharing of Knowledge and the Power we gain from it.
  • Breadrumbs:

  • Microsoft OLE DB Provider for ODBC Drivers error '80004005' (Jet Connection)

    • CFF Knowledge Base - Share With Facebook CFF Knowledge Base - Share on Twitter CFF Knowledge Base - Share on Reddit CFF Knowledge Base - Share on Digg It CFF Knowledge Base - Share on Stumble Upon It CFF Knowledge Base - Share on Delicious
    Share With Friends (Updated 6-8-2010)
  • Article ID:
    21
  • Date Created
    Sunday, October 3, 2010
  • Last Updated
    Wednesday, November 17, 2010
  • This Article Has been Viewed
    1853 times
  • Short Desc
    Make sure that you have the Provider in your connection string code, or this error will happen.
  • Details
    If you forget to add in the Provider= name to your path, this error will happen.


     
    Microsoft OLE DB Provider for ODBC Drivers error '80004005'

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

    /page.asp, line 53


  • Recreate Issue
    In this following code, we have added in another folder, which will cause this error.

    <%
    MyDB_DB = "Microsoft.Jet.OLEDB.4.0;Data Source=g:\inetpub\wwwroot\sitename\data\MyDB.mdb"
    <%
  • Resolve Issue
    To resolve this issue, make sure that you add in the Provider= to the connection string.

    <%
    MyDB_DB = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=g:\inetpub\wwwroot\sitename\data\MyDB.mdb"
    <%

Recent Articles

All Topics

  • Coming Soon - Knowledge Exchange

Trending Articles