Professional Web Applications Themes

Data Provider could not be initialized. - ASP Database

Hi, My ASP application works great! Until.... The Access 2000 database I have resides on an internal server here at my place of business. If I make a copy (press CTRL+C) and paste the database to my desktop, my ASP application stops working, and I do wait for the file to be completely copied until I try to access my application. It stops working until I make some insignificant change to my connection string and save it. Has anyone else experienced this error ever? Or better yet know how to fix it? eg. strConnection = "Provider=MSDataShape;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & ...

  1. #1

    Default Data Provider could not be initialized.

    Hi,

    My ASP application works great! Until.... The Access 2000 database I have
    resides on an internal server here at my place of business. If I make a copy
    (press CTRL+C) and paste the database to my desktop, my ASP application stops
    working, and I do wait for the file to be completely copied until I try to
    access my application. It stops working until I make some insignificant
    change to my connection string and save it. Has anyone else experienced this
    error ever? Or better yet know how to fix it?

    eg. strConnection = "Provider=MSDataShape;DRIVER={Microsoft Access Driver
    (*.mdb)};DBQ=" & server.mappath("db\TIME.mdb") & ";UID=admin;PWD=password"

    change it to...

    strConnection = "Provider=MSDataShape;DRIVER={Microsoft Access Driver
    (*.mdb)};DBQ=" & server.mappath("db\TIME.mdb") & ";UID=;PWD=password"

    or vice versa

    Thanks!

    Steve Guest

  2. #2

    Default Re: Data Provider could not be initialized.

    Well it looks like you need to check out the following web pages for
    some of your problems at least. That is to say stop using ODBC/DSN to
    connect to your database.

    http://www.aspfaq.com/show.asp?id=2126

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/ado_deprecated_components.asp

    Steve wrote:
     

    Joker Guest

  3. #3

    Default Re: Data Provider could not be initialized.

    Please read the following links.

    http://www.blakjak.demon.co.uk/mul_crss.htm

    http://www.aspfaq.com/etiquette.asp?id=5003

    Joker wrote:
     
    >[/ref]

    Joker Guest

Similar Threads

  1. xml into a data provider
    By dragonair1 in forum Macromedia Flex General Discussion
    Replies: 2
    Last Post: May 25th, 05:44 AM
  2. Data Grid Provider, XML attributes
    By the_lastBoyScout in forum Macromedia Flex General Discussion
    Replies: 2
    Last Post: April 21st, 05:57 PM
  3. HTML Returned in Data provider as XML
    By leotemp in forum Macromedia Flex General Discussion
    Replies: 2
    Last Post: July 6th, 02:22 AM
  4. How to write custom data provider
    By jkok2000 in forum Macromedia Flex General Discussion
    Replies: 6
    Last Post: August 1st, 09:26 PM
  5. Data Provider for .NET interface to DB2 8.1
    By Fred Prose in forum IBM DB2
    Replies: 1
    Last Post: September 9th, 10:18 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139